Switch database in current Access 2003 application window

J

Jeff Grundy

In Access 97 I reluctantly used the following code to switch to another
database in the Access 97 application window ‘ SendKeys "%FO" & strInMDB &
"~" ‘ . This is no longer working. What I am trying to do is equivalent to
opening another database using the file menu.

Is there a better (VBA) way to close the current mdb and open another mdb in
the same Access 2003 application window?
 

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

Similar Threads

How do I clear a form? 0
Automating CompactRepair--"db in use" error 3
Switch focus between multiple word applications 1
Workgroup 97 4
Using VBA to switch to a particular Access database 5
Open One Access application with the other 0
Compact and Repair in Access 07 1
Access 2013 and MDB Files 1

Top