macro switch

[CJBIRKIN]

Hello

I am trying to run a .bat file to open a data base and then run a macro. From what i looked at in the forums and the help file this should be the correct syntax:
"M:\Information\procedures\OURLOG.mdb" /x EMAILREPORT

with /x as the switch to trigger the macro. I have mananged to get other switches to work but not this one. Any ideas?

Chris

 

[mattbland]

cant u use the line in the .bat file to open the database, then use the startup function to open a form, and use the forms on open to run the macro? then close the form, automatically? you could resize the form so its really small and near un-noticeable.

 

[CJBIRKIN]

Hello
Thanks for the suggestion, but there appears to be a problem with the arguments. Some work some don't. I suspect there may be some options unchecked or maybe there are network permissions for opening DB's which i haven't got, who knows!!

Chris

 

[Pat Hartman]

I don't know if this is the problem, but whenever I have done this, I have run Access with the parameter of the db name and followed that with the parameters for my app. So you end up with something like:

C:\somepath\MsAccess.exe "M:\Information\procedures\OURLOG.mdb" /x EMAILREPORT

 

[CJBIRKIN]

Hello
Thanks for the suggestions. I've tried every combination i can think of and whilst i can open the DB no problem nothing will run the macro. Back to the drawing board!
Cheers
Chris