stevewatson
New member
- Joined
- Aug 5, 2009
- Messages
- 3
- Programming Experience
- Beginner
Hi,
This should be quite an easy one for someone!!
I have an Access database, which I access via a Data Source. I then display some of the values from this database in Labels on a Form.
I the have a button which reads values from an Excel spreadsheet, and places THESE values into the Labels, replacing the values called from the database.
That all works fine.
However, I then click to Save the data by using the Save item in my Binding Navigator, and I receive an error:
Query is too complex
When I expand the error, it tells me:
In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
I have no idea what the problem is here. Maybe if I could see the actual query that it says is "too complex", I'd be better off?
Any ideas?
*** EXTRA INFO ***
Just to test, I created a basic form that did nothing more than display one of my DB fields in a text box. If I then make a change to the text, and click the Save button, I get the same error. So it must be something incredibly basic!!
This should be quite an easy one for someone!!
I have an Access database, which I access via a Data Source. I then display some of the values from this database in Labels on a Form.
I the have a button which reads values from an Excel spreadsheet, and places THESE values into the Labels, replacing the values called from the database.
That all works fine.
However, I then click to Save the data by using the Save item in my Binding Navigator, and I receive an error:
Query is too complex
When I expand the error, it tells me:
In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
I have no idea what the problem is here. Maybe if I could see the actual query that it says is "too complex", I'd be better off?
Any ideas?
*** EXTRA INFO ***
Just to test, I created a basic form that did nothing more than display one of my DB fields in a text box. If I then make a change to the text, and click the Save button, I get the same error. So it must be something incredibly basic!!