ACCESS 2000 Validation Script

[D_C_W]

Help needed with validation script.

I have made a form and subform over a table named calendar. The table fields are:

CalendarID – AutoNumber
Date – Date/Time
Time – Date/Time
Contact – Text
Event Type – Text
Place – Text
Date Alert – Date/Time
Event Due Past Due – Yes/No

I want to prohibit a Date and Time conflict (i.e.) Event1 dated 05-18-09 at 08:00AM and (new record) Event2 dated 05-18-09 at 08:00AM. It is important for a validation script to stop the action and have a message box to exist in vba in the Before_Update sub.

Thanks – D_C_W

 

[jsv2002]

Seems like someone doing something http://www.access-programmers.co.uk/forums/showthread.php?t=171389&highlight=doctor like this.. try searching the forum might throw up more

 

[D_C_W]

Thanks
jsv2002

From your link I found a couple of examples of actual code or indexing. Printed them out - gotta get my head around them. Im one of those that needs to see the flow.

Thanks D_C_W