Calander for Access

I'm relatively new to this game and I have a question. I am trying to create
a calander that will come up automatically when the database is opened which
will highlight the current day. I want to be able to have 4 shift codes on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.

I provide help with Access applications for a very reasonable fee. I can
implement what you want into your database for a modest fee.

Steve



"Stryder09" wrote in message
...
I'm relatively new to this game and I have a question. I am trying to
create
a calander that will come up automatically when the database is opened
which
will highlight the current day. I want to be able to have 4 shift codes
on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.

Tryder09,

Please hang on for one of the reputable volunteers to provide you with FREE
support. It is NOT the practice of this forum to provide paid for support.
That would only be the policy of Steve 'who can I rip off today' Santus.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

"Stryder09" wrote in message
...
I'm relatively new to this game and I have a question. I am trying to
create
a calander that will come up automatically when the database is opened
which
will highlight the current day. I want to be able to have 4 shift codes
on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.

Sorry for typo...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

"Gina Whipp" wrote in message
...
Tryder09,

Please hang on for one of the reputable volunteers to provide you with
FREE support. It is NOT the practice of this forum to provide paid for
support. That would only be the policy of Steve 'who can I rip off today'
Santus.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

"Stryder09" wrote in message
...
I'm relatively new to this game and I have a question. I am trying to
create
a calander that will come up automatically when the database is opened
which
will highlight the current day. I want to be able to have 4 shift codes
on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click
the
shift letter to bring up the compliment for that day so it can be
modified
for absences, training and so forth. Any ideas for me? Thanks in
advance
for any help you can give.

Access has an ActiveX calendar control that can be used to display a
date -- but it is not able to be customized with text. Many folks shy
away from any ActiveX controls but, in my 15+ years of using Access, I
have only known 2 people who were not able to display it. I have a
popup calendar that uses it which I give freely.

To put a calendar control on your form:

from the form design:
Insert ActiveX control Calendar control

you can assign a date to it by using the control NAME property

Me.Calendar_controlname = date()

-- you can also bind the control to a field in the form RecordSource by
setting the ControlSource

~~~
as for the other question about bringing up a compliment, I am not sure
what you are asking...


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




Stryder09 wrote:
I'm relatively new to this game and I have a question. I am trying to create
a calander that will come up automatically when the database is opened which
will highlight the current day. I want to be able to have 4 shift codes on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.

"Steve" wrote in message
m...
I provide help with Access applications for a very reasonable fee. I can
implement what you want into your database for a modest fee.

Steve


Stevie you really need medical help. No one can be that oblivious to the
rules that have been pointed out thousands of times and not have something
mentally wrong with them.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are a number of experts who volunteer their time to help with
questions. Stevie is not one of those experts and is only interested in
conning unsuspected users out oftheir money.

John... Visio MVP

Crystal has already provided some information on your calendar control
options. I prefer using the calendar from Stephen Lebans site www.lebans.com.

Regarding a list of shifts, you can create a list box of all shifts. If you
want to filter this to only the shifts for a particular date, the Row Source
of the list box will need to have a criteria of the date selected.

You can use the double-click event of the list box to open a form or report
based on the selected date and shift.

If you have more questions, feel _free_ to come back with information about
your form and control names.

You can set a startup form in your mdb.
--
Duane Hookom
Microsoft Access MVP


"Stryder09" wrote:

I'm relatively new to this game and I have a question. I am trying to create
a calander that will come up automatically when the database is opened which
will highlight the current day. I want to be able to have 4 shift codes on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.

Thankyou Crystal and Duane for your responses. Okay I will try to explain it
a bit better. After looking at the Calendar that I need to modify, it does
look like an Active X Calendar. The Calendar itself is loaded in another
database and has two files to choose from the names listed are
ACShiftCal.1.0.118.oc1 and ACShiftCal.1.0.117.oc1 If I could get into the
files and look at how they are put together I might be able to modify ar
create what I need.

Right now when it loads it has a choice of 2 shifts for every day, we have 4
shifts that work on a 28 day rotation and the calendar places the appropriate
shift letter on the calendar days. When you double click the shift letter it
takes you into our compliment database where we can see the employees working
that day and it can be modified so that if an employee is absent due to
sickness this is where it gets logged.

With the market place the way it is right now in the North American housing
market we've had to curtail one shift. The problem I have now is that
instead of 4 shifts I have 7 shifts in total with 4 working everyday except
for our curtailment days when we only have 2. So I need to modify the
calendar but can't look at the two file that are loaded.

I'm not sure if this explanation is helpful and the only other way I could
explain is by showing someone the database itself.

Thanks,

Brad

"Duane Hookom" wrote:

Crystal has already provided some information on your calendar control
options. I prefer using the calendar from Stephen Lebans site www.lebans.com.

Regarding a list of shifts, you can create a list box of all shifts. If you
want to filter this to only the shifts for a particular date, the Row Source
of the list box will need to have a criteria of the date selected.

You can use the double-click event of the list box to open a form or report
based on the selected date and shift.

If you have more questions, feel _free_ to come back with information about
your form and control names.

You can set a startup form in your mdb.
--
Duane Hookom
Microsoft Access MVP


