Timer Event for Reminders. Display a Popup Form in Microsoft Access at Regular Timed Intervals.
HTML-код
- Опубликовано: 14 окт 2024
- 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 Remind...
BECOME A MEMBER:
/ @599cd
LEARN MORE:
599cd.com/Remi...
LINKS:
Intro to VBA: 599cd.com/Intr...
DLookup Function: 599cd.com/DLookup
NZ Function: 599cd.com/NZ
Timer Get Web Data: 599cd.com/ACX24
Enhanced Timer Form: 599cd.com/ACD6
Quiz Timer: 599cd.com/ACD11
LEARN MORE:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Customer Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/Cons...
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
Email Me: amicron@gmail.com
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.
I 'm very impressed with the professional delivery of these lessons. I am telling like minded people to come and watch your videos.
Thank you I appreciate that
I have a lot of questions and I also need a lot of tutorials that are available in your videos.
I like to get a perfect result in one training session and not be postponed to another training.
Thanks for your time Mr. Rost, Good Luck.
God bless you and your parents...
I think the idea is for you to build your own package based on your requirement, the channel can't possibly do bespoke training for every eventuality for every individual otherwise the packages would be enormous and far too numerous. Instead, each principle seems to be packaged in its own field and you pick and choose the ones you need.
I think this channel is outstanding, very well structured and 100% my go to channel for MS Access learning.
Sorry, but I don't offer one-on-one training or technical support. I spend my time making videos where I can help thousands of people instead of just one person at a time. If you have a question that you think might have mass appeal and help other people, by all means, please feel free to post it. If I like it, then maybe I'll make a video out of it.
Pete, thank you very much for the kind words. I'm glad to be your go-to for Access stuff. You're right; I can't possibly cover every possibility that comes up, but I do my best to answer as many questions as I can, especially ones I think are going to help a lot of people. If you ever have an Access-related problem and you can't find an answer with a Google search, and one of my videos doesn't come up, then by all means, let me know. I want to make sure I fill those knowledge gaps.
I want to notify an employee of leave requests status either reject/approved. The manager will approve/reject an employee application under his department and will be notified when is logged in or during. A message box would suffice. How to achieve this ?
Good tutorial. How to Display Popup Form if there are new record is added and list those records?
Add a field to the table indicating whether or not a record is new. Use DLookup to see if there are any new records. Put those records in a form. 599cd.com/DLookup
Thank you.
Dear Rechard
How i can snooze the form until next day ? Please help.
Ty for this tutorial ❤️
Welcome
THANKS !Very cool
Glad you liked it!
Dear Richard. Works perfect. However, when another form is maximised, the popup form runs suddenly maximised as well. How do you prevent this to do so in vba or property?
The popup-property can not be used, because i force the application to close with docmd.quit. This is not allowed for the popup-property. So do you have a solution?
You could issue a restore window down command.
@@599CD Yes, works. Only it loses the focus on the application. It switches to another application on my desktop. I must manualy switch back to my access application. How to keep it in access?
Is there any way I can get a message when my stock reach zero ( out of stock) for any item while I am entering a new sales order .
599cd.com/ask
Could this be used to run a query and display on main page on startup? I'm thinking a snapshot view of critical Totals and use the timer to auto update the report displayed on startup page.
Sure
How do you do a pop up with a key word if scanning in inventory? Example: some of my inventory has a certificate that is important to keep up with in which I want the warehouse folks to upload the very to prevent losing. How can I get the pop up to work on those items that require a cert upload before proceeding with scanning the remainder of the inventory? Thanks
Put the code for your popup in whatever code is handling your scan.
Trying to get a Notice form to come up if I have SalesOrders in a query that don't have an assigned ProjectPlan. (ProjectPlan) would be an empty or null field in the query.
Dim ID As Long
ID = Nz(DLookup("SalesOrder", "qrySOwithPP", [ProjectPlan] Is Null), 0)
If ID 0 Then
DoCmd.OpenForm "frmNotice"
End If
but I am getting the error "2465", database can't find the '|1' referred in your expression?
I figured it out! Changed criteria to "ProjectPlan Is Null"
There you go
How about reoccurring reminders such as monthly / yearly ?
Definitely possible: 599cd.com/DateTime
It does not seem to work if a Msgbox is waiting for response...?
That is correct. As I mention in the video, MsgBox halts all activity in your database. That's why you want to use the popup form.
Thank you so much for your nice, cool & descriptive and also swampy videos...;). Why? Because you in every single video link to at least 3 videos instead of learning 0 to 100 in a same video.
So, most of your videos are Frustrating & troublesome....
Forgive me for saying that, but That's a truth...
i am makng a a point of sale system in ms access how can I make sale hold system if customer is busy then we can sale another product to new customer
You just make a field to say OnHold and then close that sale and move to another one. Piece of cake.