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
|
|||
|
|||
auto entering a print date on printing a report or part of a repor
I have designed a comfortable Mental Health Database for use in my practice.
I want to print weekly reports for a filtered set of clients. I request information as to how I can create a control which automatically enters the printing date for each note, and stores it for future reference. As it is now, I never know when I have printed and sent or failed to print and send a specific client report. -- Thank you, Ellen |
#2
|
|||
|
|||
The best way to do this would be to create batch entry for each print run,
and record the primary key of the record in the batch. This gives you a full history of what was printed when, and allows you to reprint any batch at any time if something went wrong. You will have a table listing the reports you send, with fields such as: MailingID AutoNumber primary key MailingDate Date/Time when the report was sent. Then you will record who received this report in another table: MailingID Number Foreign key to MailingID in the Mailing table. ClientID Number Foreign key to ClientID in the Mailing table. You can provide an interface so the user can select the clients for the mailing, or you may be able to automate the process by executing an Append query if you already have a list of who should receive the mailing. The RecordSource for the query till be a query that limits the report to just the one mailing. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "eHw" wrote in message ... I have designed a comfortable Mental Health Database for use in my practice. I want to print weekly reports for a filtered set of clients. I request information as to how I can create a control which automatically enters the printing date for each note, and stores it for future reference. As it is now, I never know when I have printed and sent or failed to print and send a specific client report. -- Thank you, Ellen |
#3
|
|||
|
|||
auto entering a print date on printing a report or part of a r
Allen, I have a question related to the answer you just gave EHW
the report in my database is very virtual, and due to compliance issues, manangement would like to track when the document was first printed and by who and when it was printed again the second time and third time. This needs to be automated... "Allen Browne" wrote: The best way to do this would be to create batch entry for each print run, and record the primary key of the record in the batch. This gives you a full history of what was printed when, and allows you to reprint any batch at any time if something went wrong. You will have a table listing the reports you send, with fields such as: MailingID AutoNumber primary key MailingDate Date/Time when the report was sent. Then you will record who received this report in another table: MailingID Number Foreign key to MailingID in the Mailing table. ClientID Number Foreign key to ClientID in the Mailing table. You can provide an interface so the user can select the clients for the mailing, or you may be able to automate the process by executing an Append query if you already have a list of who should receive the mailing. The RecordSource for the query till be a query that limits the report to just the one mailing. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "eHw" wrote in message ... I have designed a comfortable Mental Health Database for use in my practice. I want to print weekly reports for a filtered set of clients. I request information as to how I can create a control which automatically enters the printing date for each note, and stores it for future reference. As it is now, I never know when I have printed and sent or failed to print and send a specific client report. -- Thank you, Ellen |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Timely: How do I add a date range query for a report? | David | Setting Up & Running Reports | 7 | September 15th, 2004 07:22 PM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Printing a Run Time Date on a Report | StevenDH | Setting Up & Running Reports | 2 | August 19th, 2004 10:35 PM |