Help on No time and date duplicates

[Dirk2512]

hi sorry if im in the wrong area and sorry for my spelling first time in forums.

i have a simple database for callouts at work but i keep getting double booked, can you help me with a code where the data checks the date and time and if booking already exists it will come up with an error
eg 12/01/07 at 11:00, but if record already exists "error (next avalibly time is shown), about 1 hour between times thanks

 

[pbaldy]

It would help to know your table structure. Plus, when you say "about 1 hour", you'll find that's vague enough to make it hard to program a solution. A couple of thoughts. Making the date/time field(s) a key field would prevent duplicates from being entered. Another way would be to check the table for a match of date and time before allowing a new record. If the "about 1 hour" is volatile, then you might want to have a start and end time, so you can compare against both. Searching here for "prevent duplicates" should turn up threads with similar needs.

 

[Dirk2512]

ill attach my base and can you have a look
thanks

 

[pbaldy]

Presuming you just want to avoid a match of both date and time, you can use either of the methods I described. Did you search here for samples? Here's one:

http://www.access-programmers.co.uk/forums/showthread.php?t=120166

In fact a search on "prevent duplicate date time" will probably get even more specific results.

 

[Dirk2512]

Thanks For All your help it was a great help