ho***@gmavt.net (Mike) wrote in message news:<20**************************@posting.google. com>...
I've been asked to design a databse to schedule staff with clients.
I'm wondering if anyone has done this type of project before and if
there are any Active X controls anyone is familiar with that might be
useful in this kind of database.
Ho boy. Yeah, it's called Outlook. Otherwise, look around for posts
by Albert Kallal. I discussed this with him a LONG time ago in this
NG. It's a PITA but doable in Access. The hard part is the time
logic. Also, do you want to allow one resource to be double-booked?
ActiveX controls? For what? Time/Date stuff? I don't like ActiveX
controls anyway - leads to distribution nightmares. You can get some
handy tools from Access Developer's Handbook XX (XX-your version of
Access) on the CD. Most definitely worth the money - KG even has a
function/form that implements a non-ActiveX calendar control. Works a
charm with maybe a little tweaking. The one thing I had to tweak in
it was that if you have a date/time field on your form that uses the
function to get its value, the existing value will get erased if you
open the calendar control and close it again without choosing a new
value. Not hard to override, though. You just stuff the old value
into a temporary variable and ask the user if he wants to restore the
old value on exit if the new value is null.
HTH,
Pieter