Check date and time when entered

[Slimjimmpc]

Access 2000

So i have an events form. Which stores Date, StartTime and EndTime

What i want is when a user adds a new event that it doesn't clash with any events already in it based off those 3 values.

So if there is an event on 16 March at 1pm till 3pm then you can't add another event on the same time of that day.

What would be the best way of doing this?

 

[pbaldy]

See if this gets you started:

http://www.baldyweb.com/OverLap.htm

 

[Slimjimmpc]

So i have now been told it doesn't need to block the events but rather have a warning box saying an event has been booked on the same date.

Its just how to check the date has been taken by other records then display either a label or message box.

 

[pbaldy]

The link I gave you is a way to check for conflicts. You can do anything you want with the info. Create a query that checks info on your form against the data in the table. Use a DCount() or recordset to see if that query returns any records, and notify the user with a message box.