Prev: Maximize the form on the screen
Next: Problem exporting data to Excel using Access VBA
From: Jaybird5013 on 13 Apr 2010 18:00
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/forum/forum_topics.asp?FID=21&SID=bc153c21ec64e89z38fb679b5z316d54
) 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.
From: Jeanette Cunningham on 13 Apr 2010 18:31
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" <Jaybird5013(a)discussions.microsoft.com> wrote in message
news:9EF1E693-E4A6-4A71-83DD-69FB3277E44A(a)microsoft.com...
> 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/forum/forum_topics.asp?FID=21&SID=bc153c21ec64e89z38fb679b5z316d54
> ) 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.


From: Steve on 13 Apr 2010 18:58
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
santus(a)penn.com



"Jaybird5013" <Jaybird5013(a)discussions.microsoft.com> wrote in message
news:9EF1E693-E4A6-4A71-83DD-69FB3277E44A(a)microsoft.com...
> 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/forum/forum_topics.asp?FID=21&SID=bc153c21ec64e89z38fb679b5z316d54
> ) 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.


From: Steve on 13 Apr 2010 19:36
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
santus(a)penn.com


"Steve" <notmyemail(a)address.com> wrote in message
news:ewJMnz12KHA.1452(a)TK2MSFTNGP06.phx.gbl...
>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
> santus(a)penn.com
>
>
>
> "Jaybird5013" <Jaybird5013(a)discussions.microsoft.com> wrote in message
> news:9EF1E693-E4A6-4A71-83DD-69FB3277E44A(a)microsoft.com...
>> 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/forum/forum_topics.asp?FID=21&SID=bc153c21ec64e89z38fb679b5z316d54
>> ) 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.
>
>


From: John... Visio MVP on 13 Apr 2010 19:55
"Steve" <notmyemail(a)address.com> wrote in message
news:u9AcbI22KHA.4716(a)TK2MSFTNGP06.phx.gbl...
> 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
> santus(a)penn.com


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

 |  Next  |  Last
Pages: 1 2 3
Prev: Maximize the form on the screen
Next: Problem exporting data to Excel using Access VBA