Using the On Double Click Event. Open Record.

In this Microsoft Access tutorial, I'm going to teach you how to use the On Double Click event to increment a date field by one day. This way you can just double-click on the date field itself to increase its day by one. I'll also show you how you can use this technique to open a customer's record by double-clicking on his ID in the customer list form.

Anderson from Buffalo, New York (a Platinum Member) asks: I watched your On Click Event video. It was awesome. Exactly what I asked for. Is there any way you can do the same thing with a Double Click? This way I don't need the labels which take up precious space.

Members

I'll show you how to cancel a double-click event to prevent the user from clicking twice on a button. You've had it happen before: the user thinks they have to double-click on a button and now they've made the On Click event run twice (deleted two records instead of one, for example). I'll show you how to deal with that. And I'll also show you how to pop up an "Are you sure?" warning message.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

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!

What Course?

On Double Click is Covered in...

• Access Developer 4: https://599cd.com/ACD4

Links

On Click: https://599cd.com/OnClick
Continuous Forms: https://599cd.com/Continuous
Customer List Form: https://599cd.com/CustomerListForm
Concatenation: https://599cd.com/Concatenation
https://docs.microsoft.com/en-us/office/vba/api/access.form.dblclick

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.