where I do wrong?

[diaExcel]

I use VB6 and Access, and i have this code:

DTPicker.Value=Data
Dim sirSQL as string

sirSQL="Select * From personal WHERE (data_now=" & DTPicker.Value & ")"

The problem is...when I tried to run it in VB I received nothing, but when I
run it in Access everything is OK.

So, my question is where I do wrong? and What i have to do and how?


Thank you.

 

[Alex Dybenko]

Hi,
make sure that you format date in proper format:

sirSQL="Select * From personal WHERE (data_now=#" &
format(DTPicker.Value,"mm\/dd\/yyyy") & "#)"

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com