Using the ActiveX Calendar in Access 2000 to track time off

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

lalalelu

Thread Starter
Joined
Apr 2, 2004
Messages
2
I have put an ActiveX Calendar in an Access 2000 form and want to be able to mark, on the calendar, when someone is out sick or uses vacation leave, etc. If possible, I would like to be able to click on a date and have the various possibilities (sick, vacation, education, holiday) pop up and be able to select which one to enter on that date.

I have created a table with the time off possibilities and have been trying to figure out if there is a way to incorporate an 'event procedure' that will insert the text. No luck yet and I'm feeling pretty frustrated.

Does anyone have any idea if this is possible?
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Your table presumably has a from date, a to date, and a type (sick, vac...).

Start with a form.
Place the 3 fields on the form.
Insert the activeX calendar control.

I can't help further, I don't think, but let me know if you get that far and can't figure it out. MBN (Must Be Nuts) will likely be in to give you the real deal on it.
 
Joined
Aug 21, 2003
Messages
2,016
Okay, very generally, yes you can create an event. If your event is a Click, for example, you can determine the value of the date with me.calendarControlName.Value.

So, for example, to test, you could have an event that looks like this:

Private Sub Calendar0_Click()
MsgBox "test" & " " & Me.Calendar0.Value, vbOKOnly
End Sub

Now, taking that one step further, you could have the event pop up a box with a name space and your choices and save those as well as the date value in another table.

Hope this helps,

MBN
 

lalalelu

Thread Starter
Joined
Apr 2, 2004
Messages
2
Thanks for the information. I was able to make a message box come up--worked very well.

I am still trying to figure out if I can add text to the calendar itself. . . The text can come from a table or be typed in, but I really want the item to actually appear on the calendar itself.

Is this possible with the activeX Calendar?

Thanks for whatever info you have. . .
 
Joined
Aug 21, 2003
Messages
2,016
Again, if you stop and think about it, you could create your own form that, when you click on a date in the calendar, populates a list control that could contain the information from that day. That way you can still have the desired information while keeping the calendar in view.

MBN
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top