Populating a table field after records print

  • Thread starter Thread starter Cloudbuster
  • Start date Start date
C

Cloudbuster

I'd like to design a macro for the following scenario:

We mail letters using Access. The main table tracks addresses, and ones that
have already received a letter one time (column is called "One letter"). A
query shows which addresses have a blank cell for "One letter", to generate
letters. I'd like to have the database put some designation in the "One
letter" field, like the print date, when I print the letters. Can I design a
macro to do this?
 
Cloudbuster,

This would mean the One Letter field shoud be configured as a Date/Time
data type.

You can make a simple Update Query, to set the value of the One Letter
field to Date() and then you can use an OpenQuery action, in the same
macro that you use to print the letters, to run the update.
 
Back
Top