export/import access 97 forms

B

bm

I am looking for a way to move forms from one access 97
database to another. I presume forms should be in binary
format. Is there a way to export forms such that they can
be imported back?

thanks
 
D

Douglas J. Steele

Using the GUI, from within database 2, select File | Get External Data |
Import from the menu bar, find database 1 in the File Open dialogue that
appears, then select the form(s) you want to import into the database.

To do it programmatically, look up TransferDatabase in the Help file.

There's no documented way to save just a form, although there is an
undocumented approach available. You can use the SaveAsText method of the
Application object to save it (as a text file) from the first database, and
LoadFromText to import it to the second database.

Application.SaveAsText acForm, "MyForm", "D:\Document\MyForm.txt"

Application.LoadFromText acForm, "MyForm", "D:\Document\MyForm.txt"

(Remember, though, that there are always risks of future incompatibility
associated with undocumented features)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top