Scheduler Question

I'm looking for information on how I might create a sort of scheduling
matrix. What I would like is a Form/Subform that matches a column of CLIENTS
with a row of CAREGIVERS and the day and time of the appointments. Ideally,
this would resemble a weekly calendar, where only the appointments for the
current (or selected) week would appear. I'm thinking I need three tables...
Clients, Caregivers, and Appointments. I've looked at Peter Hibbs' Time
Sheet Display, using the Flex Grid control
(http://www.rogersaccesslibrary.com/f...67 9b5z316d54
) and I'm very interested but have no idea how to use it. Seems to me that
this is a Form design issue and maybe a code issue to make it work, but I'm
having trouble wrapping my head around it. Any pointers that will help clear
the mud would be appreciated, and references to resources that will do the
same will be gratefully accepted.

Here is an alternative approach from Allen Browne that you might find
interesting.

http://allenbrowne.com/AppRecur.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Jaybird5013" wrote in message
...
I'm looking for information on how I might create a sort of scheduling
matrix. What I would like is a Form/Subform that matches a column of
CLIENTS
with a row of CAREGIVERS and the day and time of the appointments.
Ideally,
this would resemble a weekly calendar, where only the appointments for the
current (or selected) week would appear. I'm thinking I need three
tables...
Clients, Caregivers, and Appointments. I've looked at Peter Hibbs' Time
Sheet Display, using the Flex Grid control
(http://www.rogersaccesslibrary.com/f...67 9b5z316d54
) and I'm very interested but have no idea how to use it. Seems to me
that
this is a Form design issue and maybe a code issue to make it work, but
I'm
having trouble wrapping my head around it. Any pointers that will help
clear
the mud would be appreciated, and references to resources that will do the
same will be gratefully accepted.

I have developed a calendar form/calendar report that does just what you are
asking. Both the form and report look just like a page torn from a wall
calendar. The month and year are selectable. Other functionality can be
programmed in to the calendar. I can implement the calendar form and
calendar report into your database for a very reasonable fee. I can email
you a screen shot of what I have if you contact me.

Steve




"Jaybird5013" wrote in message
...
I'm looking for information on how I might create a sort of scheduling
matrix. What I would like is a Form/Subform that matches a column of
CLIENTS
with a row of CAREGIVERS and the day and time of the appointments.
Ideally,
this would resemble a weekly calendar, where only the appointments for the
current (or selected) week would appear. I'm thinking I need three
tables...
Clients, Caregivers, and Appointments. I've looked at Peter Hibbs' Time
Sheet Display, using the Flex Grid control
(http://www.rogersaccesslibrary.com/f...67 9b5z316d54
) and I'm very interested but have no idea how to use it. Seems to me
that
this is a Form design issue and maybe a code issue to make it work, but
I'm
having trouble wrapping my head around it. Any pointers that will help
clear
the mud would be appreciated, and references to resources that will do the
same will be gratefully accepted.

"Steve" wrote in message
...
I have developed a calendar form/calendar report that does just what you
are asking. Both the form and report look just like a page torn from a wall
calendar. The month and year are selectable. Other functionality can be
programmed in to the calendar. I can implement the calendar form and
calendar report into your database for a very reasonable fee. I can email
you a screen shot of what I have if you contact me.

Steve



So stevie, whose calendar are you trying to flog?


Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

Ignore the person who replied. He doesn't offer you any solution free or
otherwise. Is his response what you would expect from an MVP? Contact me and
I will send you a screen shot of what I have. Then you can judge whether
what I have is what you are looking for.

Steve



"Steve" wrote in message
...
I have developed a calendar form/calendar report that does just what you
are asking. Both the form and report look just like a page torn from a wall
calendar. The month and year are selectable. Other functionality can be
programmed in to the calendar. I can implement the calendar form and
calendar report into your database for a very reasonable fee. I can email
you a screen shot of what I have if you contact me.

Steve




