Starting access from a Menu

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I have 4 small Access projects, I would like to make a menu with 4 command
buttons, when I click on a project Access opens and that projects main menu
opens. Can this be done or do you have to open them individually?

Thank You
 
NotGood@All,

Yes, what you want to do is quite possible. Here is some code that was
provided in answer to a very simular question and may be helpful to you:

To fire up the other app, you could use:
Application.FollowHyperlink "C:\MyPath\MyFile.mdb"

If you have multiple versions of Acess installed and want to ensure you end
up using the same one:
Call Shell(SysCmd(acSysCmdAccessDir) & _
"msaccess.exe C:\MyPath\MyFile.mdb", vbNormalFocus)

Then to quit the current application:
DoCmd.Quit
 
Back
Top