MS Access Calendar

[MyWaterloo]

I made some modifications to the code to make it more 'usable' and 'generic'. Try it out and let me know what you think:

Thank You.
Sorry, I have been away from the Access world for some time. Yes, the calendar modifications were very helpful. =)

[ADezii]

Here is the latest, TOP SECRET, super dooper, new and improved, very simple, Access Calendar. Just dbl-click on any given Day to enter Event(s) for that Day. Have fun!

[pdebaets]

Very nice calendar, ADezii. Thanks!

[lostdog]

Thank Adezii,

I've been looking for something like this for quite a while now, I had been making do with a normal datasheet for this function.

The blank blocks at the start of the month seem to run slighty off, today is highlighted as a Sunday. Is there a way I can ammend the code behind to coreect this?

Thanks again!

[ADezii]

Thank Adezii,

I've been looking for something like this for quite a while now, I had been making do with a normal datasheet for this function.

The blank blocks at the start of the month seem to run slighty off, today is highlighted as a Sunday. Is there a way I can ammend the code behind to coreect this?

Thanks again!

This anomaly seems to be related to specific Time Zones, especially European, and has to do with the formatting of the 1st Day of the Month. In the PopulateCalenda r() Sub-Routine in the frmCalendar's Code Module, make sure the following line reads as follows:
[CODE=vb]
'Correct syntax for your Time Zone
strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)

'Incorrect syntax for your Time Zone (necessary for some Time Zones)
strFirstOfMonth = Str(intYear) & "/1/" & Str(intMonth)[/CODE]

[lostdog]

This anomaly seems to be related to specific Time Zones, especially European, and has to do with the formatting of the 1st Day of the Month. In the PopulateCalenda r() Sub-Routine in the frmCalendar's Code Module, make sure the following line reads as follows:
[CODE=vb]
'Correct syntax for your Time Zone
strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)

'Incorrect syntax for your Time Zone (necessary for some Time Zones)
strFirstOfMonth = Str(intYear) & "/1/" & Str(intMonth)[/CODE]

Thanks for the quick reply!

It makes sense now after reading your post, the code I replaced it with was

 strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)

Which sorted it out for the UK day/month/year date format.

Thanks again!

[blad3runn69]

wow ADezii way cool, kudos 2 u and thank you. You are a gentleman and a scholar!

[ADezii]

wow ADezii way cool, kudos 2 u and thank you. You are a gentleman and a scholar!

Thank you for the compliment, but as far as the 'gentleman' and 'scholar' part, you seems to be wrong on both parts! (LOL).

[truthlover]

Well you're definitely a hero to me (and I'm sure to many others after 32+ years on the fire department.)

Anyway, this calendar is exactly what I've been looking for. I tried to modify it by replacing the tblEvent reference with the table I wanted the values to be pulled from, but I got an error message saying "Item not found in this collection" and a blank calendar.

Is there a way to get the dates in my current database to tie in to this calendar?

Thanks!

Thank you for the compliment, but as far as the 'gentleman' and 'scholar' part, you seems to be wrong on both parts! (LOL).

[ADezii]

Well you're definitely a hero to me (and I'm sure to many others after 32+ years on the fire department.)

Anyway, this calendar is exactly what I've been looking for. I tried to modify it by replacing the tblEvent reference with the table I wanted the values to be pulled from, but I got an error message saying "Item not found in this collection" and a blank calendar.

Is there a way to get the dates in my current database to tie in to this calendar?

Thanks!

What exactly do you mean by 'tying' the Dates in your DB to this Calendar?

[truthlover]

I have a query qry_CrewList that generates a schedule of who is working on which project on any given day. The managers want to be able to look at a calendar and see in one view where everyone is scheduled.

Your calendar is perfect for that. I just need to know how to get the calendar to read the dates from the query.

Thanks!

What exactly do you mean by 'tying' the Dates in your DB to this Calendar?

[ADezii]

I have a query qry_CrewList that generates a schedule of who is working on which project on any given day. The managers want to be able to look at a calendar and see in one view where everyone is scheduled.

Your calendar is perfect for that. I just need to know how to get the calendar to read the dates from the query.

Thanks!

This may be very difficult, since the Calendar Application was never meant to 'Date Aware' in the sense that in can be Bound to a Date Field in a Data Source. I may be able to integrate it into your Database, but I will need qry_CrewList and its underlying Table(s), with some valid data. I will also need to know exactly what you want displayed in the Calendar for each Date since space is definately at a premium (Name and ProjectID)? Let me know if this is acceptable to you, and I'll give you my E-Mail address in a Private Message, where you can send the info as an Attachment.

[truthlover]

Yes, that would be great. And Name and ProjectID (or more likely SurveyWorkOrder ID) is all that's needed. I'll get the file ready for you.

Thanks!

This may be very difficult, since the Calendar Application was never meant to 'Date Aware' in the sense that in can be Bound to a Date Field in a Data Source. I may be able to integrate it into your Database, but I will need qry_CrewList and its underlying Table(s), with some valid data. I will also need to know exactly what you want displayed in the Calendar for each Date since space is definately at a premium (Name and ProjectID)? Let me know if this is acceptable to you, and I'll give you my E-Mail address in a Private Message, where you can send the info as an Attachment.

[truthlover]

I dont know if this helps any, but I dont need the ability to add an appointment from the calendar and I dont want the buttons to clear the appointments to be available at all.

I just need the calendar to display the schedules generated by the existing forms (which populates the query).

Thanks!

Yes, that would be great. And Name and ProjectID (or more likely SurveyWorkOrder ID) is all that's needed. I'll get the file ready for you.

Thanks!

[ADezii]

Yes, that would be great. And Name and ProjectID (or more likely SurveyWorkOrder ID) is all that's needed. I'll get the file ready for you.

Thanks!

I was able to create a certain effect utilizing [ProjectID], [ProjectSurveyor], and [DateCreated], with test data. I assumed that Name referred to the Project Surveyor, if not Who? Look at the Attachment.