2007 to 2003 code problem

[Eugenio]

Hello everyone. I've been working on a database in MSAccess2007 and had to convert it to 2003. I have a line of code which returns a requested date range from a query to a listbox:

Dim MySQL As String
MySQL = "SELECT * FROM qryContLife  WHERE 1=1"

If IsDate(Me![StartDate]) And IsDate(Me![EndDate]) Then
   If CDate(Me![StartDate]) < CDate(Me![EndDate]) Then
      mycriteria = mycriteria _
        & " AND [Depot In Date] Between #" _
        & Format(Me![StartDate], "yyyy/mm/dd") _
        & "# And #" _
        & Format(Me![EndDate], "yyyy/mm/dd") & "# "
   End If
End If

MyRecordSource = MySQL & mycriteria
Me![lstContList].RowSource = MyRecordSource

After converting, it stopped working. Returns nothing. Any idea how to solve this?

[janders468]

Could you post the full function ? I.e. the function signature as well.

[NeoPa]

I'm afraid the description "just stopped working" is not very helpful.

Can you not explain what happens differently from what is expected - and where?

[missinglinq]

You say it "returns nothing," does it throw any errors? And after converting to v2003, when you have trouble running it, are you running it under v2007 or under a copy of v2003?

Welcome to Bytes!

Linq ;0)>

[Eugenio]

sorry for not posting, was quite busy. Right, the problem is solved through chaning the date separator in the regional settings ;) format was dd.mm.yyyy , after changing it to dd/mm/yyyy, everythings fine.

[missinglinq]

So it wasn't really a 2007 to 2003 problem then?

Linq ;0)>