Appointment Scheduling in Access

[Rob M]

Hi all,

I'm trying to create *very* simple patient scheduling capabilities in Access
2003.

We currently have a patient database with demographic info plus the date of
the patient's next appointment. The next appointment date is simply entered
in a text box. From there, we manually type in patients' next appointments
into an Excel spreadsheet.

If possible, I'd like to link the next appointment date to a calendar in
Access, thereby eliminating the need to involve Excel. Ideally, adding,
changing, or deleting the upcoming appointment in Access would automatically
create, update, or delete a month-view calendar entry in Access.

The format of each entry would be:
Line 1: FirstName LastName, Health Care #
Line 2: Doctor / Assistant

We require only a month-view calendar because we see only two patients per
day. Therefore each day of the month needs to hold only 4-5 lines of text.

Is this possible within Access? Any help would be appreciated, including
references to existing freeware Access databases.

Thanks,
Rob

 

[Wayne-I-M]

HI rob

You don't need to pay anyone for this.

It all depends on th complexity of what you want to display.

If it were me I may design a lining table (between patient and doctors
tables) with
Apointment ID
Patient ID
DoctorID
DateTime
etc
etc
This table would just hold the details of the appointment and any
information directly concerning this - don't tempted to add medications to
this table by the way you need another table for this

This time date section could be actioned by a calendar or you could add a
subform restricted to today's date plus 31 (so you can always see the next
month's appointments). On the sub form have an OnClick to take you to the
day. etc etc
Create a query and base a form on this

Anyway - have a go at it and if you have any specific questions post back
with another question and I'm sure someone will answer you

 

[John... Visio MVP]

I provide help with Access and Excel applications for a modest fee. I
developed a month calendar form and report that does exactly what you
describe. You can display different data for each day and the year and
month of the calendar are selectable. You can add, edit and delete any
data for any day right on the calendar. If you are interested, contact me
at (e-mail address removed).

Steve

These newsgroups are provided by Microsoft for FREE peer to peer help.
Stevie is a known troll who harasses the newsgroup posters offering
questionable help at unreasonable prices.

John... Visio MVP

 

[Duane Hookom]

There are some sample calendar reports at
http://www.access.hookom.net/Samples.htm.

Let us know if you need more "free" assistance. We are glad to provide this
to you at no cost.

 

[Rob M]

Thank you to Wayne and Duane for your help! I appreciate it tremendously.
I'll start with your suggestions and write back if I need further help.

All the best,
Rob

 

[Larry Linson]

These newsgroups are for free help, not for people to advertise their
for-fee services, no matter how "modest" the fee. Consider whether you
would really want to engage someone who has demonstrated they are not
willing to follow the rules.

Also, Steve's relatively few posts containing technical information here in
the newsgroup seem often to have to be corrected by others who actually know
the correct answer, in any case.

Larry Linson
Microsoft Office Access MVP

 

[John... Visio MVP]

These newsgroups are for free help, not for people to advertise their
for-fee services, no matter how "modest" the fee. Consider whether you
would really want to engage someone who has demonstrated they are not
willing to follow the rules.

Also, Steve's relatively few posts containing technical information here
in the newsgroup seem often to have to be corrected by others who actually
know the correct answer, in any case.

Larry Linson
Microsoft Office Access MVP

The other key point is that if he was any good, he should have enough repeat
business or referrals to make it unnecessary to be annoying posters by
begging for work.

John... Visio MVP

 

[Awrex]

Awesome, just what I was looking for!

There are some sample calendar reports at
http://www.access.hookom.net/Samples.htm.

Let us know if you need more "free" assistance. We are glad to provide this
to you at no cost.