Create a Macro to Open another Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

connie - 25 Jan 2006 14:29 GMT

Can I create a macro in one database that would open a second database (with
it's own switchboard menu)? I want to have a button on a menu that would run
the macro.

I can't figure out where to start. Help!
Thanks

Reply to this Message

Steve Schapel - 25 Jan 2006 18:26 GMT

Connie,

Use the RunApp action in your macro. The syntax for the Command Line
argument would be something like this...
"C:\Program Files\Microsoft Office\...\Msaccess.exe"
"C:\YourFolder\YourDb.mdb"

Signature

Steve Schapel, Microsoft Access MVP

> Can I create a macro in one database that would open a second database (with
> it's own switchboard menu)? I want to have a button on a menu that would run
> the macro.
>
> I can't figure out where to start. Help!
> Thanks

Reply to this Message