Service Reminder Letter

S

Simon Glencross

I have setup a letter which is sent out to customers who have been set with
a service reminder date (held in tblservice) which works well, But I have
thought of a problem whereby if they are printed off daily religiously then
there could be problems. So I thought that I should create an extra field
within tblservice called Sent Y/N. I am unsure how I can get his field to
update automatically once the letters have been printed successfully or if
this is best practice. Does anyone have any suggestions please?
 
A

Al Campagna

Simon,
Whatever criteria you use to select the letters to print... use that same criteria to
run an update query against your table to set Sent to True.
This could be done after printing the report. Perhaps a Msgbox "Mark as Sent?" (y/n).
It would be a good to also date the Sent = True update (ex. SentDate) so that you can
easily find a "batch" that have been sent, and uncheck if necessary.
(in case of Printer jam, inadvertent printout, ...etc)
 
S

Simon Glencross

Ok I have created the UpdateQuery and atached this to a macro and placed
under the close event of the report but access didnt like this! Any other
suggestions please?



Al Campagna said:
Simon,
Whatever criteria you use to select the letters to print... use that
same criteria to run an update query against your table to set Sent to
True.
This could be done after printing the report. Perhaps a Msgbox "Mark as
Sent?" (y/n).
It would be a good to also date the Sent = True update (ex. SentDate) so
that you can easily find a "batch" that have been sent, and uncheck if
necessary.
(in case of Printer jam, inadvertent printout, ...etc)
Click to expand...
 
S

Simon Glencross

A Macro Specified as the OnOpen, Onclose, OnFormat, Onretreat or OnPrint
property setting contains an invalid action for the property.
 
S

Simon Glencross

Ok I have sorted this! Thank you for your help!

One other question if I may is there a way to surpress the warning messages
about updating rows etc? Can these be controlled somehow?
 
D

Darrell Childress

If you used a macro to do this, then in the Macro you can set the first
Action as SetWarnings to OFF, but then make the last action to
SetWarnings back to ON.
Darrell
 
S

Simon Glencross

Is there a way that I can configure a dialogue box to ask the question
"Continue Yes or No?"
 
A

Al Campagna

Simon,
Check out the MsgBox function in Help. It describes how to set up a dialog box that
you can present to the user before the Update query runs.
 
Top