Access Reports From VB

[qwe1204]

I have an access database with a number of reports that I want to run from VB. I have no problem displaying four of them but the fifth takes at least two date parameters in the where clause. I have tried supplying the two dates in the forms

([DateOrdered] >= 13/10/01 And [DateOrdered] <= 16/10/01)

([DateOrdered] >= 13/10/01 And [DateOrdered]<= '#16/10/01#')

[DateOrdered]>= '13/10/01' And [DateOrdered] <= '16/10/01'

[DateOrdered]>= 13/10/01 And [DateOrdered] <= 16/10/01

[DateOrdered]>= #13/10/01# [DateOrdered] And <=#16/10/01#

[DateOrdered]Between #13/10/01# And #16/10/01#

but none of these seem to work.

Any help at this stage would be hugely appreciated.

 

[stnkyminky]

I had this problem before too. I couldn't find a solution and re created them in VB.