Avoid Accidental Clicks in Your Microsoft Access Forms

In this Microsoft Access tutorial you will learn how to prevent accidental clicks and double-clicks on your forms to ensure actions like printing a report run only once. Learn to use VBA, simulate long processes, and utilize TempVars and DoEvents to create a more user-friendly application.

Felix from Peoria, Arizona (a Platinum Member) asks: How can I prevent a user from accidentally double-clicking a button that should only be clicked once, such as a Print Report button? I want to ensure that the action stops after the first click. I've got a lot of users (myself included) who accidentally double-click on buttons and send down 2 copies of a 13-page report. Happens a lot.

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA

Links

• Sleep
• TempVars
• Static Variables
• DoEvents

Recommended Courses

• Access Developer Courses

Code Vault

• Accidental Clicks VBA Code

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, prevent accidental clicks Microsoft Access, prevent double-clicks Microsoft Access, single-click action Microsoft Access, VBA prevent double-clicks, prevent multiple report prints Access, Access form button click prevention, disable button after click Access, tempVars prevent double-clicks, disable button VBA Access, button enabled false VBA Access, prevent duplicate actions Access