Build an Event Countdown Reminder Popup Form in Microsoft Access
ฝัง
- เผยแพร่เมื่อ 4 ต.ค. 2024
- Never miss a deadline again! In this Microsoft Access tutorial, I'll show you how to build an event countdown reminder form. You can add events to a table, and when your database starts up, a form will automatically pop up showing you how many days you have left until each of your events. We'll also make buttons to easily close the form, edit an event, add new events, or delete events - complete with an "are you sure?" prompt. While this database can't help you prepare for these events, at least it will help you to not miss them.
Meghan from Albany, Georgia (a Gold Member) asks: It seems I'm always missing events. Yeah, I put them on my calendar, and I set alarms, but I'm always dismissing them and forgetting about important stuff. Is there any way I could have Access pop a huge reminder in my face that says "you have that conference in 2 days!" It would be nice if I could see the next 3 or 4 things coming up so I know what's going on. Thanks.
Silver Members and up get access to an Extended Cut of this video. Members will learn how to create different custom color schemes using Conditional Formatting and apply one to each event.
MEMBERS VIDEO:
• Event Countdown Timer ...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Transpose Data: 599cd.com/Even...
PRE-REQUISITES:
Reminder Popup Date: 599cd.com/Remi...
Calculated Fields: 599cd.com/Calc...
Continuous Forms: 599cd.com/Cont...
Intro to VBA: 599cd.com/Intr...
LINKS:
Default Value: 599cd.com/Default
ISO Date Format: 599cd.com/ISO
Tab Stop, Order, Cycle: 599cd.com/TabO...
Modal & Popup: 599cd.com/Moda...
Close Form: 599cd.com/Clos...
Value From a Form: 599cd.com/Form...
Don't Delete Data: 599cd.com/Dont...
MsgBox: 599cd.com/MsgBox
Conditional Formatting: 599cd.com/Cond...
If Then: 599cd.com/IfThen
DCount: 599cd.com/DCount
RECOMMENDED COURSE:
Access Developer 40: 599cd.com/ACD40
NOTES
The maximum number of conditional formatting items you can have in Microsoft Access is 49. If you try to add more than that, you'll get the error "Run-time error '7966': The format condition number you specified is greater than the number of format conditions."
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, OnLoad, SetFocus, Modal, Double Click Event, On Dbl Click, DblClick, Allow Additions, Allow Edits, Allow Deletions, Me.AllowDeletions, Delete Keyboard Shortcut, Buttons to Close Form, Open Form, Add Record, Delete Record, Requery Parent Form, DoCmd.RunCommand acCmdDeleteRecord, MsgBox, vbYesNoCancel, vbCritical, DCount
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
all thumbs up to the best teacher Richard for another valuable lesson. Thank you Richard
This was great! Now we are notified to when an inspection tool calibration expires!
Sweet
Dim Great as MsgBox
Great = "Thanks so much Mr. Richard ROST, for this great video."
Glad you enjoyed it
thank you, this is simple yet very helpful
Welcome
Great tutorial! Thanks!!
Glad it was helpful!
Thanks for the video. My dashboard is too big and the popup shows up behind the dash. Not sure if I missed a step or not. I also do not delete data so dismissing event or acknowledging the event would be better. Thanks again.
Welcome
Hello , thank you for all precious tutorials , how can we add a calendar and link it with this form?
599cd.com/Calendar
Nice video!!!
Thanks!
Great!!!!!!
Thanks
It’s not a Richard video without a bad dad joke added in somewhere! 🤣🤣🤣
Got the dad bod to go with my dad jokes, too. :)
How do you have the overlay style scrollbars in Access? I'm using the latest Stable 365 version (2207).
I didn't do anything new. They just showed up to the party. I've got 2207 as well (Build 15427.20210).
@@599CD What version of Windows? I'm on the same office release!
Rather than delete, set to complete, cancel, reschedule.
Great ideas.