Schedule Conflict Coding

[mann2x]

I need help on a database i am creating. I need to write a vb program which detects if the current inputs already exists or if it is in conflict with existing records.

My method is I create a query from the current inputs

qrySQL= Select From [tblRegis].Subject
Where [tblRegis].TimeIn = '" & txtTimeIn & "'
And [tblRegis].Days = '" & cboDays & "'
And [tblRegis].Room = '" & cboRoom & "'
qd.SQL = qrySQL

(lets assume that the query is created)



after that i place the field value of subject into strSubject using DlookUp on the query
If it is null it means that there are no similar fields in the tblRegis and there is no conflict..
am i missing anything?because as of now i am not receiving proper outputs..

If you guys have a solution for this as simple as possible please help me..

[pbaldy]

For starters, you don't have any fields in the SELECT clause, so I don't think there would be anything for a DLookup() to retrieve. When I test, I get an error trying to run a query like that.

[mann2x]

For starters, you don't have any fields in the SELECT clause, so I don't think there would be anything for a DLookup() to retrieve. When I test, I get an error trying to run a query like that.

oh yeah i forgot to tell you bout that..any suggestions?

[pbaldy]

Uh, add the necessary fields:

SELECT Field1, Field2 FROM...

[mann2x]

Uh, add the necessary fields:

SELECT Field1, Field2 FROM...

yeah i already got that,lets assume that it is working and my syntax is correct..am i on the right path on checking whether a record will be in conflict or what?have you encountered this before?can you help me out?i can send you my database..plz help me out,i am due in two days..

[pbaldy]

If those 3 fields would uniquely identify a conflicting record then sure, you're on the right track. I'd point out that you're treating all 3 fields as text. I'd expect the time field to be Date/Time (and thus need to be surrounded by # instead of '). If either of the others is numeric you don't want the single quotes surrounding the value. You can post the db here if you want.