Discussion Locked

MS Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have printed out some labels and now new records are been entered. How do I print labels for the new records only? I don't want to print all the labels again (just the new ones).
I want to continue this for all the new records entered time to time.
Please suggest.
Thanks

3 replies

by shane.freman

My advice would be to add a Yes/No field in your table called Printed. Create a select query that looks for everyone that hasn't been printed then an update query to mark everyone's Printed value to true if it was false. Change the data source of your mailing labels to the select query and then after you've printed the new labels run the update query to mark them all as True.

by nccorthu

If its a 1 shot deal or infrequently done rather than programing when you come to print them and the printer dialogue shows up choose the first and last record that you want to print , it will be about the middle bottom of that dialog window. That way the DB will pass over the others; make sure the ones you want are reasonably sequential, so you don't have to pick too often or for that matter more than once.

by mslizny

If you are looking a bit longer term you might consider that you could use these labels for many things, and some idea of grouping them by time periods would help. If so, you could add a field to the database that automatically time-stamps each record when it is created. It is then possible to set up a parameter query which allows you to specify the time period you want and use it to create the labels.

This discussion is closed to new replies.