How to make an Interactive Calendar

[Michael San Filippo]

I have a scheduling utility that I need to implement a type of interactive
scheduler for different patients. I need to use it like Outlook has where
you can see the whole month, color code the appointment by missed/needs
employee assigned/cancelled - things like that. I would guess it needs to be
a Main form 1st then subforms. How would I go about doing that? Is there an
API or something i can use instead of recreating it?

Thanks in advance,
Mike

 

[Tim Ferguson]

Is there an
API or something i can use instead of recreating it?

There are loads of sheduling-type of ActiveX controls on the market. Try
looking in ComponentSource or WinFiles.com.

HTH


Tim F

 

[Michael San Filippo]

Thanks, I looked - Those are expensive. Any idea if there are any free ones
or forms that i can get that have the same idea?

 

[Tim Ferguson]

Thanks, I looked - Those are expensive.

That is because they are complicated, and people have to feed their
children too.

Any idea if there are any free
ones or forms that i can get that have the same idea?

If you want to roll your own, I would think about basing it in Excel, which
at least starts with rows-and-columns, and a UI that is really easy to make
pretty. The VBA and DAO etc underneath is exactly the same as in Access, so
there is fairly little to learn.

Alternatively, keep looking around the shareware sites: you might strike
lucky!

A final solution would be to get a copy of Vis Basic and write your own for
a profit!!!

All the best


Tim F

 

[Michael San Filippo]

Thanks man, its actually not as hard as I expected.

I have 1 table called scheduling.

the one main form and many other subforms for each day. Now i just have to
figure out how to do a calculation to tell me what day starts the first of
the month, ie. on a sunday/monday or so.

Thanks a bunch man.

Mike

 

[Tim Ferguson]

what day starts the first of
the month, ie. on a

WeekDay(DateSerial(SomeYear, SomeMonth, 1))


Tim F