D
Dupatt
I will try to explain as simply as I can.
I have a database that keeps client records and creates appointment dates
and times after update of a provider name combobox by running a macro with
several queries. Now here is where I don't know what I am doing.
I have it working perfectly providing someone has not used the 9:00 spot in
the appointment book because I have it defaulting to 9am. How do I add code
to have the default change to a different time for any record where the 9:00
spot is already used?
I am not very good with the code writing though I can manage to add a
snippet in the right place if the major code is already there, such as the
sql for a query. I can do most of what I need with Access wizards. Any help
I can get will be gratefully received.
I have a database that keeps client records and creates appointment dates
and times after update of a provider name combobox by running a macro with
several queries. Now here is where I don't know what I am doing.
I have it working perfectly providing someone has not used the 9:00 spot in
the appointment book because I have it defaulting to 9am. How do I add code
to have the default change to a different time for any record where the 9:00
spot is already used?
I am not very good with the code writing though I can manage to add a
snippet in the right place if the major code is already there, such as the
sql for a query. I can do most of what I need with Access wizards. Any help
I can get will be gratefully received.