Call a macro from commandline with existing autoexec

P

Phil Smith

I have a database with an autoexec macro, which calls up a switchboard
form, and has a bunch of other macros which run reports, open data entry
forms, etc.

I want to create a windows shortcut, which will open the database and
call a different macro, which dumps a report to the printer and closes
the database.

What I have opens the database and runs the autoexec macro.

How do I get the system to not run the autoexec, but run my "print
report" macro instead?
 
A

Albert D. Kallal

the simplest solution here is to create a new mdb file, place the report and
simply put in links to the table(s) that the report needs.

You now have a stand alone application + report. You can then use a windows
script, and use the windows scheduler to run this report (or whatever) on a
daily/weekly bases etc...

I explain this process here:
http://www.members.shaw.ca/AlbertKallal//BatchJobs/Index.html

I suppose someone could fiddle around and try and by-pass your startup
stuff, but really, I think it far smoother to not mess with your startup
stuff.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top