"Jaybird5013" wrote in message
...
I'm looking for information on how I might create a sort of scheduling
matrix. What I would like is a Form/Subform that matches a column of
CLIENTS
with a row of CAREGIVERS and the day and time of the appointments.
Ideally,
this would resemble a weekly calendar, where only the appointments for
the
current (or selected) week would appear. I'm thinking I need three
tables...
Clients, Caregivers, and Appointments. I've looked at Peter Hibbs' Time
Sheet Display, using the Flex Grid control
(http://www.rogersaccesslibrary.com/f...67 9b5z316d54
) and I'm very interested but have no idea how to use it. Seems to me
that
this is a Form design issue and maybe a code issue to make it work, but
I'm
having trouble wrapping my head around it. Any pointers that will help
clear
the mud would be appreciated, and references to resources that will do
the
same will be gratefully accepted.

"Steve" wrote in message
...
Ignore the person who replied. He doesn't offer you any solution free or
otherwise. Is his response what you would expect from an MVP? Contact me
and I will send you a screen shot of what I have. Then you can judge
whether what I have is what you are looking for.

Steve



Spoken like a real troll. Rather than try and defend your transgression, you
attack anyone who comments on it.

If I did not have to waste time protecting unsuspecting posters from your
attempts to pimp your questionable services I would be helping out more. I
guess you do not consider looking out for a posters best interests as being
helpful.

Post your questionable solicitations in a more appropriate venue.

John... Visio MVP

Jaybird,

Did you also check out the Crosstab Query in Flex Grid demo which can
probably do what you want with very little code and also the Flex Grid
Appointments-Bookings Demo may have something useful. These are both
on the same Web site as my main Flex Grid demo.

Peter Hibbs.

On Tue, 13 Apr 2010 15:00:01 -0700, Jaybird5013
wrote:

I'm looking for information on how I might create a sort of scheduling
matrix. What I would like is a Form/Subform that matches a column of CLIENTS
with a row of CAREGIVERS and the day and time of the appointments. Ideally,
this would resemble a weekly calendar, where only the appointments for the
current (or selected) week would appear. I'm thinking I need three tables...
Clients, Caregivers, and Appointments. I've looked at Peter Hibbs' Time
Sheet Display, using the Flex Grid control
(http://www.rogersaccesslibrary.com/f...67 9b5z316d54
) and I'm very interested but have no idea how to use it. Seems to me that
this is a Form design issue and maybe a code issue to make it work, but I'm
having trouble wrapping my head around it. Any pointers that will help clear
the mud would be appreciated, and references to resources that will do the
same will be gratefully accepted.

"Steve" schreef in bericht ...
I have developed a calendar form/calendar report that does just what you are asking. Both the form and report look just like a page
torn from a wall calendar. The month and year are selectable. Other functionality can be programmed in to the calendar. I can
implement the calendar form and calendar report into your database for a very reasonable fee. I can email you a screen shot of what
I have if you contact me.


Are you sure that YOU developed the form ???
I guess the code is just stolen from one of us here...

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!)

Arno R

Thank you all for your replies. Even you, Steve... :-) Mr. Hibbs, I will
look at your solutions in a bit. I am a bit worried that, finding a
solution, I will have no idea how to implement it. Are there any
accompanying documents that can walk me through it?

"Peter Hibbs" wrote:

Jaybird,

Did you also check out the Crosstab Query in Flex Grid demo which can
probably do what you want with very little code and also the Flex Grid
Appointments-Bookings Demo may have something useful. These are both
on the same Web site as my main Flex Grid demo.

Peter Hibbs.

On Tue, 13 Apr 2010 15:00:01 -0700, Jaybird5013
wrote:

I'm looking for information on how I might create a sort of scheduling
matrix. What I would like is a Form/Subform that matches a column of CLIENTS
with a row of CAREGIVERS and the day and time of the appointments. Ideally,
this would resemble a weekly calendar, where only the appointments for the
current (or selected) week would appear. I'm thinking I need three tables...
Clients, Caregivers, and Appointments. I've looked at Peter Hibbs' Time
Sheet Display, using the Flex Grid control
(http://www.rogersaccesslibrary.com/f...67 9b5z316d54
) and I'm very interested but have no idea how to use it. Seems to me that
this is a Form design issue and maybe a code issue to make it work, but I'm
having trouble wrapping my head around it. Any pointers that will help clear
the mud would be appreciated, and references to resources that will do the
same will be gratefully accepted.
.

Mr. Hibbs,

Your Employee Time Sheet demo is almost precisely what I am looking for. I
guess what I need is more information for how to do what you did.

Sincerely,

Jaybird