Can't resolve error: You cannot record changes because...

[isaac12345]

Hi all,

I have an excel sheet linked into(not imported) my access project. I have a form with 5 combo boxes. These combo boxes list the fields for a particular column like year, week number, project numbers,etc and allow the user to either select a value listed in the excel sheet or enter their own value. The combo boxes are set up to display unique values only. Then I have a button that shows all the records from the sheet according to the parameters entered in the combo boxes. The button is powered by a query. I used the following format to enter the criteria for the respective field so that it takes the input from the respective drop down list - [Forms]![Form Name]![ComboBoxName]

Whenever I add the 'week no' field to this query, then select the value from the drop down list or enter it manually and run it, I get the 'you cannot record changes...' error. I checked what the field type is and its been assigned a 'double' so there shouldnt be a type mis-match. But I cant think of any other reasons why I am getting this error.

Any help would be much appreciated

 

[spikepl]

and the reason for ignoring/withholding the significant part of the error message is what?

 

[isaac12345]

HAHA! It was too long. Anyway here it is - "You cannot record your changes because a value you entered violates the settings defined for this table or list( for example, a value is less than the minimum or greater than the maximum). Correct the error and try again"

A strange thing happened just now. To reproduce the error I added the 'week no' field back to the query and ran it. It displayed the resulting table! But after a few seconds the error popped up and all values in all the coloumns changed to "#Name?". Any idea why?

 

[spikepl]

I see a lot of cyberspace arm waving here, i.e. only you know exactly what you have done. But

a). Did you follow up on the error message, and checked the contents of all fields of the new record? It does not say anything about type.

b). If you are trying to update/append data in a linked Excel sheet, then AFAIK you can only do that in an access version prior to 2003.

 

[isaac12345]

I am not creating a new record in the excel sheet as it cant be updated in access 2010. Or are you talking about the contents of the field in the resultant table from the query?