By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Print mailing labels and update date field

P: n/a
I have a project which requires the batch import of customer contact
information, print mailing labels for those customers who have their
date of first letter field in the database set to null, and update the
date of first letter field with the date the mailing labels are
printed.

I already have a query which checks the date of first letter field,
and returns those customers whose date of first letter field is null.
How do I setup to run the mailing labels based on this criteria and
update the date of first letter field in the process?

Thanks

Jun 27 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Dr Al wrote:
I have a project which requires the batch import of customer contact
information, print mailing labels for those customers who have their
date of first letter field in the database set to null, and update the
date of first letter field with the date the mailing labels are
printed.
A single query can't do that. You could make a Macro to do that (not
resorting to VBA) where it runs the report based on the first query,
then runs an update query based on the first that sets the date.

2 lines of code...easy...

....or you can -=try=- to do it via VBA in a report...just add code to
currentdb.execute "UpdateQueryName" to the close event of the report.
Jun 27 '08 #2

P: n/a
On Apr 18, 8:44*pm, Harry Skelton <skelton.ha...@gmail.comwrote:
Dr Al wrote:
I have a project which requires the batch import of customer contact
information, print mailing labels for those customers who have their
date of first letter field in the database set to null, and update the
date of first letter field with the date the mailing labels are
printed.

A single query can't do that. *You could make a Macro to do that (not
resorting to VBA) where it runs the report based on the first query,
then runs an update query based on the first that sets the date.

2 lines of code...easy...

...or you can -=try=- to do it via VBA in a report...just add code to
currentdb.execute "UpdateQueryName" to the close event of the report.

Thanks, but could you be a little more specific! You said...easy...,
but I am not that familar with code!
Thanks
Jun 27 '08 #3

P: n/a
Dr Al,

For what it's worth, when I do something like this I open a form based
on the select query and print my labels from there then in the onclose
event of the form I just run an update query to place a date in the
records I just processed.

Rick
Jun 27 '08 #4

P: n/a
On Apr 22, 10:49*am, "Rick A.B." <rick.bre...@minneapolis.eduwrote:
Dr Al,

For what it's worth, when I do something like this I open a form based
on the select query and print my labels from there then in the onclose
event of the form I just run an update query to place a date in the
records I just processed.

Rick
Thanks everyone,

I got it working this morning.... I would not have gotten it done
without your help.

Thanks
Jun 27 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.