Service Reminder Letter

[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?

 

[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)

 

[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?

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)

 

[Al Campagna]

Simon,
What do you mean by...

"access didnt like this!"

What was the error/message?
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

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?

 

[Simon Glencross]

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

 

[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?

 

[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

 

[Simon Glencross]

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

 

[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.