bypass startup display form?

[Albert D.Kallal]

You could just create a new mdb file, and link the tables to the existing
mdb.

That way, you can have a "special" version that don't have a startup
window.

Another approach is to use the /cmd like:

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

Then, in your forms start up code, you can go:

if command <> "" then
docmd.RunMacro command
application.quit
end if

 

[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.