[mso] Calendar Controls (was Re: Access Design Table/Form)

Ok I found A calendar that works The way I want it to work... I just don't
know how to incorporate it into my frmSchedule.... In the Form Header I
figure I would put the redundant info ie: Employee Name, Client Name, Job,
and start / end time... in the detail part I want to use the calendar like
the one in the Attendance.mdb form.... Can somebody help me do this?? I
placed the Attendance.mdb and a Sample of my DB on my ftp site... the addy
is ftp.paceconsultingandtraining.com the username is mso and the password is
office  Also if anybody looks at it all, on my frmSchedule the combo box for
job, how do I only show the jobs needed that matches the Client that I am
working with??

Also, If I chose the Client First, and then the job that I want to schedule,
How can I see only the Employees that are qualified to do that job and not
all employees??  On the calendar... Can I disable the msgbox that says that
I am appending a table??  Can I make it so that I can check or uncheck a day
(make a mistake, or say the schedule is changed and x employee will not
cover a day) and it will not effect the underlying table until I save it??
Thank you SOOOOOOOO Much to who ever is willing to look at this... I will be
out Thursday afternoon, but will be here Thursday am and Friday pm.  

Lastly, I have not created it yet, but after the set Schedule form is
figured out I want to use this same calendar for another table/form... to
mark Employees vacation/personal days... or temporary changes to there fix
hours available... ie: John Doe, on the tblEmpAvailDays it says that he
works on Fridays from 8am-6pm  but on Fri, Feb 28, he will only be available
to work until 12pm.... or Joe Doe is taking vacation from March 1-7

Once that info is there, how do I incorporate it so that I know this when I
am making the fixed schedule above???  I am thinking If on the fix schedule
I try to schedule John Doe to work every M-F from 8-5 between the days of
Feb 21 and March 15 that I would get a message box saying that he is not
available on Feb 28 after 12pm or between March 1-7 and it would not
populate those days (hours) or something... Don't worry about it to much...
if it is not easy to incorporate it - I will just print a report of days the
employee is not available and manually be aware of the changes...

April Pace
4Office@xxxxxxxxxxxxx


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Colli, Anthony G
Sent: Wednesday, February 26, 2003 4:04 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Design Table/Form



April-

 I don't think you can make a calendar control into multiselect control. =
Basically just place it on a form, the date selected is available in =
code from the value property. If you had a calendar control on your form =
named objCal you can display the selected date like this.

 msgbox objCal.value

 objCal.Value contains the selected date on the calendar. To put that =
date into a table you will need to create the SQL dynamically and do the =
insert in code.=20

-Anthony

-----Original Message-----
From: 4office (E-mail) [mailto:4office@xxxxxxxxxxxxx]
Sent: Wednesday, February 26, 2003 3:46 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Design Table/Form


I found the Calendar Control.... Is there a way to select more than one
Day?? So in one Step I can select Monday, Wed, Friday and schedule an
Employee to Work 8-12 on those Days, on X Month??

Also, How do I use this calendar... Do I put it on it's on Form and Call
it... I what do I do once a day is click on... How do I populate my =
table
with that date??

April Pace
MOU AI
704-537-2521
arpace@xxxxxxxxxxxxx


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Colli, Anthony G
Sent: Wednesday, February 26, 2003 2:25 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Design Table/Form


April-
=20
 In form design view, the toolbox should have a 'more controls' icon. It
looks like a crossed hammer and wrench. If you open that you may have
installed the MS Calendar Control. It's pretty easy to use, put it on a
form, user selects a date, you can use that date anywhere in code. I =
don't
know about a clock, I have never used one.=20
=20
-Anthony



-----Original Message-----
From: 4office@xxxxxxxxxxxxx [ mailto:4office@xxxxxxxxxxxxx]
Sent: Wednesday, February 26, 2003 10:21 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Design Table/Form



<<<<<<<<<<<Now what we want to do is say "Create the Schedule for =
March".
So I want to
Choose March as the Date Month.... Then check which Days (Mon-Sun) and =
the
set Start/End Time... If I check all days between Monday-Friday... it =
will
Auto Populate the tblScheduledWork with the correct Dates and start/end
time... (So I don't have to do it Manually.... )>>>>>>>>>>>>>

Does anybody know where I can find one of those (I think) pop-up =
Calendars
that shows would show the month, that I can put on my form, that the =
user
can use to click on all the days that have the same start/end time (and =
may
be a popup "clock") that could be use to populate my table as talked =
about
above???

April Pace
MOU AI
704-537-2521
arpace@xxxxxxxxxxxxx


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =
quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =
also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =
quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =
also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************


-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =
also allow you to change your email settings to digest or vacation (no =
mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation with instructions.  Once you are a member of the files group, =
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************


-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: