Using Calendars in Access

[paulgallanter]

Hi, I’m working with a labor agency that schedules about 400 people. Up to
now, all the work is done on paper and whiteboards. The office manager
started to make a calendar in Word or Excel for each worker but it became
slow and difficult to find each tab when needed. In addition, the calendar
alone did not allow the workers to be sorted by skills or rates or locations.

My question is this: is there a way to put a self-generating calendar in an
Access form where, for each name selected from list, their personal calendar
would come up.

With the calendar as part of a form, the rest of the form can contain other
information for finding workers by skill, rates and so on.

I know how to build basic relational data bases but I don’t know about using
a calendar as a graphic interface.

Thanx, paul

 

[Steve]

Paul,

I have developed a calendar form look slike a page torn from a regular
calendar. The year and month are selectable. The calendar form can display
different data for each day. There is also a calendar report that looks just
like the calendar form. It can be printed to get a hardcopy of the calendar
form that is currently on the screen. I have implemented my calendar form
and report into the databases of numerous customers.
For your application, my calendar form and report could be implemented to
sort workers by skills or rates or locations. It also could be further
implemented to show the personal calendar of an individual worker. I charge
a fee to implement my calendar into an existing database. If you are
interested, contact me at my email address below.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John Marshall, MVP]

Steve you really must be thick. How many times do you have to be remined
that these newsgroups are for FREE peer to peer support, not for soliciting.
Can't you get a real job?

John... Visio MVP

 

[Steve]

Okay then, why don't you offer "FREE peer to peer support" instead of your
worthless responses? Once again you demonstrate that you are an embarassment
to the principles of being an MVP.

 

[Gina Whipp]

Here is a link to Duane Hookom's page that might have what you need
http://www.access.hookom.net/Samples.htm There are some calendar databases
on this page.

 

[John Marshall, MVP]

Let me spell it out for you.

- These are newsgroups provided by Microsoft for FREE peer to peer support.
- Occassionally script kiddies with a poor understanding of manners ignore
the rules.
- Someone has to remind them of the rules. (Something I consideras helping
the community)
- For the regular users, they can block the obnoxious offender and they can
block anyone who tries to remind the offender.
- If the reminder is blocked so is any helpful post they post. So it is
better to be a sacrificial lamb and let someone else handle the helpful
answers. Tony, Doug, Albert, Arvin, Larry and many other experts are more up
to the helpful task.
- Keep an eye on you is a full time task, giving little time for helpful
answers.

As to embarassment, I'll have to concede that you are far better at that.
Half answers, wrong answers, "your database is wrong" answers. Asking
questions without using your normal signature so that they can not be
associated with your other posts, to pretend you know it all.

(I'm surprised as the great computer expert that you knew nothing about dot
net).

Steve, grow up, get a real job and stop polluting these newsgroups with your
wrong answers and solicitations.

John... Visio MVP

 

[tina]

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

II

LOL

 

[Steve]

Let me spell it out for you --

You just spent whatever time it took you to write this worthless response
rather than provide one iota of "peer-to-peer" help to the OP. You took up
space in this newsgroup with your worthless response.
<<Keep an eye on you is a full time task, giving little time for helpful
answers.>>
So tracking my responses in the newsgroups is more important to you than
providing "peer-to-peer" help to posters in the newsgroups. You certainly
prove that you are an embarassment to the principles of being an MVP.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Steve]

Well then, why don't YOU provide something helpful to the OP?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John Marshall, MVP]

You really do not get it. There are a number of MVPs and other regulars who
are far better than I, but you are definitely not one of them. So rather
than have them waste their time with your trash, I have decided to help out
by putting the bell on the cat. So whether I post a relevant answer is not
the point, my purpose is to warn the unsuspecting new comers to your
unethical behaviour. If you can not be trusted to behave ethically in the
newsgroups, how can they trust you in a business relation?

You have in the past claimed to have helped thousands, but we are still
waiting for one of them to step forward and give you support.

So steve, grow up and go away. Your type of help is not worth the
aggrevation you cause in the newsgroups.

John... Visio MVP

 

[Steve]

You really do not get it! The newsgroups are for providing "peer-to-peer"
support. You have made three worthless posts in this thread and have not
provided one iota of help to the OP. The principles of being an MVP state
that an MVP is to provide help to users of Microsft Software to the best of
his ability. Three worthless posts and not an iota of help to the OP, you
are an embarassment to the principles of being an MVP.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)