Calander for Access

S

Stryder09

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.
 
S

Steve

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
(e-mail address removed)
 
G

Gina Whipp

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
 
S

strive4peace

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 :)
*
 
J

John... Visio MVP

Steve said:
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
(e-mail address removed)
Click to expand...

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
 
D

Duane Hookom

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.
 
S

Stryder09

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
 
S

strive4peace

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 :)
*
 
D

Duane Hookom

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.
 
S

Steve

Brad,

I developed an Access calendar form and report that looks like a page from a
wall calendar. They can display different data each day. The month and year
are selectable. I could implement the calendar along with the functionality
you describe here into your database for a modest fee.

Steve
(e-mail address removed)
 
J

John... Visio MVP

Steve said:
Brad,

I developed an Access calendar form and report that looks like a page from
a wall calendar. They can display different data each day. The month and
year are selectable. I could implement the calendar along with the
functionality you describe here into your database for a modest fee.

Steve
(e-mail address removed)
Click to expand...


These newsgroups are provided by Microsoft for FREE peer to peer support,
not as a venue to hawk your questionable wares. There are far better
solutions available for free.

John... Visio MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word doc keeps changing to ALL CAPS 0
Create a dynamic master file 1
problem with calanders - need help 1
Insert Index into a Table 1
Shift Patterns 2
Updatable Calander 3
view all of day in month calander 1
Counting cells that have a time 2

Top