Disable Printing in MS Access, Part 1: CTRL-P

In this Microsoft Access tutorial, I will show you how to restrict printing to only using a designated Print button, thereby disabling CTRL-P and other shortcuts. We tackle intercepting key presses with VBA and setting up user controls, perfect for ensuring proper invoice marking and report management. This is part 1 of 3.

Lorenzo from Downers Grove, Illinois (a Platinum Member) asks: I have a user that likes to hit CTRL-P to print reports instead of using my Print button which also runs code to mark invoices as having been printed. I've already disabled the Ribbon and the right-click menu using the techniques you've shown in your Security Seminar and Developer classes. However, is there any way to disable CTRL-P and force him to have to use my Print button? I still want to allow them to preview a report before printing it so they don't waste paper, but I want to force them to use my Print button.

Prerequisites

• Intro to VBA
• If Then

Recommended Courses

• Access Developer 44
• Access Security Seminar

Up Next

• Disable Printing, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, disable CTRL-P, print button code, VBA key press interception, Access print shortcut, disable Access right-click menu, printing permissions, restrict Access printing, VBA programming Access, disable printing Access, custom workflow Access, Access security features, password protection Access, custom ribbons Access.