allert when duplicated data is posted 1

[kennetha]

Hi,
I'm building a database for a friend of mine who owns a tool hiring shop.

I've create tables and forms (all unbounded objects) which update by DAO.I've stuck with a problem and cannot figure it out.
Table fields are as follows:
clientid; tooolId; datePeriodFrom; PeriodTo

How can I allert the user when he tries to book a tool when it's already booked.
example;
this data is already stored in table field
client1 tool001 1-1-08 to 31-1-08.
new data to be posted
client2 tool001 23-1-08 to 10-2-08 should result in a warning

Thanks in anticipation
Kenneth Agius

 

[straybullet]

If the desired date range is entered first, a combobox could be used to limit tool selection to those which are actually available.

Let them hate - so long as they fear... Lucius Accius

 

[kennetha]

Straybullet,

Cannot do a combo since tool is selected first. ie before posting date periods. Some Vba suggestions appriciated

Thanks

 

[Remou]

One of these may suit:

strSQL="Select ID,Etc From tblBooked Where ToolID=" _
& Me.txtToolID & " And #" _
& Format(Me.txtHireStartDate,"yyyy/mm/dd") _
& "# Between HireStartDate And HireEndDate" 
Set rs=CurrentDB.OpenRecordset (strSQL)

Or DlookUp

InUse=DlookUp("ToolID","tblBooked","ToolID=" _
& Me.txtToolID & " And #" _
& Format(Me.txtHireStartDate,"yyyy/mm/dd") _
& "# Between HireStartDate And HireEndDate")

 

[kennetha]

Thank you ..been of great help