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.
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. 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.
MEMBERS VIDEO:
https://youtu.be/UX-YkjpmWDs
BECOME A MEMBER:
https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
LEARN MORE:
https://599cd.com/OnDblClick
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: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
Email Me:
[email protected]
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, double click, on double click, on dbl click, ondblclick, prevent double click on a button, msgbox, are you sure, vbyesnocancel
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
