Anyone know what could be wrong with.....

[elziko]

....this SQL statement?

SELECT * FROM tblMainRepos WHERE DateAdded = " & CDate(tvTreeView.SelectedItem.Text)

Where DataAdded is a short date format field in an Access database and tvTreeView.SelectedItem.Text is a short date string?

It doesn't give an error, it just doesn't return any records when I know it should!

Many thanks,

elziko

 

[sunaj]

Hi,

Try an surround your date with '#':

----------------------------------------------------------
SELECT * FROM tblMainRepos WHERE DateAdded = #" & CDate(tvTreeView.SelectedItem.Text) & "#"
----------------------------------------------------------

Sunaj

 

[Hackster]

Where do you have your code? If you have it in the TreeView click event, I would suggest moving it to the TreeView NodeClick event.

 

[daimaou]

Access needs the date between # so try:

SELECT * FROM tblMainRepos WHERE DateAdded = #" & CDate(tvTreeView.SelectedItem.Text) & "#"

Hope this helps

 

[daimaou]

wow I guess we all posted at same time!
X-)

 

[harmmeijer]

Is your windows settings set to the US date style??
I had the problem because the Duthc datestyle is dd-mm-yyyy in an SQL statement this gives different records than expected (mostly no records) instead of an error.
you could try this as a sql statement:
SELECT * FROM tblMainRepos WHERE DateAdded = #" & Format(CDate(tvTreeView.SelectedItem.Text), "mm/dd/yyyy&quot & "#"

note that the date is inclosed in ## this might allso be the cause of your problems (now the ## are missing).

 

[harmmeijer]

Woow,, it`s busy today

 

[elziko]

# did it nicely.

Thanks a lot,

elziko