The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Dates limited to post 1900

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Dates limited to post 1900

Resolved · High Priority · Version 2003

ReplyMon 1 Feb 2010, 15:49Delegate Victoria said...

Dates limited to post 1900

I am intending on using Access to create a simple archive database and have records dating back to the 1890s. How will I enter this information onto a table when Access will only allow dates after 1900?

Thanks

For upcoming training course dates see: Pricing & availability

ReplyWed 3 Feb 2010, 10:15Trainer Andrew said...

RE: Dates limited to post 1900

Hi Victoria

Thank you for your question.

In principle Access should be happy sorting dates earlier than 1900 in a table that contains a date field. I tried a quick test and it seems to work but it may I haven't fully understood how your database will be set up.

To test I created a table and in design view I created a date field. Then in Datasheet view I was able to enter records with dates earlier than 1900 then sort records in date and reverse order.

Problems can arise if date information is imported from Excel 2003. Excel will convert dates earlier than 1900 into text values rather than date values. They appear correct but when imported to Access for example they may generate errors. Could this be the situation you are encountering?

Tell me more about what you are hoping to achieve with your database and the problems you are encountering and I will try and help further.

Kind regards,
Andrew

Access articles

· MS Access: Access your Personal Information with Ease
· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· Microsoft Access Tighten your Security Controls
· Innovation with Microsoft Access
· How To Use The Analyze Table Tool In Access

Please browse our web site to find out more about
training database microsoft access and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

How do I set a critical path?

Can it be confirmed that this is for identifying potential weakness in my project timings?

» Forum post: Critical Paths

Explore The Rich New Chart Features In Office 2007/2010

Whether you've used earlier Office versions or you're new to Office 2007/2010 you may have worked with charts in your applications. The Office 2007/2010 applications suites now share a common and much more powerful charting capability. This article describes how to choose a new chart in Office 2007/2010 and summarises the editing features.

» Article: Best training

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions