Open Database Macro?

[mr_connell]

Can you create a macro in one database to open a totally different database?
If so...HOW?

 

[VicRauch]

Yes you can. Here is the actual statement from one of my Access databases where I start another database.

      RetVal = Shell("""" & SysCmd(acSysCmdAccessDir) & "MSACCESS.EXE""  " & _
                "g:\apps\JobRecords\RefreshDB.mdb" & " /cmd """ & CurrentDb().Name & _
                """", vbNormalFocus)

And it is followed by this statement:

    Application.Quit

Retval is a global variable I use for VERY temporary things. In this case it is never used, except as the receipent of the Shell function's return.
This is then followed by the application quit, so the Refresh database can copy the network MASTER back to the local C: drive. (the Refresh database then recalls the original DB name)

Last note: The path to the RefreshDB.mdb should be in a Const variable defined in my Declarations area. And yes, I do plan on fixing it.
HTH,

 

[mr_connell]

Where do i type this information?
And where do i insert my database names and locations into the equation?
Thank you very much for your help.

 

[VicRauch]

This information goes where ever you want to put it. Best to put it within the OnClick event of a button you create to open another database.

If you would look at the "equation" you would see something that has .mdb following it. A Microsoft Access database is known by the suffix of .mdb. Of course, the stuff in front of the database name is the path (location) of the database.

HTH,

 

[mr_connell]

Microsoft Visual Basic error keeps comming up "Compile error: Variable not defined" and it is highlighting the "RetVal ="
What can i do to fix this?

 

[VicRauch]

define RetVal.

dim RetVal as variant