Switch database in current Access 2003 application window

[Guest]

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?

 

[Brendan Reynolds]

I haven't used this myself, Jeff, but Michael Kaplan's 'TSI SOON (Shut One,
Open New)' add-in sounds like it should do what you want ...

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=-1#8

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.