var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Action after printing??? Not after previewing!
I have a report which everybody can preview and print. I want to insert the date and time (now() ) into the database when the report is printed.
I have set the code on the Reports onPrint action. The problem is that if someone previews the report, it runs also the code I want it only when the report is actually printed.
And because the report has variable pages the use of 'printcount' doesn't work.
I don't know if this is an option for you, but if you are calling the report from a form, you could just add two buttons. One to preview the report, and one to print the report. Under the preview button, all you would need is:
And under the print button:
DoCmd.OpenReport "Your_Report_Title", acViewPreview
Hope that helps.
'Code To Add Log Here
I have also considerd that. But it is more user-friendly if someone can preview it and then press the print button instead of closing the report and then pressing a button.
But thanks for the suggestion.