Run query on Click Event?

[Paulfakins]

Still new at this, but I'm giving it my best.

I have built a form for entering appointments. I have disabled the record navigation bars and placed a button on the form to "schedule appointment". I would like to change the event procedure to check for duplicate appointment times with the same employeeID and generate an error message if there is a conflict. If no conflict, add the record and continue.

Any help would be appreciated ray:

 

[Dugantrain]

You can do this a number of ways, the easiest (albeit not the prettiest) way is just to go to the underlying table that the data is stored in and, in the properties of the field, set Indexed to Yes (No Duplicates).

 

[Paulfakins]

Thanks,

I created a composite index using employee ID, Appt Date, & Appt Time fields and set for no duplicates. This prevents creating multiple appointments for the same employee at the same time.

You are right that this is not the prettiest method, as the error message generated is faitly generic.

How might I go about either changing the error message or possibly checking for duplicates with VBA and generating my own message?

 

[SydneyGeek]

This might involve you in a bit of work, but there is a way to design the database so that only available slots show up when you make a booking. It's a link that someone provided in an earlier post -- got some good stuff!
http://www.advanced-ict.info/?databases/clash.html

Denis

 

[Paulfakins]

Thanks Denis!

Great link. I looked at it briefly and it seems to be exactly what I am looking for. I don't mind the work involved if the finished product works as I want it to.

Paul