Out of Range Error

  • Thread starter Thread starter Brenda from Michigan
  • Start date Start date
B

Brenda from Michigan

Access 2002 SP3

User has exported a table to Excel but she gets an Out of Range error giving
the row number. The field is a date and it is setup as a Short Date in
Design View. The data is 3/25/2008. It is the same as all the other dates
in that field and the user wants to know why it errors on this specific date.
Any ideas?
 
Even though it's formatted as Short Date, it could have a time element stored.

Try exporting a query based on the table. Use the Format function to display
it as a Short Date. That will export it as text instead of a date or number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset Findfirst Date Issue 0
How to import Excel to Access using VBA 2
Date Field 7
re-order records in a table 4
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Data Mistype error 10
Find records where value is out of a range 3
Automate Change of the format of a field to short date for export 2

Back
Top