access labels database

Question

hi

I have a database of names that i wish to print on labels which has been straight forward so far, but i have now added to the database and only wish to print off the ones recently added and not the entire database of names.

please could anyone advise on this?

how do i select certain names to be printed on labels?

Answer 1

As Daniel and RunningManHD say... we can't tell, based on the available evidence! Access (out of the box) does not track which record was added when; unless you have some information actually stored in the table (a date/time field recording when the record was added, a yes/no field set to YES when new records are added and then updated to NO when the label is printed, any of lots of other methods), you can't.

A Table of JUST names - with no other information - isn't much more useful than a drawer full of unsorted, unmarked business cards. There's no way (unless you created a way!) to tell what has been done with any particular name and when. Fortunately Access makes it pretty easy to do so!

Answer 2

Do you have a field that track the creation date?  Do you have a field that tracks which ones were previously printed?

You'll need to create a query and apply some type of criteria (WHERE clause) to restrict the records returned and base your Label report off of it.  In a worse case scenario, you could determine the Primary Key value of the last record printed and apply a criteria like:   > 85   (where 85 would be the last PK value printed).

This is all hypothetical and without knowing more about your table structure, report setup, ... it is very hard to advise you more.

Answer 3

You can add a Boolean field to your table of names to indicate intent to print such as PrintYN.  Or you can add a Date/Time field called DatePrinted which you would update following a print job. 

There are various options on how to manage this.  Whatever you choose, you simply create a filter condition for your report to either include or exclude records based on the additional field of your choice.