 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2005Auto start Access when computer is turned on
What I want to do is have MS Access application automatically print a report at 8 AM every day or when the computer is turned on. Do I use some kind of batch file? Any ideas would be helpful Create a shortcut that includes the path to msaccess.exe and the database file, and put it in the computer's Startup group. I'm assuming you can figure out how to print the report at 8 AM, and when the database launches. If not, post back.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > What I want to do is have MS Access application > automatically print a report at 8 AM every day or when > the computer is turned on. > Do I use some kind of batch file? > > Any ideas would be helpful If you use a batchfile to start your database you can specify which file you want to open: "start c:\temp\mydb.mdb". But that is a subject that doesn't belong in this topic. Staying with access this might be a solution: Leave your access open while the computer running. Put a shortcut to the database in your startup folder. Make a autoexec macro, this macro runs automaticly when the database is fired up. Open a form in the macro. Then use the timer event of the form to check if it's 8 am and print the form. Kind regards > What I want to do is have MS Access application > automatically print a report at 8 AM every day or when > the computer is turned on. > Do I use some kind of batch file? > > Any ideas would be helpful I seem to recall that there's a command line switch which can be used to call a specific maco. MVP's Am I right or still delusional? David H > If you use a batchfile to start your database you can specify which file you > want to open: "start c:\temp\mydb.mdb". But that is a subject that doesn't [quoted text clipped - 15 lines] >> >>Any ideas would be helpful Yes. /x SignatureKen Snell <MS ACCESS MVP> >I seem to recall that there's a command line switch which can be used to >call a specific maco. MVP's Am I right or still delusional? [quoted text clipped - 20 lines] >>> >>>Any ideas would be helpful How to use command-line switches in Microsoft Access: Access 97: http://support.microsoft.com/kb/105128 Access 2000: http://support.microsoft.com/kb/209207/EN-US/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.