Add record to table when report is printed

[DITEL]

Simple question here:

I want to add a record to a table "reports" when a report is printed. To have a sort of audit trail with the date and time of printing.

How do I get about ?

 

[mdmilner]

Use a form - add a button to the form that begins the printing function but add code that adds to the table following the print request. Not sure if there's a way to capture the data if the user utilizes the menu option to print.

One possibility is to remove that menu item so they can no longer choose it.

Mike

 

[CT Witter]

Check out MS KB article: 154894 - ACC: How to Maintain a Print Log for Reports

http://support.microsoft.com/default.aspx?scid=kb;en-us;154894&Product=acc

Hope this helps,
CT

 

[mdmilner]

Nice - I never paid attention to the onprint property (didn't notice it existed). While in my opinion some bulletins have been "very involved", this is a very short and very easy thing to do and it does precisely what I wasn't sure could be done - no matter how it's printed, it will get logged.

This one is getting saved for later.

Mike

 

[DITEL]

This does exactly what I needed. Thank you.