schedule appointments in access

[lpcjd]

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!

 

[Duane Hookom]

If you don't have more specs about how you want the receptionist to be able
to do this our how it will look/work, I suggest you search for a canned
scheduling package.

 

[John Vinson]

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!

 

[lpcjd]

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?

 

[Duane Hookom]

lpcjd,
You are getting less vague with each post. It would help if you would ask a
specific question and provide enough information to get a specific answer.

 

[Tim Ferguson]

You are getting less vague with each post.

Less vague is good isn't it..? <g>


All the best

Tim F

 

[Duane Hookom]

If [Previous Vague] > [Current Vague] Then
MsgBox "Thank you for being more specific.", _
vbSmileyFace + vbWhoopeeOnly
Else
MsgBox "Please offer more specific details",
vbSadFace + vbWhoopA__Only
End If

 

[lpcjd]

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.

 

[Duane Hookom]

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