Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MS Access 2003 - Open minimized and run print report

Posted on 2006-11-16
2
Medium Priority
?
1,120 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 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

810 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