Solved

MS Access 2003 - Open minimized and run print report

Posted on 2006-11-16
2
1,068 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
2 Comments
 
LVL 4

Assisted Solution

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

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

Accepted Solution

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

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


jaffer
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

828 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