B
BCadle
Greetings Access gurus!
I have a database that allows me to input available appointment dates by
ApptType, AvailDate, and AvailTime into tblAvailAppts (AvailDateID is my
autonumber pk).
A separate table contains other information through which I can schedule a
person among other things. There is a cboApptType combo box that is set up
to filter the available dates shown in another combo box that shows Available
Dates as an expression based on the cboApptType selected (I used the
information from
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576 to create
the two synchronized combo boxes). Once selected, the record saves the
linked AvailDateID into the main table into a field named the same
(AvailDateID).
Now, what I'd like to do is figure out how to show the appointment in the
tblAvailAppts as booked once selected, so that i can filter it out to not
show in the cboAvailDates in the scheduling form. I would also like it to
show it as an open appointment in the event I need to reschedule the person
for whatever reason.
I added a field named Booked to tblAvailAppts and created an update query to
throw the person's name in there (it doesn't have to be their name, I just
wanted to test it out with anything that Is Not Null) and that all works.
The problem is when I reschedule the individual to another date, the
tblAvailDate.Booked field still shows the same information when I need it to
go back to null.
My head hurts severely and I'm positive I'm overlooking some kind of simple
query that can answer what I'm looking for. I can do copy and paste coding
as long as it's kind of simple (can't find a good place to learn about it).
I can access these forums at work, but I can't post anything, so it may take
a while for me to respond to the many questions I'm sure you might have...
this is my first go at this! thanks!
I have a database that allows me to input available appointment dates by
ApptType, AvailDate, and AvailTime into tblAvailAppts (AvailDateID is my
autonumber pk).
A separate table contains other information through which I can schedule a
person among other things. There is a cboApptType combo box that is set up
to filter the available dates shown in another combo box that shows Available
Dates as an expression based on the cboApptType selected (I used the
information from
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576 to create
the two synchronized combo boxes). Once selected, the record saves the
linked AvailDateID into the main table into a field named the same
(AvailDateID).
Now, what I'd like to do is figure out how to show the appointment in the
tblAvailAppts as booked once selected, so that i can filter it out to not
show in the cboAvailDates in the scheduling form. I would also like it to
show it as an open appointment in the event I need to reschedule the person
for whatever reason.
I added a field named Booked to tblAvailAppts and created an update query to
throw the person's name in there (it doesn't have to be their name, I just
wanted to test it out with anything that Is Not Null) and that all works.
The problem is when I reschedule the individual to another date, the
tblAvailDate.Booked field still shows the same information when I need it to
go back to null.
My head hurts severely and I'm positive I'm overlooking some kind of simple
query that can answer what I'm looking for. I can do copy and paste coding
as long as it's kind of simple (can't find a good place to learn about it).
I can access these forums at work, but I can't post anything, so it may take
a while for me to respond to the many questions I'm sure you might have...
this is my first go at this! thanks!