MS Access 2003 - Open minimized and run print report

I have an application process that opens an MS Access application once an hour and runs a report from the application.

I open the MS access Application from a batch file and when it opens it runs an autoexec macro to run the report.
Once the report is complete the macro closes the database.

How can I open the MS access App minimized or in background from the batch file and let it process the report without disturbing the user everytime the report runs?


Thank you in advance for your assistance.

Lou  
LVL 1
Lou DufresneIT Business Analyst CSM / Project ManagerAsked:
Who is Participating?
 
jjafferrCommented:
in your AutoExec Marco, have the following line:

runcommand  >AppMinimize              ' add this line
OpenReport  > ....
Quit


jaffer
0
 
DoubleJ92Commented:
Try this:

START /min "" "<insert path here>\dbname.mdb"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.