MS Access Calendar

[MyWaterloo]

Admin Note

This thread has been closed as it has gotten just too big.

If you have any questions about the application discussed in this thread please start a new thread in MS Access by clicking on the Start a Discussion button and link to the this thread in your question.

Original Question

Just wondering...Am I the only one in the access universe that would like an Outlook like calendar option? Is there such a thing as a calendar that can be used for data entry? You know...double click the day and "POP" up comes the event screen to enter data into. I have spent countless hours searching for such a phantom. Any thoughts or sites with a template/example/download?

Admin Edit

For ease of usage I will include a link here to the post in this thread with the latest version of the solution database.

Currently this is at Post #298.

Alternatively, if the attachment is all you require, then you'll find it here (Calendar.zip).

A wide angled version (for wider screen real-estate) has also been posted now at Post #327. The attachment there is Wide Calendar with Switchboard.zip.

[Megalog]

I haven't seen one myself, and I've looked as well. I've thought about taking the events template that came with Acc 2007, and changing it to work with a big dynamic form using text boxes or memo fields worked up like a calendar... but I dont have that kind of time =/ We'll probably just sync up with a Sharepoint events calendar later this year.

If anyone else has one, I'd love to see it.

[MyWaterloo]

I haven't seen one myself, and I've looked as well. I've thought about taking the events template that came with Acc 2007, and changing it to work with a big dynamic form using text boxes or memo fields worked up like a calendar... but I dont have that kind of time =/ We'll probably just sync up with a Sharepoint events calendar later this year.

If anyone else has one, I'd love to see it.

*SIGH*
I have been trying for...well...ov er a year now to create/find a database that has a data entry calendar. The company I work for has been looking for some type of maintenance database with a calendar scheduler. I created a database to hold all the maintenance entries, but I can't find anyway to have a calendar be used to add/show tasks. The pathetic little popup calendar for date picking just doesn't cut it. =( No one in the access universe uses a calendar in access?!?!?!?!? !?!?!?!?

[Megalog]

There is this calendar form for 97/2000.... but it really needs a makeover.

http://www.fabalou.com/Access/Forms/calendar_entry.asp

[MyWaterloo]

There is this calendar form for 97/2000.... but it really needs a makeover.

http://www.fabalou.com/Access/Forms/calendar_entry.asp

Thanks Megalog, but I have that calendar already. Every once in awhile I drag it back out and beat on it some more; just hoping it will all of a sudden come to life. Alas, it continues to lay there like yesterdays jello...no jiggle...no wiggle...no flavor...
Was worth a try though.
"A calendar a calendar, my kingdom for a calendar..."

[ADezii]

Just wondering...Am I the only one in the access universe that would like an Outlook like calendar option? Is there such a thing as a calendar that can be used for data entry? You know...double click the day and "POP" up comes the event screen to enter data into. I have spent countless hours searching for such a phantom. Any thoughts or sites with a template/example/download?

See if something like this is what you are looking for. It can be easily modified:

[mshmyob]

In 2007 there is a built in date picker for date fields. When you set up a date field under the Format properties set the "Show Date Picker" to "For Dates".

That way when a user enters the date field a little Icon appears to the left and if they click on it a calendar popsup.

I don't remember if that is available before 2007 it has been awhile since I used an older version.

[Megalog]

In 2007 there is a built in date picker for date fields. When you set up a date field under the Format properties set the "Show Date Picker" to "For Dates".

That way when a user enters the date field a little Icon appears to the left and if they click on it a calendar popsup.

I don't remember if that is available before 2007 it has been awhile since I used an older version.

The popup date picker is nice, but he's asking for an actual calendar form where you see the events inside the dates.

[mshmyob]

To quote RoseAnn RoseAnna Dana ...... Nevermind ...... LOL

The popup date picker is nice, but he's asking for an actual calendar form where you see the events inside the dates.

[MyWaterloo]

See if something like this is what you are looking for. It can be easily modified:

Thanks for the calendar!! Looks very promising. Can't figure out what the letter sets of 3 are, i.e. BDF, CAE, DCF ???? What a whopping amount of code! =) Thanks again.

[MyWaterloo]

Thanks for the calendar!! Looks very promising. Can't figure out what the letter sets of 3 are, i.e. BDF, CAE, DCF ???? What a whopping amount of code! =) Thanks again.

Oops! LOL,

I found the solution to the letter sets. Ok, new question. (You may regret giving me the calendar because of a whole new set of questions it will produce.) =)
I have a maintenance table and form. I have placed a check box on the form to indicate whether or not the user wishes to send the info to the events/calendar. This procedure works. I would like to be able to go to a different month quicker and easier. It takes a good many clicks to get back to 2005. Seeing the calendar is based solely on VB and there is no record source for it...Is there a way to choose a specific month? Maybe a combobox that I can select a month that OnChange the VB would interpet my selection and show that month?
Well, maybe I'm grasping at straws. As always, Thanks.

[ADezii]

Thanks for the calendar!! Looks very promising. Can't figure out what the letter sets of 3 are, i.e. BDF, CAE, DCF ???? What a whopping amount of code! =) Thanks again.

This Calendar was designed for the Philadelphia Fire Department, of which I was a member for 32+ years. The letter sets represent Platoon Working Schedules.

[ADezii]

Oops! LOL,

I found the solution to the letter sets. Ok, new question. (You may regret giving me the calendar because of a whole new set of questions it will produce.) =)
I have a maintenance table and form. I have placed a check box on the form to indicate whether or not the user wishes to send the info to the events/calendar. This procedure works. I would like to be able to go to a different month quicker and easier. It takes a good many clicks to get back to 2005. Seeing the calendar is based solely on VB and there is no record source for it...Is there a way to choose a specific month? Maybe a combobox that I can select a month that OnChange the VB would interpet my selection and show that month?
Well, maybe I'm grasping at straws. As always, Thanks.

Seeing the calendar is based solely on VB and there is no record source for it...Is there a way to choose a specific month? Maybe a combobox that I can select a month that OnChange the VB would interpet my selection and show that month?

1. The Record Source for the Form is not explicitly stated, but it does write to tblEvent.
2. When I get a chance, I'll modify the code so it can Navigate to a given Year/Month more quickly, but you must be patient.

[MyWaterloo]

1. The Record Source for the Form is not explicitly stated, but it does write to tblEvent.
2. When I get a chance, I'll modify the code so it can Navigate to a given Year/Month more quickly, but you must be patient.

Thank you ADezii. I really appreciate your time and help on this issue. I did notice the table "tblEvent." What I meant by not having a record source referred to the year/month/day not being based on a table but all figured in VB. My own limited knowledge of VBA has been self taught and wrought with much frustration (and much reward) at times. I have been seeking out an effective event calendar for somewhere around ?3? years? Thank you again for your time and sharing your resource.
Waiting Patiently, =)
MyWaterloo

[ADezii]

Thank you ADezii. I really appreciate your time and help on this issue. I did notice the table "tblEvent." What I meant by not having a record source referred to the year/month/day not being based on a table but all figured in VB. My own limited knowledge of VBA has been self taught and wrought with much frustration (and much reward) at times. I have been seeking out an effective event calendar for somewhere around ?3? years? Thank you again for your time and sharing your resource.
Waiting Patiently, =)
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: