Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Subscript Out of Range

Several reasons for this… Could be the Excel spreadsheet has too many columns, could be there is some corruption in the Excel spreadsheet, could be the way Access is translating your columns in Excel, could be there are calculated fields in Excel that Access can’t translate for whatever reason. Review the checklist below and see […]

 18,068 total views,  1 views today

September 28th, 2013 | Tags: , , , | Category: Error Messages | Comments are closed

DLookup causes “You cancelled the last operation” error message

The message indicates that the 3rd argument you are supplying is not correct. It may be misspelled, lacking square brackets around problem names, lacking delimiters, lacking a value (e.g. where you concatenate a Null), lacking an operator, or something else.

This article explains how to form the 3rd argument… Getting a value from a table: […]

 4,005 total views

September 20th, 2013 | Tags: , | Category: Error Messages | Comments are closed

#NAME?

Here are some reasons…

Make sure that the field specified in the control’s ControlSource property hasn’t been removed from the underlying table or record source. Check the spelling of the field name in the control’s ControlSource property. If you specified an expression in the control’s ControlSource property, make sure that there is an equal sign […]

 1,546 total views

September 11th, 2013 | Tags: , | Category: Error Messages | Comments are closed