Problem on vb on 12/8

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

On 12/8/03 one of the vb functions: Run Action query it didn't work and on
the other date it worked fine

Did someone stuck with this problem before?
 
No, but it's interesting it's 12/8/03. Does the query uses dates somewhere
that are not in ANSI format?
 
-----Original Message-----
No, but it's interesting it's 12/8/03. Does the query uses dates somewhere
that are not in ANSI format?
Click to expand...

Access takes whatever formats for date/time, currency,
hyphenation, etc. that the user specified in the Regional
Settings control panel. Same database will show dates
differently once you change your settings.

I'm doing a database for a client in Soweto, and I have to
keep changing my Regional settings so dates will show up
as dd/mm/yyyy, numbers show as 123456,00 and the form
design grid shows in mm instead of inches.

That brings up one gotcha we've found: if you've got the
date format set up as dd/mm/yyyy and you input August 12th
as 08/12/2003 anyway, Access accepts it as December 8th.
There's no way to be sure that the middle chunk is
actually the month unless you do separate fields for day,
month and year.
 
Back
Top