First of all, read this
article[
^] and
thread on ozgrid forum[
^] and all related articles.
To get data from table, use the following query:
SELECT *
FROM AllProjects
WHERE [StartDate]= #09/18/2012#
I recommend you to build a query and check its content in the run-time using
MsgBox
, for example:
strSQL1 = "SELECT * FROM AllProjects " & "WHERE [StartDate]=#" & Format(temp, "dd.mm.yyyy") & "#"
MsgBox strSQL1
What you see now?