Call a macro from commandline with existing autoexec

  • Thread starter Thread starter Phil Smith
  • Start date Start date
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?
 
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.....
 
Back
Top