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:



Completed Calendar Events Upload Images   Link 
Austin Ritner 
2 months ago

I completed your Calendar Seminar, and I was showing it off to a friend who asked if there was a way that you could see at a glance that an appointment/task was completed without having to click on it and open the information. What do you think? Read More...
Richard Rost
2 months ago
Yeah, I'm sure you could easily add that as another column. I'm actually going to be working on an updated version of that seminar that's going to include different color-coordinated events and will look much cooler and focus on more of the scheduling aspects. The goal of that older seminar was to focus on making the monthly-formatted form and report. It's on the list for this summer. Stay tuned.
Add a Reply
Calendar Control Upload Images   Link 
Scott Spencer 
5 months ago
In the Calendar Seminar your reference the calendar control that no longer exist in access 2013. I was wondering if there was a work around in place for Lesson 7 that would handle the grey out days from different months. Thanks
Alex Hedley
5 months ago
There are a number of addendums above, they show how to update for the missing control and move between dates.
Richard Rost
5 months ago
Yep, and I'm planning on some additional revisions soon.
Add a Reply
Add Other Addendums Upload Images   Link 
Alex Hedley 
6 months ago
Highlight Current Day

Add a Multi-Day Event to Calendar Seminar Database using a Recordset
Richard Rost
6 months ago
Yeah, I might just completely redo the Calendar Seminar. It's about time. (Hahaha... time... see what I did there?)
Alex Hedley
6 months ago
:groan: This is why we need reactions on comments :p
Add a Reply
Update Calendar Upload Images   Link 
Serge Lefrancq 
6 months ago
How ca we update the calendar form when we double click a record in one of the ListBox and make a change to that selected record.
Richard Rost
6 months ago
Have you finished the Seminar yet? I'm sure that's covered.
Serge Lefrancq
6 months ago
Hi Richard,
I have finished the seminar, including the 2 addendum. I can make a change by double cliking an item in a list box in the Calendar Form but when I close the editing form, it does not update the Calendar form unless I close it and reopen it. As far as the completed seminar, I have built the calendar in my application and everything works very well.
Add a Reply
Backcolor Listbox Upload Images   Link 
Serge Lefrancq 
7 months ago
How can I change the BackColor of the list box in Access 2016 since there is no calendar control available and the date is only entered in an unbound text box. Up to this all the code to create the calenderForm works as expected.
Richard Rost
7 months ago
Changing the Backcolor property of a Listbox should be exactly as I show it in class for EVERY version of Access.

ListboxName.Backcolor = VALUE

I like using the RGB function now instead of the codes. You can specify how much Red, Green, and Blue you want, so:

ListboxName.Backcolor = RGB(0,0,0) ' black
ListboxName.Backcolor = RGB(100,100,100) ' gray
ListboxName.Backcolor = RGB(255,255,255) ' white
ListboxName.Backcolor = RGB(255,0,0) ' red

And so on.
Serge Lefrancq
7 months ago
I think we are not talking about the same thing. The back color property of the list box is not the problem. In the calendar form, the days that are not part of the actual month are grayed out using code that refers to the current month of the Calendar Control. Since there is no calendar control available in Access 2016, the code can not get a Month value and gray out the days that are not part of the current month. My apologies if my first question was not very clear.
Add a Reply
Button Problems Upload Images   Link 
Janice Daniels 
9 months ago
Please help, I am trying to insert a refresh button on the form and when I drop the button on the form I am getting this message ' undefined function 'ApptLoadString' in expression', what have I done wrong? Read More...
Janice Daniels
9 months ago
Hi, please ignore my previous comment as I have fixed my button problem.
Richard Rost
9 months ago
Sounds like you're calling a function that doesn't exist. Spelling is usually the problem. Without seeing all of your code, it's impossible for me to say.
Add a Reply
Change the Month Upload Images   Link 
Austin Ritner 
10 months ago
Is there a way to make a button that will take the current month on the MonthlyCalendarF and +1/-1 to the next/previous month?
Richard Rost
10 months ago
Yes, I'm sure it's more than possible. I'll have to look at that database to remember how I built it. It's been 11 years already! I'm planning on completely updating this Seminar soon and making it more user friendly. The original was really just to show you how to format a form/report to look like a monthly calendar. I didn't realize so many people would actually be using it as a calendar program. Stay tuned!
Alex Hedley
10 months ago
Calendar Control Addendum 2
Add a Reply
Time for an Upgrade Upload Images   Link 
Richard Rost 
11 months ago
Is it time for a Calendar Seminar Upgrade? Read this.
Add a Reply
Print or email the calendar Upload Images   Link 
3 years ago
Hello, when I try to print or email the calendar form in print preview in Access 2016 I receive the following error message "A custom macro in this report has failed to run, and is preventing the report from rendering". Any ideas why? Read More...
Add a Reply
I am having problems with the date calendar Upload Images   Link 
Jimmm M 
4 years ago
I found them and I am good-2-go....Things are great.....Thx for this GREAT resource....
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/31/2021Hide Inactive
7/29/2021Event Enrollment
7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access

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