C
Ceedy
I may be missing the point. It was a long message but if
I understand correctly, you figured out everything but
adding the current date in the "letter sent field". Use
the same query, copy it with a different name, change it
to an Update Query and update the "letter sent field" to
Date().
records that tests have been submitted,passed and letters
and certificates have been sent. I am trying make it so
this person can click a few buttons and have the letters
and mailing lables print, and update his list of letters
needing to be sent by
in the letter sent field so that he doesnt print the same
letters the next time he runs his word macro
record for the letter sent field---is this possible????
imagine? Its like using a mustang for a lawn chair....
I understand correctly, you figured out everything but
adding the current date in the "letter sent field". Use
the same query, copy it with a different name, change it
to an Update Query and update the "letter sent field" to
Date().
trying to set up a simple database for a friend who-----Original Message-----
I am not too crafty in access but more then most--I am
records that tests have been submitted,passed and letters
and certificates have been sent. I am trying make it so
this person can click a few buttons and have the letters
and mailing lables print, and update his list of letters
needing to be sent by
received,name,business,and date the letter was sent*creating a simle database to record tests
records that have no date in the "letter sent field"*creating a query in this access base that draws up any
this query for his confirmation letter and address lables*creating a macro in word that will run a mail merge on
same query and input the current date in all the records*then creating a button he can click that will open the
in the letter sent field so that he doesnt print the same
letters the next time he runs his word macro
open this same query and input the current date in eachI have been successful in creating a database,form,query and the word macro
I cant seem to figure out how to write a macro that will
record for the letter sent field---is this possible????
name,address,on both the letter and the lable---can youpreviously he was looking up and typing each business
imagine? Its like using a mustang for a lawn chair....