View Full Version : don't print selected records


agorman
07-23-2007, 04:16 AM
Hi,

I have recently learned the use of 'ysnprint' (I am a novice), but wondered if there was an a way of selecting individual adresses in my db to exclude from the full address label printing.

Thanks for any help

Adrian

The_Doc_Man
07-23-2007, 08:05 PM
If you print from a table, no.

If you define a yes/no field in your DB and print from a query that ignores addresses where your yes/no field is YES but prints when it is NO, and then default all addresses to be have this "IgnoreMe" field set to NO, you have the basis of what you requested.

Write an update query that sets this "IgnoreMe" field to NO for all records. Then either using a query or via a form where you can check the ones to skip, set the undesirables to YES in that field.

Then when you print, print from a query that skips the undesirables.

agorman
07-24-2007, 01:02 AM
Thankyou Doc_Man,

I have set it up as you suggested and it is perfect. I appriciate your help very much.

Adrian

The_Doc_Man
07-24-2007, 05:20 AM
Glad to help.

For future reference, whenever you want to do something selectively (as in this case), do it from a query because Access forms and reports are usually too dumb to know the difference between tables and queries.