Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Reminder Popup < Separate Email | Order By Filter On Load >
Back to Reminder Popup    Comments List
Recurring Task Reminder Upload Images   Link   Email  
Colby Wolford 
Hello, Sir!

I hope you are well with all the extreme weather happening in the Southeast.

My question is: how do I set up a recurring reminder for a task?

Context: I need to remind staff to count petty cash first thing on the first business day of the month for reconciliation purposes. I would like it to appear on my Main Menu form.

Thank you for all of your hard work. I discovered you (accidentally) when looking for info while building my database, and every video you've put together has been very professional and extremely engaging. (From a Learning & Development standpoint--my background--you're videos are well planned and scripted. I especially love how you give specific learning goals and outcomes at the beginning.) Keep up the wonderful work!
Colby Wolford
Thanks for your time, Scott. Unfortunately, I've watched both of those videos already and they cover specific dates and times; they don't cover how to code for general terms like the first business day of every month. I've done an internet search and I only get a few hits for VBA scripting--none of which are for what I need. :(
Kevin Robertson
See this POST.
Scott Axton
Sorry I didn't read correctly.  Take a look at the
Add Records Automatically video.

In your case you would only add one record.  Although with a For Next Loop you could add a year at a time if you wanted.
In your case you could set a  Variable to increment the date to next month.

Just like Richard always says, "He provides the Lego pieces. It is up to you how you want to put them together to build you toy."

I don't see that you have the courses under your belt to advise you very far so I cant determine what your knowledge level is.  
Really consider the TechHelp Membership as well as going through the courses to build a good foundation to work with Access.  You can get more info by clicking the Join link at the top or just click this link: Memberships
Scott Axton
Here is another one for you.  Next Appointment
The extended cut shows you how you can use the DateAdd function to add specific dates.

You could also use the DateSerial function to add one month. The issue with that is if you set the date to the first day of the month, what happens if it is a Tuesday like this month? 2022/11/01.
Do you consider the first business day of the month the 31st of October?  
Or what happens if the 1st falls on a Saturday or Sunday?

If you really want to learn about working with dates I strongly recommend the Access DateTime Seminar

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Reminder Popup.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/4/2024 6:54:29 AM. PLT: 0s