Bypass Startup Display Form?

[Phil Hellmuth]

I have an Access DB with a defined Startup Display Form. I also want to
be able call a macro via Windows Scheduled Tasks using a command like like:

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\MY
Documents\database.mdb" /x "macRunMe"

However, when the task begins to run and the database opens, the defined
Startup Display Form is opened, and the command to run the macro is
ignored. Are there any workarounds for this?

Thanks in advance.

 

[Guest]

Try naming the macro Autoexec and dropping the /x "macRunMe" from the command
line.

 

[Steve Schapel]

Phil,

I can think of no reason for the running of the macro to be affected by
the existence of a startup form. Is there macro or code that runs on
the Open or Load event of the startup form? What are the details of the
macRunMe macro, i.e. what actions? The usual syntax of the command line
does not include ""s around the name of the macro - try it like this...
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\My
Documents\database.mdb" /x macRunMe