Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: How To Input Value into ActiveX Calender ?

Geek News

How To Input Value into ActiveX Calender ?
"edisonl via AccessMonster.com" <u47544[ at ]uwe> 11/28/2008 9:47:20 AM
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: How To Input Value into ActiveX Calender ?
"Mike Painter" <mddotpainter[ at ]sbcglobal.net> 11/28/2008 5:37:08 PM
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 wrote:
[Quoted Text]
> 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


Re: How To Input Value into ActiveX Calender ?
"edisonl via AccessMonster.com" <u47544[ at ]uwe> 11/29/2008 2:00:18 AM
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

Mike Painter wrote:
[Quoted Text]
>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

--
Message posted via http://www.accessmonster.com

Re: How To Input Value into ActiveX Calender ?
"Mike Painter" <mddotpainter[ at ]sbcglobal.net> 11/29/2008 3:28:21 AM
I've sent it to what I'm guessing is your email address. Let me know.
edisonl via AccessMonster.com wrote:
[Quoted Text]
> 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
>
> Mike Painter wrote:
>> 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


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net