If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Scheduler Question
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. |
#4
|
|||
|
|||
Scheduler Question - the return of the TROLL
"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 |
#5
|
|||
|
|||
Scheduler Question
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. |
#6
|
|||
|
|||
Scheduler Question
"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 |
#7
|
|||
|
|||
Scheduler Question
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. |
#8
|
|||
|
|||
Scheduler Question
"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 |
#9
|
|||
|
|||
Scheduler Question
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. . |
#10
|
|||
|
|||
Scheduler Question
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 |
|
Thread Tools | |
Display Modes | |
|
|