Restricting Ctrl P

[jpatota]

I want to restrict users from pressing control P or using File Print to print forms and reports in one particular database.

I'm afraid that users will use these two options that will print every record and the entire form, rather than the current one they probably intended. I have a nice big control button that prints the current form but I've even made the ctrl P mistake so it needs to be eliminated.

How do I do it?

Thanks!

John

 

[dkinley]

In the form properties for the KeyDown event, you can try ...

If (Shift and acCtrlMask) > 0 And KeyCode = 80 Then KeyCode = 0

Then set the Key Preview property of the form to 'Yes'.

-dK

 

[ghudson]

I want to restrict users from using File Print to print forms and reports in one particular database.

You need to hide the menu bar if you are using Access 2003 or earlier or hide the ribbon if you are using Access 2007 or newer. Search the forum for the answers to both have been posted in previous threads.

Users of your database can only do what you allow. ;-)

 

[gemma-the-husky]

you could use an autokeys macro to reprogram ctrl-p to do something else - eg just provide a msgbox saying print faciliuties are not available

its a blunt instrument, as it will stop you printing with it completely but it may help

 

[jpatota]

Thanks for the help everybody!