View Single Post
  #7 (permalink)  
Old August 31st, 2005, 04:06 AM
dartcoach dartcoach is offline
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Brendan,
This will open the other database on top of the one you open it from:

Create a button on one of your forms and in the on click event put this:

Myfile = "C:\Kevins Stuff\Juice.mdb"
retval = Shell("msAccess.exe " & """" & Myfile & """")

It doesn't close the one you open it from, I haven't got that far yet.

Kevin

dartcoach
Reply With Quote