?
Solved

MS Access 2003 - Open minimized and run print report

Posted on 2006-11-16
2
Medium Priority
?
1,099 Views
Last Modified: 2012-08-13
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  
0
Comment
Question by:Lou Dufresne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Assisted Solution

by:DoubleJ92
DoubleJ92 earned 400 total points
ID: 17958307
Try this:

START /min "" "<insert path here>\dbname.mdb"
0
 
LVL 27

Accepted Solution

by:
jjafferr earned 1600 total points
ID: 17959561
in your AutoExec Marco, have the following line:

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


jaffer
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question