I have this line of code that is part of a search function. It searches dates in the database
Set rst = Db.OpenRecordset("SELECT * FROM tblESTIMATE WHERE tblEstimate.DATE='#" & txtDate & "'#")
whene the ode is run i get a syntax error telling me that i have a syntax errror in the query expression. Does any body have any idea why? Am i right in assuming the # let VB know that it is seaching for a date?
Set rst = Db.OpenRecordset("SELECT * FROM tblESTIMATE WHERE tblEstimate.DATE='#" & txtDate & "'#")
whene the ode is run i get a syntax error telling me that i have a syntax errror in the query expression. Does any body have any idea why? Am i right in assuming the # let VB know that it is seaching for a date?