Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   Logon  
Access Advanced DateTime Seminar
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   5 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.

3 years ago
Many thanx. I liked this lesson
Add a Reply
DateTimeSeminar database Run time error Link 
John H     
3 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 Link 
John H     
3 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 Link 
Jim Ogier     
3 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 Link 
Jim Ogier     
3 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 Link 
Richard Wilson     
4 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 Link 
John Hubbard     
4 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 Link 
Richard Lanoue     
5 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 Link 
mohamed mater 
5 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
Access Advanced DateTime Seminar Link 
5 years ago
you guys are doing a graet job.thumbs up
Add a Reply

Show Older Comments...
View in Table Format

Post a New Comment or Question
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:

11/21/2020Shortcut Keys Ctrl-Period Ctrl-Comma
11/19/2020Hide Page Footer on First Page
11/19/2020Single-Field Search Button
11/19/2020Get Username WScript
11/18/2020Access Developer 19
11/18/2020Access Developer 19 Lessons
11/18/2020Access Developer 19
11/18/2020DateAdd to Add Months
11/16/2020Properly Calculate Age
11/13/2020myNetWorkDays Function

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Waiting List
Production Schedule
Code Vault
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: access datetime seminar work days recurring reminders appointments holidays  Page Tag: whatsnew  PermaLink