MS Access Calendar

MyWaterloo

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.

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?

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.

Jan 19 '08 #1

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.

Jan 19 '08 #2

MyWaterloo

*SIGH*
I have been trying for...well...over 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?!?!?!?!?!?!?!?!?

Jan 19 '08 #3

Megalog

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

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

Jan 19 '08 #4

MyWaterloo

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..."

Jan 19 '08 #5

ADezii

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

Jan 19 '08 #6

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.

Jan 20 '08 #7

Megalog

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

Jan 20 '08 #8

mshmyob

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

Jan 20 '08 #9

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.

Jan 20 '08 #10

MyWaterloo

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.

Jan 20 '08 #11

ADezii

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.

Jan 20 '08 #12

ADezii

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.

Jan 20 '08 #13

MyWaterloo

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

Jan 20 '08 #14

ADezii

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

Jan 21 '08 #15

MyWaterloo

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

Mar 22 '08 #16

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!

Mar 22 '08 #17

pdebaets

Very nice calendar, ADezii. Thanks!

Mar 22 '08 #18

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!

Mar 25 '08 #19

ADezii

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 PopulateCalendar() Sub-Routine in the frmCalendar's Code Module, make sure the following line reads as follows:

Mar 25 '08 #20

lostdog

Thanks for the quick reply!

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

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

Thanks again!

Mar 25 '08 #21

blad3runn69

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

Mar 25 '08 #22

ADezii

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

Mar 25 '08 #23

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!

Apr 8 '08 #24

ADezii

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

Apr 8 '08 #25