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 Calendar Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   12 years ago

Manage your appointments, and create printable monthly reports from your Access databases. Access Calendar Seminar.

EVERYONE make sure to see these addendums. These addendums address some problems with the original seminar, including the missing date picker control:

Alex's Additional Addendums:



I am having problems with the date calendar Upload Images   Link 
Jimmm Manuel 
4 years ago
I am having problems with the date calendar...There is no date calendar in Access 2016......It won't run the little script to set the first Monday

Reply from Alex Hedley:

There are loads of comments on this post about the issue, and even an Addendum. Read More...
Add a Reply
I am making a calendar Calendar seminar lesson 6 Upload Images   Link 
Masih O 
4 years ago
I am making a calendar (Calendar seminar lesson 6). I cannot find Calendar control in my ActiveX controls. I did some searching on the net and found out that Access 2010 don't have a calendar control. What do I do now??? Read More...
Add a Reply
Calendar seminar Upload Images   Link 
Daniel G 
4 years ago
I would like to download a copy of the database but i cant find it at
can you help me thanks

Reply from Alex Hedley:

There are links on the Course Outline page.
Add a Reply
Printing Upload Images   Link 
Richard B 
4 years ago
I AM TAKING YOUR access calendar Seminar tutorial. Near the end of the Lesson I deeded to print out the calendar. I get the following: ENTER    PARAMETER VALUE

Forms!DatePickerF!StartDate
Add a Reply
Calendar Control Upload Images   Link 
Richard Bray 
4 years ago
I am using access 2016. when I Click on activex control  There is no Calendar control?

Reply from Alex Hedley:

Calendar Control Addendum

Just use a textbox and set it to date, it will add a picker
Add a Reply
Richard The code you are talking about around Upload Images   Link 
Andrew Washington 
5 years ago

The code you are talking about around the 9 minute mark is giving me an error.  My code is identical to yours but when I run it I get a type mismatch error at

If Month (Forms!MonthlyCalendarF(S1)) <> Month(Calendar) Then
Add a Reply
I get the following error Enter Parameter Query Upload Images   Link 
Gioia H 
5 years ago
Can you please send me a working copy with that form included? I purchased the Access Calendar Seminar but the provided download is not working in Access 2016, I've tried to use it on multiple computers to make sure the issue isn't on my end. Read More...
Add a Reply
I get the following error Enter Parameter Query Upload Images   Link 
Gioia H 
5 years ago
No there is no form called "DatePickerF"

Reply from Alex Hedley:

You need that form if you are going to reference a field from it.
Or change that to the name of the Form that has your control on it. Read More...
Add a Reply
I get the following error Enter Parameter Query Upload Images   Link 
Gioia Heiser 
5 years ago
I get the following error: Enter Parameter Query
on both the MonthlyCalendarF and MonthlyCalendarR even though I created an entirely new database and transferred your objects into my Access 2016. Can you please post the db code that works for Access 2016 Read More...
Add a Reply
Calendar Seminar Upload Images   Link 
Selby H 
5 years ago
Dear Richard and Alex,
I have figured out how to highlight the current day of the month on the Calendar following Alex.
How would I highlight the date that has been selected in the DatePicker Form? Read More...
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:

9/25/2021Access Developer 32 Lessons
9/25/2021Access Developer 33
9/25/2021Access Developer 33 Lessons
9/25/2021Access Developer 33
9/24/2021Export HTML
9/22/2021Access DevNet Testimonials
9/20/2021Letter Writer
9/19/2021Multi Field Combo
9/19/2021Project Management
9/17/2021Overlapping Windows

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 calendars appointments  PermaLink