Community discussion forum

Access, Calender dates, Strings and SQL

• • Reply

  1 year ago

  by pdunn

  pdunn

  , United States

  Joined 6 years ago

  I am using Access to write a form that will utilize a calendar control to get a date and past that in a sql string that will get the corresponding's date information.

  This is not working for me.  There are no rows returned.  When using

  strSQL = "Select * from Table Where sDate = ""09/23/2008"""

  I get the necessary information

  However, when using

  Dim dtDate as Date 

  dtDate = Me.Calendar0.Value

  strSQL = "Select * from Table Where sDate = ""

  strSQL = strSQL & CStr(dtDate) & """

  I get no rows returned.  Even when I take out the CStr(), the same no rows is returned.

  I have written an If...Then statement to test and dtDate = "09/23/2008" is not true nor with CStr().

   Any help with getting the value of a calendar control into a SQL string inwhich the database will recognize is great.  Even if a parameterized query would be good; I would need to be instructed with the course of action to pass the value in since I was unsuccessful before. 

  Thank you,

  P Dunn

   

  Report abuse
• • Reply

  1 year ago

  by Uncle

  Uncle

  England, United Kingdom

  Joined 7 years ago

   Access usually likes dates to be surrounded by hash symbols in coded queries. You also seemed to have a few extra quote marks. Try something like this:

  strSQL = "Select * from Table Where sDate = "

  strSQL = strSQL & "#" & dtDate & "#;"

  Hope this helps!

  Report abuse