Bypass Module

[dhoover via AccessMonster.com]

I have a user that will open database2 from a form in database1 and I need to
bypass the startup module in database2 so that I can have a report
automatically run and print for this user and then automatically close
database2. This is the only instance in which I would need to have that
startup module bypassed. Is there a way to do this?

 

[Douglas J. Steele]

It's ugly (because it uses SendKeys), but
http://support.microsoft.com/?id=147816 has code about half-way down (in a
section labelled "Bypassing Startup Settings When Opening a Database")

Don't worry that the KB article only lists Access 95 and Access 97: it
hasn't improved in newer versions.

 

[Albert D. Kallal]

Why not have linked tables to the database, and *copy* the report to your
database.....

You can even do a transferdatabase command to do this.

Another way is to have a *macro* in the 2nd database launch the start-up
code.

Then, to run the report, you simply execute a transferdatabase command to
REPLACE the "autoexec" macro. Run your report via automaton, and then
replace back the start-up macro....