Print event? 1

[JDRoss]

I have the following situation. In a multi-user database environment, I want to have a date field updated on a table when an invoice is printed, effectively closing this record from further filters, etc.

I am wondering if somebody could advice me when to run the code to have the table updated, or when in fact I can know the report is printed as an indication? For instance, users may preview the report and still not print, but when they actullay print the invoice that is when I need to see the record as updated.

Much appreciated

Regards

John

 

[LittleSmudge]

And even if they do print it - the printer might jam or run out of toner etc. So they'll have to print another copy.

I usually rely on the accuracy of the user answering a screen prompt.

In the Report's On_Close event put up a message box asking if the Report printed okay [Yes/No]
It it did then add date to field and close
Ese Close anyway.


'ope-that-'elps.

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[JDRoss]

Dear LittleSmudge

Thanks for that logic, I think you have a very good point about whent the invoice prints.

By the same token, can I also code an event that asks the user how many copies they want to print. I haven't given this much thought yet.

But your help is appreciated!

Regards

John