Error message (2000)

Topic

New Reply

I appear to be getting an error in Access.

See attachment.
Any ideas as to what it means?

Justin.

Reply | Quote

Replies

What do you mean by “I appear to be getting an error” – do you get an error or not?

It means Update or CancelUpdate without AddNew or Edit

As so often, just posting a screenshot doesn’t tell us where and when this occurs.

Reply | Quote

This appears to be fine now for some odd reason.
My apologise Hans l will be more specific in future.

Justin.

Reply | Quote

This appears to be fine now for some odd reason.
My apologise Hans l will be more specific in future.

Justin.

Reply | Quote

What do you mean by “I appear to be getting an error” – do you get an error or not?

It means Update or CancelUpdate without AddNew or Edit

As so often, just posting a screenshot doesn’t tell us where and when this occurs.

Reply | Quote

This is an error you only see when your code is misbehaving, when you have attempted to modify a recordset and either the .AddNew or .Edit instruction is missing or your code is structured in such a way that the code can no longer find it. Without seeing the code involved, it is impossible to suggest a resolution.

Reply | Quote

Thanks for your help.

For some odd reason it appears to be ok now.

Reply | Quote

It would be better to first make an attempt to figure out where and why you received an error message before you post a question here. If you include the information, we can help you figure out how to fix it, and then the solution will be here in the boards and available to others in the same situation. Just posting an “I got one” and then “it’s gone now” helps no one. Did you fix a problem? If so tell us how. That might be useful to someone else.

Reply | Quote

I will bear this information in mind when l get an additional problem and post it the message board.
Sorry for any causing any inconvience.

Justin.

Reply | Quote

I will bear this information in mind when l get an additional problem and post it the message board.
Sorry for any causing any inconvience.

Justin.

Reply | Quote

It would be better to first make an attempt to figure out where and why you received an error message before you post a question here. If you include the information, we can help you figure out how to fix it, and then the solution will be here in the boards and available to others in the same situation. Just posting an “I got one” and then “it’s gone now” helps no one. Did you fix a problem? If so tell us how. That might be useful to someone else.

Reply | Quote

Thanks for your help.

For some odd reason it appears to be ok now.

Reply | Quote

This is an error you only see when your code is misbehaving, when you have attempted to modify a recordset and either the .AddNew or .Edit instruction is missing or your code is structured in such a way that the code can no longer find it. Without seeing the code involved, it is impossible to suggest a resolution.

Reply | Quote