Let's look at some options here. First have you considered actually setting the appointments within Outlook via interoperability? Setting appointments in Outlook via VBA isn't hard and there are some advantages. If all of the Medical Staff are on the same Exchange Server, we can provide delegation rights to the person setting the appointments and allow them to add appointments directly into each Medical Person's calendar and also view those appointments. Also, setting the appointments as recurring is simply a case of setting a property.
Another option is to set the delegation rights and use the Outlook Viewer control in the database which allows Access to literally access Outlook within a form.
The last option, which is utlimately more fun and much more demanding is to sub class your own control and capture the events and use unbound data to fill it. For the type of form you are asking, this could take you longer than you actually have to do it, but if you're level of coding is expert then you can learn a lot from it.
My preferred option would be to go the Outlook way because all the necessary behaviour is already built in for you. If you want it to look like an appointment book with the power of Outlook, you could have 10 - 12 OutlookViewer controls all looking at a Medical Person's appoinments but all filtering to specific staff.
Hope this gives you some food for thought at the outset before embarking upon reinventing the wheel.
Duane Hennessy
Bandicoot Software
Tropical Queensland, Australia
(ABN: 33 682 969 957)
Why recode the wheel?
http://www.bandicootsoftware.com.au
--- In [email protected], "spheniscidaeconsulting" <[EMAIL PROTECTED]> wrote:
>
> HELP!!!!!!!!!!!!!!!!!!!!!!
>
> I have been developing a Medical Billing System customized to meet the
> needs of DES-DDD Providers in Arizona. And, thanks to some helpful
> hints and code from generous group members, it has been quite
> successful. I am embarking on the next step, and have hit a roadblock.
>
> I need to be able to create a Schedule/Appointment Calendar with the
> following capabilities:
>
> 1. Display a Multi-Column Screen with 10 - 12 Therapists
> appointments for any particular day. The day to be chosen by a Pop-Up
> Calendar.
>
> 2. Be able to schedule Recurring Appointments, similar to
> Microsoft Outlook.
>
> 3. E-Mail Therapists of Changes to the Schedule.
>
> 4. Be able to easily drill to detail of Appointment.
>
> My stumbling Block is the first requirement -- the display.
>
> Might any of you ACCESS WIZARDS have any insight, suggestions, or
> direction to proceed?
>
> Thank you for your assistance.
>
> Jonathan Smith
>
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
