From: Allen Browne on 29 May 2010 20:43
Regional settings for dates?
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Dennis McDermott" <dennis.mcdermott(a)gmail.com> wrote in message
> Thanks again Allen,
> I used your code and this is the result
> VISTA HOME PREMUIM JET VERSION 4.0.9511.0 (filter works as expected
> XP PRO JET VERSION JET VERSION 4.0.9511.0 (filter does not work as
> expected here, same Jet Version as PC above, so it looks like its
> something else that is causing the difference)
> WINDOWS 7 JET VERSION 4.0.9756.0 (filter works as expected here)
From: Dennis McDermott on 31 May 2010 04:40
On 30 May, 02:43, "Allen Browne" <AllenBro...(a)SeeSig.invalid> wrote:
> Regional settings for dates?
Hello Allen, I had said a couple of posts ago that I had checked the
regional settings for dates, however I have just gone and checked them
again, and yes there was a difference (must have had a drink last time
I checked !!), on my main PC that worked as expected the short date
format was dd/MM/yyyy whereas on the other PC where it did not work
the short date format was dd/MM/yy I changed this to dd/MM/yyyy and it
then worked, I then changed it back to confirm that this was the
problem, and strangly I do not now get the error message I was getting
"The expression you entered contain invalid syntax"
You may have entered a comma without a preceeding value or
But it just returns no records, which is to be expected.
Thank you very much for sharing your knowledge, it's much appreciated.