This looks Awesome. Can't Wait!! did I tell you I can be impatient!! Please, Please !!

Working on multi-day appointments now.

Yes, as we talked about previously, no one wants to click back how many times in months or years to put in Sir Isaac Newton's birthdate.

Maybe it looks too busy with the ISO date above each day? Or are you adding an option to just show the day's number?

I was going to make it user-configurable, but yeah, you're right - looks a little busy.

There... better?

Multi-day appointments? Check...

Working on recurring appointments now.

Very nice! I like it a lot better with just the day instead of the complete date.

Yes, it looks better, to me at least. Your last calendar was just a calendar, for picking dates if I recall (unless you had more than one). So, is this meant to be more of a "calendar" for appointments/time management? Are you making it flexible to handle journaling (things like phone calls to clients {bahahaha}) and tasks? Does Dinner with Bill include a link to Bill? Double click on a day and see the whole day in lines, like Outlook? In the mid 1990s I tried to use Outlook  and Exchange server I think it was, but it had so many bugs and growing pains that I never fully implemented it. Are we going in that direction?

Loving it!!!  Will date/time formats be configurable (i.e. ISO-8601, US, European, Stardate)?

They will default to your system's default date format, which should be ISO. Dammit. :)

I prefer the German way, with dots (periods) instead of the busy dash (hyphen) used by the ISO.

Dots are fine too. As long as its yyyy*mm*dd I don't really care what the delimiter is.

Did a little more tweaking today. Created a single day view which keeps the daily formatting, and of course the add/edit/delete form complete with a color picker for your appointments (unlike the small palette that Google Calendar gives you).

I am assuming you are using Courier New. I looks great both the Monthly Calendar and the Daily Calendar.

Kevin yeah, I had to use a monospaced font to get the boxes to line up just right because I'm setting the background color using HTML, and if you use a proportional spaced font then you can't judge how far across to make that background color go.

But the good news is it's no longer just a monthly calendar now - you can specify the number of weeks to see. You wanna see 2 weeks, 3 weeks, 4 weeks, or the whole month? Just change the box and you can slide back and forth between weeks too.

I was going to leave 5 weeks on there, but I wouldn't want people to select 5 weeks and then move to a month that has, say, the 31st day as the Sunday, and the next week they forget that there's another day so I intentionally got rid of 5 weeks.

Since we are talking about ISO 8601, I would also argue in favour of Monday as the first day of the week.
After all, the weekend (Saturday and Sunday) should be at the end of the week.

That's a good idea. And it wouldn't be hard to add as a setting. I'll add it to the list.

I played around last night with getting calendar items to sync to and from Google Calendar because that's what I use personally, and it'd be nice to be able to click a button and have it sync. That might take a lot more work though, so that's just not promised - I'm not saying it's definitely going to be in there, but I think it'd be cool because I use Google Calendar myself and I love Google Calendar because it's available on every platform. You can use it on your desktop, it's on your phone, you can even pull it up on your smartwatch. To be able to tie your Microsoft Access database into that would be wonderful. But coding for Google's API, especially with VBA, is not easy. I've done it before for some other projects, and it's a pain in the behind. I played with it for about an hour last night and I gave up. I'm going to try a different approach later.

There... easy change. I've got it saved as a global constant now, but I'll be making a settings form for preferences like this later.

Doesn't the Windows configuration have a setting for the first day of the week?

Google-APIs
VBA-Web | VBA-tools
https://github.com/VBA-tools/VBA-Web/wiki/Google-APIs

I've played with OAuth before. It's a nightmare. This is much easier. Just requires a tiny bit of setup on behalf of the user.

I've got creating, editing, and deleting Google calendar items working. Next is reading existing ones.

Google APIs Explorer
https://developers.google.com/apis-explorer

Calendar
https://developers.google.com/workspace/calendar/api/v3/reference

24 hour time as an option?
I was going to say military time, but do we really want to go with Zulu time?

Read in other calendars, for example Bank Holidays
https://www.gov.uk/bank-holidays

Sporting Calendars - Show your team's matches

Current Temp? Weather conditions.

Multiple Calendars?
Show/Hide given ones.

If you ever wondered why it was called "Zulu Time", that's the letter they use for GMT.
J zone or Juliet time is local time.

Now fully able to read AND write Google Calendar items. Working on automatic synch now...

There's a lot of extra stuff on there. Some buttons and some fields and stuff that are for testing and development. I'm going to clean up the interface a lot before I release it, but it's coming along nicely.

Does this work for just one person or a group? Personal items may want to be encrypted so people that can read the table (one table right?) can't read about your honeymoon activities. Similar to what Alex said, different levels of the organization might want to add items that individuals can see, like corporate dates (all those holidays), department dates, work group dates, etc.

As time marches on during a day with +18 more, does the day scroll? Maybe just one row at the top of the day with |-10    +8| (left and right justified)?

Does the recurring handle birthdays, that may have an interval different than 365 thanks to leap years? (You may want to add day, month and year option buttons?)

Right now, it just handles a single person, but I am planning on making it multi-user aware. As far as personal items go, that is definitely a possibility. As far as encrypting the table goes, you could do that, or if it's that critical that the stuff is private, you just put the data on SQL Server. Don't put honeymoon activities on your work calendar lol. A corporate calendar is a good idea - days off, that kind of stuff. The boxes in the monthly calendar at the size I've got right now show three items. If there's more than that, it will just say +3 more at the bottom. And then when you click on the month calendar, it will open up the daily calendar to the right which will show an unlimited number of items and will scroll up and down. The form to the far right is where you can add, edit, and delete items. It's easier doing it this way than it would be to edit in place because I'm using HTML and formatting tricks to display things with the colors and properly like that. As far as recurring items go, right now there's daily, monthly, and annually. And yes it uses a true DateAdd, so leap years are not an issue.

How about a user configurable count down list for special events like weddings, births, vacations?

Hey Richard, You may want to delete the map I added above (for copyright) and add this link to the message just above. www.worldtimezone.com.

Dave so basically this: Event Countdown

Thomas I don't think they'd mind. We're not profiting off their work. Fair use. If anything, now that you gave the link, it's helps promote their site. I'll hyperlink that for you.

Yes!

Integrated all three forms together. I think it works much better this way. Daily and the Edit form are now subforms in the Monthly form. Flows a lot better.

Google Calendar sync is coming along. Still some quirks I'm working out. If you just do all of your editing, adding, and deleting from the database, it works perfectly. Still having an issue though if you create an appointment with the database, then modify/delete it on the web, and then modify it in the database BEFORE you sync. Still have to deal with some conflict resolution.