Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
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.
 

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

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