How can I prevent printing of records

[Laurad]

I have a small database in a school with only about 80 records in it. There are several data entry forms. The users of the database occasionally want to print one record which they are viewing, so they click on File/Print and end up printing 80 records (forms) and wasting a huge amount of paper.

Is there a way I can trap when they select File/Print with a message box, perhaps, asking if they really want to go ahead and if not, then preventing the print process?

Many thanks
Laura

 

[DCrake]

Create a report based on the form and have your own print button that filters the table to the record on the screen so it only prints 1 record.

 

[Laurad]

Thank you, that's a good solution, but people sometimes still want to use the method they are used to, File/Print. Is there no way to stop them doing this, or even just intercepting it?

 

[DCrake]

If you are using Access's File Print menu then no you need to use your own menus

 

[Laurad]

Ok.. many thanks.
Laura

 

[gemma-the-husky]

i think you could redesign the form so they have to select the record (pupil?) FIRST, and have the query return 1 item only

then if they print the form, it will only print one item.

 

[sonof27]

Not sure if this would be helpfull or not, you could set all your controls to display on screen only so if they do print via the file/print method they only get a blank page.

 

[boblarson]

Thank you, that's a good solution, but people sometimes still want to use the method they are used to, File/Print. Is there no way to stop them doing this, or even just intercepting it?

REMOVE access to the built-in menus/toolbars/ribbons, etc. and then provide your own with callbacks to your own function which asks them that question. As long as they have access to File > Print then you will have to live with what they are doing. If you remove that from them and give them your own then you can do whatever you want and move them down a particular path.