Published On Jan 19, 2021
In this video, I'll show you how to create a popup form that will show you a reminder at regular intervals whenever you have customers in your table that need a followup. This same technique of using a form timer event can be used for all kinds of things, like sending emails, pulling down data from a web site, processing orders, you name it.
Melody from Berlin, Germany (a Gold Member) asks: I would like my database to notify me once an hour if there are any new sales leads in the system that I need to respond to. Is there any way to have Access pop up a message for me?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an Extended Cut of this video. I'll show you how to make a button to open up just customers that need a followup, add a countdown timer to your form so you can see it counting down 5... 4... 3... 2... 1... with a PAUSE option. And I'll show you how to make it so that the notification doesn't interrupt your work flow. You can still keep working in the form you were on without the popup disturbing your typing.
MEMBERS ONLY VIDEO:
• Timer Event for Reminders. Display a ...
BECOME A MEMBER:
/ @599cd
LEARN MORE:
https://599cd.com/ReminderPopup
LINKS:
Intro to VBA: https://599cd.com/IntroVBA
DLookup Function: https://599cd.com/DLookup
NZ Function: https://599cd.com/NZ
Timer Get Web Data: https://599cd.com/ACX24
Enhanced Timer Form: https://599cd.com/ACD6
Quiz Timer: https://599cd.com/ACD11
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 Customer 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: / learningaccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, timer popup, reminder popup, timer to send email, popup message, notifications with a form timer, send automated emails, timer to run code every 30 minutes
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.