Select string help? ...

[savok]

I am trying to select all the records from the access db where startdate is greater than the one in the txt box but for some reason it gives me all the dates? heres the code...


DBComm.ActiveConnection = DBConn
DBComm.CommandText = "Select * from Schedule where ScheduleID = " & strID & " and StartDate > " & txtStartDate & " "
DBComm.CommandType = adCmdText


thanks...

 

[BobWman]

You need single quotes around string and date variables used in a query.

 

[savok]

are you sure? i changed it to single quotes and got "Data type mismatch in criteria expression" error.


thanks...

 

[BobWman]

Assuming the ScheduleID and StartDate fields are either text or date fields, this should work:

DBComm.ActiveConnection = DBConn
DBComm.CommandText = "Select * from Schedule where ScheduleID = '" & strID & "' and StartDate > '" & txtStartDate & "'"
DBComm.CommandType = adCmdText

 

[savok]

ScheduleID is Autonumber and StartDate is Date/Time

I copied and pasted your code into vb and still get the Data type mismatch error.

the sample code i posted above works fine, only it selects all records instead of those where StartDate > " & txtStartDate & "

thank you...

 

[savok]

someone else answered it on another board, thanks for your help!

heres the code...


"Select * from Schedule where ScheduleID = " & strID & " and StartDate > #" & txtStartDate & "# "