Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Access Advanced DateTime Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   6 years ago

In the Access Advanced DateTime Seminar, you will learn how to count the number of work days between two dates, determine if a date is a week day or a weekend day, calculate holidays, time stamp edited records, use event timers in your database to create popup notifications for reminders, generate recurring appointments, and calculate the number of a particular weekday (Friday) in any period (January). Topics include:

- Calculate Work Days Between Two Dates
- Duplicate the Excel NETWORKDAYS Function in VBA
- Create a Holiday Exclusion Table for Work Day Results
- Time Stamp Records when Edited
- Create a Reminder Popup Notification Form
- Learn Form Timer Event Programming
- Prevent Popup Form from Stealing Focus
- Count the Number of a Specific Weekday in a Period
- Calculate Dates for All Major US Holidays
- Generate Recurring Appointments
- Display Ordinal Dates: 1st, 2nd, 3rd, etc.

This seminar is 5 hours and 22 minutes long. Click here for more information on the Access Advanced DateTime Seminar, including a complete course outline, sample video, and lots more.

Problem in code Upload Images   Link 
Despina Karayanni 
2 months ago
Hello Richard.
Thank you for your very instructive lessons. I have a problem which I would very much appreciate if you could help with. In the date time seminar database, when I press the button "remind me in 3 minutes" I get the following error: Read More...
Adam Schwanz
2 months ago
Check your quatations.
Richard Rost
2 months ago
I can see a few errors. If you copied and pasted this directly, you're missing a # after '#06/05/21 7:36:19 pm'

What is mm?

Add a Reply
Upload Images   Link 
4 years ago
Many thanx. I liked this lesson
Add a Reply
DateTimeSeminar database Run time error Upload Images   Link 
John H 
4 years ago
Reference library showed missing: ms outlook 15.0 object library.  Removed check and now your db ReminderF opens without a hitch.
Add a Reply
DateTimeSeminar database Run time error Upload Images   Link 
John H 
4 years ago
Just downloaded your database again on different computer.  Opening up ReminderF throws same error with debug line
W = W & "ReminderDateTime < #" & EndDate + 1 & "#"

Nothing has been changed.  Please advise Thanks
Add a Reply
New Record Upload Images   Link 
Jim Ogier 
4 years ago
It would be nice to be able to have some records added to the table as a new record, i.e. click a button and the appointment is moved to the bottom of the list as a new record.

Jim O
Add a Reply
How can I default a Date time field to a PM time v Upload Images   Link 
Jim Ogier 
4 years ago
How can I default a Date/time field to a PM time value?
99 percent of the date time entries are a PM time and it would save much time to default to PM.

Jim O

Reply from Alex Hedley:
Add a Reply
SubForm to ParentForm Upload Images   Link 
Richard Wilson 
5 years ago
I have a number of sub-forms on a form.  Is there any way for a change on a sub-form to trigger a "LastUpdated" field on the master form?  Frankly, I consider them all part of the form, but because of many-to-many relationships, I find it necessary to use a plethora of sub-forms. Read More...
Add a Reply
DateTimeSeminar database Run-time error Upload Images   Link 
John Hubbard 
5 years ago
Just downloaded your DateTimeSeminar database, ReminderF, on opening am receiving Run-time error "2247" invalid use of .(dot)or ! operator or invalid use of parentheses. Getting same error on ReminderPopupF. Read More...
Add a Reply
Minimize Form Upload Images   Link 
Richard Lanoue 
6 years ago
I want to open my main form, and once it's open, it opens the appointment form in minimize mode... how do I do that?

Reply from Alex Hedley:

Add a Reply
Access Advanced DateTime Seminar Upload Images   Link 
mohamed mater 
6 years ago
i want to expert in access

Reply from Alex Hedley:

Well this and the other Seminars will help you get there.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

7/24/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
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
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access datetime seminar work days recurring reminders appointments holidays  Page Tag: whatsnew  PermaLink