Call One Access Application from Another

[Mike Thomas]

What would be the syntax to open and run one application from another?

The syntax from the run command box would be:

"c:\Program Files\Microsoft Office\Office\msaccess.exe"
"d:\Apps\ChangeMgt.mdb" /x SetupInvoice

where SetupInvoice is a macro which just calls a procedure module,
"ExportInvoice" which does its thing and closes the application.

Is there a way to ope then same app and have it simply execute the module
without having to call a macro first?

Many thanks
Mike Thomas

[Van T. Dinh]

The other way is to use a (dummy) Form execute your code in the Form_Open or
Form_Load Event of the (dummy) Form. You will need to nominate this Form as
the StartUp Form for your database.

/x MacroName on the command-line should work fine.

--
HTH
Van T. Dinh

"Mike Thomas" <mi**@ease.com> wrote in message
news:6h**********************@newssvr28.news.prodi gy.com...

What would be the syntax to open and run one application from another?

The syntax from the run command box would be:

"c:\Program Files\Microsoft Office\Office\msaccess.exe"
"d:\Apps\ChangeMgt.mdb" /x SetupInvoice

where SetupInvoice is a macro which just calls a procedure module,
"ExportInvoice" which does its thing and closes the application.

Is there a way to ope then same app and have it simply execute the module
without having to call a macro first?

Many thanks
Mike Thomas