Hi
Can anyone help me? I'm trying to create a time allocation for diary. Basically what im trying to do is a viewings diary for my project. If a customer books a certain time and date i want to create a query so that it checks for duplicates. Help, please.
Thanx

Need more information. What is the table structure? How are you running this code? Generally you run a query against the data with parameters for the time and date in this case.

Generally you create a form with date and time selectors (your choice) and then open the query results after passing the criteria, either through the query criteria statements, or by passing a WHERE clause to the query in the DoCmd.OpenForm or OpenReport methods.

HTH

mmcdonal

Hi, thanks first of all for replying. I am fairly new with all this. Basically what I am trying to achieve is a form that a user enters the date via a calendar, typing in the time, and selecting Client, Property and Staff IDs from a dropdown menu. What i was trying to validate is if the user enters 03/02/2007 5.00pm for StaffID#3 which is a dupilicate, then a message should appear and tell the user to enter another date or time. I have copied the data from my table to make it easier to explain! I haven't designed my form properly so i am open to changes on the interface.

Date Of Appoint Time ClientID PropertyID StaffID
03/02/2007 10:32 PM 3 2 3
03/02/2007 01:00 PM 5 2 5
12/01/2007 02:30 PM 4 1 3
07/01/2007 03:00 PM 1 6 4
10/01/2007 10:30 AM 5 6 3
12/01/2007 11:30 AM 2 4 3
31/01/2007 10:30 AM 3 5 3
31/01/2007 04:30 PM 5 2 5
03/02/2007 05:00 PM 1 1 3
03/02/2007 05:00 PM 2 2 3