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

Print records that have not been printed yet

P: 54
I have a table called "unload" which people are constantly adding records too from a form throughout the day. I created a button to print the records from a query called "unload query". I want it to only print records that have not yet printed, but as of right now it prints all of the records. Any help is much appreciated. Thanks!
Jul 13 '12 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,397
There are several ways to handle this... I use a batch table approach so that I can reprint a batch of records incase the printer eats them and I also have a record of when the records were printed. The solution just depends on what you're after in the long run.
-z
Jul 14 '12 #2

100+
P: 759
Or you can define a new field in the table: say... "IsPrinted" (Yes/No type) with "No" as default value.
Then, any time you print a record (or a set of records), change "No" to "Yes" for that record(s).

Of course you can design even a better query to show only records with "No" in the IsPrinted field.

Of course you can imagine other ways.
As example the IsPrinted field can be as type Date/Time with Null as default value.
The query will show only records with Null in IsPrinted field.
Other queries can show the records that are already printed between StartDate and EndDate.

And so on.

Cheers !
Jul 14 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.