"Stryder09" wrote:

I'm relatively new to this game and I have a question. I am trying to create
a calander that will come up automatically when the database is opened which
will highlight the current day. I want to be able to have 4 shift codes on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.

Hi Brad,

you're welcome

you will not be able to modify the built-in ActiveX controls -- better
to take Duane's suggestion and use Leban's calendar so you have the
code. I have not looked at Leban's calendar (since I use my own) but I
have looked at other things he has developed; the man is a true genius.

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




Stryder09 wrote:
Thankyou Crystal and Duane for your responses. Okay I will try to explain it
a bit better. After looking at the Calendar that I need to modify, it does
look like an Active X Calendar. The Calendar itself is loaded in another
database and has two files to choose from the names listed are
ACShiftCal.1.0.118.oc1 and ACShiftCal.1.0.117.oc1 If I could get into the
files and look at how they are put together I might be able to modify ar
create what I need.

Right now when it loads it has a choice of 2 shifts for every day, we have 4
shifts that work on a 28 day rotation and the calendar places the appropriate
shift letter on the calendar days. When you double click the shift letter it
takes you into our compliment database where we can see the employees working
that day and it can be modified so that if an employee is absent due to
sickness this is where it gets logged.

With the market place the way it is right now in the North American housing
market we've had to curtail one shift. The problem I have now is that
instead of 4 shifts I have 7 shifts in total with 4 working everyday except
for our curtailment days when we only have 2. So I need to modify the
calendar but can't look at the two file that are loaded.

I'm not sure if this explanation is helpful and the only other way I could
explain is by showing someone the database itself.

Thanks,

Brad

"Duane Hookom" wrote:

Crystal has already provided some information on your calendar control
options. I prefer using the calendar from Stephen Lebans site www.lebans.com.

Regarding a list of shifts, you can create a list box of all shifts. If you
want to filter this to only the shifts for a particular date, the Row Source
of the list box will need to have a criteria of the date selected.

You can use the double-click event of the list box to open a form or report
based on the selected date and shift.

If you have more questions, feel _free_ to come back with information about
your form and control names.

You can set a startup form in your mdb.
--
Duane Hookom
Microsoft Access MVP


"Stryder09" wrote:

I'm relatively new to this game and I have a question. I am trying to create
a calander that will come up automatically when the database is opened which
will highlight the current day. I want to be able to have 4 shift codes on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.

I'm not sure how a calendar is "loaded in another database". Access has mdb
files, tables, fields, forms, reports, controls, queries, code, etc.

When you say "when it loads it has a choice of 2 shifts for every day,..."
we have no idea what "it" is. You should refer to controls and forms like:
"When my form [frmSelectShift] opens, there is a combo box
[cboShift] that allows the user to select a shift.
The Row source of the combo box is...."

You haven't really described much about your table structures or data. All
of us that try to help here (other than Steve Santos) like questions that we
can visualize as Access objects.
--
Duane Hookom
Microsoft Access MVP


"Stryder09" wrote:

Thankyou Crystal and Duane for your responses. Okay I will try to explain it
a bit better. After looking at the Calendar that I need to modify, it does
look like an Active X Calendar. The Calendar itself is loaded in another
database and has two files to choose from the names listed are
ACShiftCal.1.0.118.oc1 and ACShiftCal.1.0.117.oc1 If I could get into the
files and look at how they are put together I might be able to modify ar
create what I need.

Right now when it loads it has a choice of 2 shifts for every day, we have 4
shifts that work on a 28 day rotation and the calendar places the appropriate
shift letter on the calendar days. When you double click the shift letter it
takes you into our compliment database where we can see the employees working
that day and it can be modified so that if an employee is absent due to
sickness this is where it gets logged.

With the market place the way it is right now in the North American housing
market we've had to curtail one shift. The problem I have now is that
instead of 4 shifts I have 7 shifts in total with 4 working everyday except
for our curtailment days when we only have 2. So I need to modify the
calendar but can't look at the two file that are loaded.

I'm not sure if this explanation is helpful and the only other way I could
explain is by showing someone the database itself.

Thanks,

Brad

"Duane Hookom" wrote:

Crystal has already provided some information on your calendar control
options. I prefer using the calendar from Stephen Lebans site www.lebans.com.

Regarding a list of shifts, you can create a list box of all shifts. If you
want to filter this to only the shifts for a particular date, the Row Source
of the list box will need to have a criteria of the date selected.

You can use the double-click event of the list box to open a form or report
based on the selected date and shift.

If you have more questions, feel _free_ to come back with information about
your form and control names.

You can set a startup form in your mdb.
--
Duane Hookom
Microsoft Access MVP


"Stryder09" wrote:

I'm relatively new to this game and I have a question. I am trying to create
a calander that will come up automatically when the database is opened which
will highlight the current day. I want to be able to have 4 shift codes on
that date (ex. E Shift, H shift, A Shift, B Shift.) What I would like to
happen is when the calander comes up I want to be able to double click the
shift letter to bring up the compliment for that day so it can be modified
for absences, training and so forth. Any ideas for me? Thanks in advance
for any help you can give.