Computing.Net > Forums > Office Software > Date/time data type when creating t

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Date/time data type when creating t

Reply to Message Icon

Name: tcdmail
Date: July 2, 2003 at 14:06:54 Pacific
OS: Windows 2000 professional
CPU/Ram: 800/320
Comment:

Hi everyone,

I've a problem regarding the Date/Time field in Access 2002 (XP). When I want to create a table i don't get the data type "Date/Time" in the list box of the data types. However "Date" and "Time" are seperately shown in the list. When I select one of those and leave the list box the data type property is blanked out. When I type the data type "Date/Time" in by myself I receive the error that the entered data isn't an item from the listbox.

The strange thing is, if i create a table via the table creation wizard the type "Date/Time" is accepted when I selected for e.g. birthday as sample field.

So i think everything has to do with the values in the listbox of the data types, when the value "Date/Time" would be in it all the problem would be resolved.

I re-installed Office XP twice and removed all entries from the "Office" from the registry and delete also the c:\program files\Micrsoft Office folder.

The pc runs on a W2k proffesional OS with SP4 installed.

I've also discoverd that the problem is user dependend. When I logon with my domain account i got the error. When I log on with my local user account the error doesn't appear anymore.

Hope somebody can help me...

Tnx in advance for all the support !



Sponsored Link
Ads by Google

Response Number 1
Name: adjhughes5225
Date: July 3, 2003 at 05:57:44 Pacific
Reply:

The only thing I can think of is that whilst logged in under your domain account you do not have sufficient rights or your profile is corrupt. Try recreating the domain user profile as I doubt it is rights in this case. Your profile stores various microsoft personal setup information so I would backup you profile so you can restore it if it does not work.

Hope this helps.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Date/time data type when creating t

HELP! IF statements to compare Date/Time www.computing.net/answers/office/help-if-statements-to-compare-datetime/9702.html

MS Word 2002 highlights everything! www.computing.net/answers/office/ms-word-2002-highlights-everything/2467.html

Time/Date Stamp www.computing.net/answers/office/timedate-stamp/4740.html