If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Print reports automatically
How do I print a report on the 1st monday and third wednesday of each month?
I need to print out updates on the begining and mid of each month. Thanx in advance... |
#2
|
|||
|
|||
There is no auto-print functionality.
You could build code to do this and tie it to a form that opens with the database. Then, if you opened the fiel on the specified dates, it would run. This is part of your program, not an aspect of Microsoft Access. You will have to make this happen in your program via macros or code. If it were me, I'd place a reminder to run the reports in my Outlook Calendar and run them when needed. Rick B "Maggie Minnamon" wrote in message ... How do I print a report on the 1st monday and third wednesday of each month? I need to print out updates on the begining and mid of each month. Thanx in advance... |
#3
|
|||
|
|||
Rick is right from what I've found. The only ways I have
made this happen were to either: 1 - Build a table in Access with the dates you want to print, then have an autoexec macro check current date against the table and if a match is found, print the reports. 2 - Build a macro that checks the current date and if it is a Wed and the 1st or 3rd, print the report. 3 - Build a command line arguement that runs access and launches a specific macro (one that prints your reports as needed) into a .bat file and have that .bat file launch via the scheduler in Windows on the dates you require. This one is tricky as you need to get the syntax right for the command line, but you can find plenty of sytax help via the net and Microsoft (think command line switches to run specific macros). Keep in mind this will only work on unescured databases, so if your DB is secure, build a new front end that doesn't require a password and put it on a secure PC and have that machine do all the running for you. -----Original Message----- How do I print a report on the 1st monday and third wednesday of each month? I need to print out updates on the begining and mid of each month. Thanx in advance... . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't print from MS Office Programs | AL | General Discussions | 0 | August 4th, 2004 11:33 PM |
Need help w/ reports | Tom | Setting Up & Running Reports | 0 | June 25th, 2004 05:59 PM |
Can't Print Frames? | Bart Van der Donck | Outlook Express | 0 | May 31st, 2004 11:08 AM |
How do you print reports from selected check boxes in a form that is related to one record? | Ray | Database Design | 1 | May 14th, 2004 01:09 PM |