Access 2003 DateTime Error

R

Raj Parmar

I am receiving an error everytime I try to create a datetime column in a
table in MS Access 2003.

I am fully patched but still receive the error. I have tested this on 3
different installations (/machines) with the same results.

Please could someone help?

1. Open or create a database with at least one table.

2. Create a new column with any name and type "DateTime".

3. Click on "Format" at the bottom to choose a particular format.

This is when Access with freeze and generate an Error report to send to
Microsoft.

Kind Regards

Raj.
 
D

Douglas J. Steele

Assuming that by step 2, you mean select Date/Time as the data type, I get
no error doing this.
 
R

Raj Parmar

I apologise, I didn't mean just clicking in the format box but actually
attempting to pull the menu down.
Does this not cause an error? I can't seem to find a fix for it anywhere and
I have reinstalled Office 3 times now, very frustrating as its hindering my
work.

Regards..

Raj.
 
R

Raj Parmar

I've found the solution, the problem stemmed to the fact that my Long Date
Format in Windows Regional Settings was set to "dddddddd dd mmmm yyyy". This
was to create a full date format as "Saturday 25 September 2004".
When this was set back to one of the predefined settings, the problem was
solved.

Regards.

Raj
 
D

Douglas J. Steele

The format code for full day name such as Saturday is simply dddd (and ddd
will give you a short day name, like Sat, Sun)
 
Top