Re: schedule appointments in access
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Sat, 8 Apr 2006 22:45:20 -0500
If you want to create a user interface that resembles a calendar (somewhat
like Outlook) then you may want to invest in a third party solution. If you
want reports that look like a calendar, check the samples at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.
Your schedule table could be as simple as
ClienID
AppointmentDate
Status
--
Duane Hookom
MS Access MVP
--
"lpcjd" <lpcjd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC198DA8-418B-43C2-8343-107F53C900A9@xxxxxxxxxxxxxxxx
Sorry about being vague. I'll try again. I have a client database with
service records. We have started seeing clients by appointment only and I
want to track the client's appointments in the database so I can tell for
each client when they have appointments and whether they kept or missed
the
appointment, etc. We are currently using a separate calendar for the
appointments and it isn't being tracked in the client database at all. I
don't know how to create a calendar in access in which you can enter data
for
appointments. We have Outlook, but I don't know about linking access to
Outlook, either. I thought it would be easier to do it all in Access.
"lpcjd" wrote:
I want to track scheduled, missed, and completed appointments for the
clients
in the database. If I use Outlook, is there a way to link an appointment
entry to a database client record to track the appointment there as well?
"John Vinson" wrote:
"lpcjd" wrote:
I need to set up an appointment calendar for our receptionist to
schedule in
based on client data in an access database. My level with access is
probably
intermediate. Not much knowledge about codes. Thank you!
Ummm... if you have Access, you surely have Outlook - which has a very
competent calendar, automated reminders, a good contact manager, etc.
etc.
Even though I'm primarily an Access developer, I keep all my scheduled
appointments in Outlook. Why reinvent the wheel when you have a good
four-door sedan?
You could do it without too much code; you'ld need to create tables of
Contacts, a calendar table of all workdays perhaps related one-to-many
to a
table of fifteen-minute timeslots, Forms, Subforms... it could be done,
but
it would be a LOT of work!
--
John W. Vinson[MVP]
.
- Prev by Date: Re: 'current' record from many side of relationship
- Next by Date: Re: 'current' record from many side of relationship
- Previous by thread: Re: schedule appointments in access
- Next by thread: Re: OLE Excel field
- Index(es):
Relevant Pages
|
