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