Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export forms and vba code

Status
Not open for further replies.

20dogdays

Programmer
Jun 13, 2007
10
US
I have successfully exported a form to another DB, how do I export the associated VBA code?

tia
 
The code should normally go with the form. Did you check? How did you export? Did you open the other MDB and select File->Get External Data->Import?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
I made the form I wanted the active form then File->export and then -> to the other DB (.mdb file).
 
I just tried this and my code went with the form to the other MDB file.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
This is ACCESS 2000. I started all over and tried to export the same way (File->export etc). My code did not go with the form. When I View->code on the form in the new DB it gave me code for another form in the new DB. That being done I reversed my way of thinking. I am adding a form to a project and have to make some changes to an existing form. Since I had everything in the new project except for updated tables I exported the tables from the old project to the new, deleted the old project and renamed the new. It seems to work, thank you for your input.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top