D
Don
I have a form with a subform that I enter and track appointments. The data to
be entered in the form is ResourceType, ScheduleDate and FacilityID
(comboPK). These fields are all parent/child links with the subform. The
subform has fields that I enter the "patient number" and "notes" of what the
appointment is for.
Also on the subform is a combo box that has a select query of appointment
times that are 15 minutes apart. This combo box is named "Start Time" and is
made up of a select query of a table called "Appointment Times". The combo
box "Start Time" has a control source named "ScheduleStartTime" which is a
field of the "Appointment Detail" table. Confused yet?
After doing much input of the appointments, it would be much more efficient
for the user to enter only information in the "patient number" and "notes"
fields and have the next available appointment time for that "ResourceType,
ScheduleDate and FacilityID(ComboPK)" , automatically entered in the control
source field "ScheduleStartTime".
I have tried a couple of ways but this is too complex for me. Access has to
look at the first available "ScheduleStartTime" for all of the records for
the "ResourceType, ScheduleDate and FacilityID(ComboPK)", then based on the
combo box select query in the form "Start Time" select the next available
time that is not in the field "[Appointment Detail].[ScheduleStartTime]". I
think the logic must compare the times against all that days appointment
records because a user may enter the first appointment time in the "Start
Time" query out of order by mistake possibly throwing a more simple logic
off. I hope this is clear?
I seems that I also have to allow for custom entries in the
"ScheduleStartTime" field that does not follow the 15 minute rule for special
group sessions where we schedule up to 10 patients one minute apart. This one
minute apart business must be done as, built into the form, is logic that
does not allow for double entry of appointment times as to not accidently
double up on appointments. Manully changing the times the code puts in in not
a problem but the code should recognize 08:10 as 08:00 and choose 08:15 as
the next appointment time.
How can I make this work?
Thanks,
Dennis
be entered in the form is ResourceType, ScheduleDate and FacilityID
(comboPK). These fields are all parent/child links with the subform. The
subform has fields that I enter the "patient number" and "notes" of what the
appointment is for.
Also on the subform is a combo box that has a select query of appointment
times that are 15 minutes apart. This combo box is named "Start Time" and is
made up of a select query of a table called "Appointment Times". The combo
box "Start Time" has a control source named "ScheduleStartTime" which is a
field of the "Appointment Detail" table. Confused yet?
After doing much input of the appointments, it would be much more efficient
for the user to enter only information in the "patient number" and "notes"
fields and have the next available appointment time for that "ResourceType,
ScheduleDate and FacilityID(ComboPK)" , automatically entered in the control
source field "ScheduleStartTime".
I have tried a couple of ways but this is too complex for me. Access has to
look at the first available "ScheduleStartTime" for all of the records for
the "ResourceType, ScheduleDate and FacilityID(ComboPK)", then based on the
combo box select query in the form "Start Time" select the next available
time that is not in the field "[Appointment Detail].[ScheduleStartTime]". I
think the logic must compare the times against all that days appointment
records because a user may enter the first appointment time in the "Start
Time" query out of order by mistake possibly throwing a more simple logic
off. I hope this is clear?
I seems that I also have to allow for custom entries in the
"ScheduleStartTime" field that does not follow the 15 minute rule for special
group sessions where we schedule up to 10 patients one minute apart. This one
minute apart business must be done as, built into the form, is logic that
does not allow for double entry of appointment times as to not accidently
double up on appointments. Manully changing the times the code puts in in not
a problem but the code should recognize 08:10 as 08:00 and choose 08:15 as
the next appointment time.
How can I make this work?
Thanks,
Dennis