How To Input Value into ActiveX Calender ?

[edisonl via AccessMonster.com]

Hi,

1. I am currently using Access 2000, developing Leave application.

2. What I tried to achieve is when user login to apply leave, they will see a
calender with names on dates that someone had taken leave (Group By
Department)

3. Is there anyway I can Achieve It ?

4. I am using ActiveX Calender Control 9.0 by the way.

5. In this way when anyone from the department log gin they are updated with
their peers attendence.

Edison

 

[Mike Painter]

I have a calender app that uses the tag property to show information on a
date when you hover over a button. It is shareware and I can send it to you
if you wish.
It was done by DCipher Solutions in New York, but I can't find a link to
them.

To show it in a format that looks like a real calendar is a bit of work.
You basically have to have a flat file to show the person and month as a row
with a seperate row for each person. Week ends and Holidays can be
conditionally color coded , etc and the results can be shown as a continuous
form by month.

BUT. It's a flat file and finding out when Fred has leave or who has leave
on May 3rd is a bit of a problem.
My soultion, because the client had to have something that looked just like
what the teachers were used to, was a seperate table which was maintained by
code. When they marked the date, it filled in this table with the student
ID, the date, the status, the field name and record ID from the flatfile
calendar.

 

[edisonl via AccessMonster.com]

Hi Mike,

Thanks for replying... that was awesome! May I have a look at it pls ?

By the way, I am using access 2000 think it can be open ?

PS: you might like to send it to to my mail

Edison

I have a calender app that uses the tag property to show information on a
date when you hover over a button. It is shareware and I can send it to you
if you wish.
It was done by DCipher Solutions in New York, but I can't find a link to
them.

To show it in a format that looks like a real calendar is a bit of work.
You basically have to have a flat file to show the person and month as a row
with a seperate row for each person. Week ends and Holidays can be
conditionally color coded , etc and the results can be shown as a continuous
form by month.

BUT. It's a flat file and finding out when Fred has leave or who has leave
on May 3rd is a bit of a problem.
My soultion, because the client had to have something that looked just like
what the teachers were used to, was a seperate table which was maintained by
code. When they marked the date, it filled in this table with the student
ID, the date, the status, the field name and record ID from the flatfile
calendar.

Hi,

[quoted text clipped - 12 lines]

Edison

 

[Mike Painter]

I've sent it to what I'm guessing is your email address. Let me know.

Hi Mike,

Thanks for replying... that was awesome! May I have a look at it pls ?

By the way, I am using access 2000 think it can be open ?

PS: you might like to send it to to my mail

Edison

I have a calender app that uses the tag property to show
information on a date when you hover over a button. It is shareware
and I can send it to you if you wish.
It was done by DCipher Solutions in New York, but I can't find a
link to them.

To show it in a format that looks like a real calendar is a bit of
work. You basically have to have a flat file to show the person and
month as a row with a seperate row for each person. Week ends and
Holidays can be conditionally color coded , etc and the results can
be shown as a continuous form by month.

BUT. It's a flat file and finding out when Fred has leave or who has
leave on May 3rd is a bit of a problem.
My soultion, because the client had to have something that looked
just like what the teachers were used to, was a seperate table which
was maintained by code. When they marked the date, it filled in this
table with the student ID, the date, the status, the field name and
record ID from the flatfile calendar.

Hi,

[quoted text clipped - 12 lines]

Edison