Scheduler Question

[Jaybird5013]

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/...p?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.

 

[Jeanette Cunningham]

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

 

[Steve]

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

 

[John... Visio MVP]

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

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

 

[Steve]

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

 

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

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

 

[Peter Hibbs]

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.

 

[Jaybird5013]

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?

 

[Jaybird5013]

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

 

[Mark Andrews]

One of my template competitors has a pretty nice scheduling template:
http://www.accesstogo.org.uk/Appointments_Planner.html
It's a few bucks (not free)

Peter Hibbs has some nice flex grid samples which I see you found.

This guy has a scheduling template:
http://www.access-template.com/
Again a few bucks

I have an ongoing project to build an appointment scheduling program but I
want to do it better than
most of the Access samples you can find. Try utteraccess search for lots of
regular calendar samples.

If you want to just buy a program:
http://www.abs-usa.com/

The sample given away with the calendar control I was using is not too bad
(but be warned the more you try to do with it
the more difficult it becomes, at least a magnitude of 10 over traditional
access calendars or even flex grid work).
http://www.codejocksoftware.com/products/calendar/?platform=com

In my opinion using one of the nice calendar controls makes the application
much much nicer, but not a route for the
unexperienced to go down. .net development is probably a better way to go
if using one of these controls.

www.abs-usa.com would be my first suggestion. Appointment scheduling is
an area that is
pretty well covered by software products. Most are just a few hundred
bucks. Buy vs. build perhaps points to buy?

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

PS: Send me an email or call if you need any extra help. I looked at a lot
of appointment scheduling options last year when I started
writing my appointment software (It's not done at this point in time).

 

[Peter Hibbs]

Jaybird,

If you still want to use the flex grid control I would suggest you use
the Cross Tab example.

Although the code is relatively simple it would need some thought on
how to program the VBA code so unless you are very comfortable with
that, it could be a tricky project.

Perhaps if you study the code in the examples you can figure out what
you would need to do.

I don't know of any Flex Grid tutorials apart from what Microsoft
publish although as this control is mainly used by VB6 users you may
find something on Web sites for VB. The documentation I supplied does
give a list of all the properties, events, etc for the control (which
I guess you have already seen).

Peter Hibbs.

 

[Jaybird5013]

Thanks, everyone!

 

[Steve]

So after getting absolutely no help from vizio john and arno r, are you
interested in my calendar form/calendar report?

Steve
(e-mail address removed)

 

[John... Visio MVP]

So after getting absolutely no help from vizio john and arno r, are you
interested in my calendar form/calendar report?

Steve
(e-mail address removed)

Stevie, you are a hopeless case. Whose calendar solution 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

 

[Steve]

visio john is the one who does not understand the concept of FREE peer to
peer support! He never offers any help to posters in the Access newsgroups.
If visio john was truly an MVP, he would be offering help to posters rather
than repetitiously posting repugnant messages and wasting the time of all
who open his repugnant messages.

Steve
(e-mail address removed)

 

[John... Visio MVP]

visio john is the one who does not understand the concept of FREE peer to
peer support! He never offers any help to posters in the Access
newsgroups.

Wrong as usual. I do not post as many answers as I would like to because I
have to keep warning posters when you are in troll mode, but I have posted
answers to the Access newgroups. Including this week.

If visio john was truly an MVP, he would be offering help to posters
rather than repetitiously posting repugnant messages and wasting the time
of all who open his repugnant messages.

I guess in your eyes, helping posters avoid wasting time and money with a
troll is not being helpful.

Steve

Anyway, I have wasted enough time on your banality, so I am moving on till
the next time you try to peddle your unwelcome tripe.

John... Visio MVP