Passing parameters from command line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a program I can start other programs, sych as ACCESS, by using command line paramters. I need to pass a name to be fed into a macro of ACCESS

I have got as far as
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS11.EXE" "C:\mydatabase.mdb" /x mymacr

This will start Access and open mydatabase and run mymacr
BUT it will open a new session every time and I can not pass on the parameters which the macro wants

Can you please let me know how open a new session of ACCESS only if it is not already openned and to pass the parameter to the session in either case

Many thanks and regards
Sha
 
Use the DDE functions for Access.
Check the Online Help file
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Line Switch in a hyperlink? 4
parameter value in command line switch 4
Open an Access form from command line with parameter 5
Can I pass a variable via command line? 1
passing odbc parameters via the command line 1
Passing a Parameter into a MS Access 2007 Form 0
Access Command to run access, open to specific form and specific record 1
run access macro from excel pass parameter 7

Back
Top