B
Billy Vick
I have some Update Queries that I need to run in MS
Access 2002 but the updates constantly bomb due
to "Duplicate Key Was Found" error message. I have
someone that can run the queries for me in Access 97.
They get the same error but under the Advanced Tab on the
Tools / Options menu, they can set the Error Trapping
section to 'Break in Class Module" and Access doesn't
stop when the error occurs. In MS Access 2002, that
option is not available for me to check, unless I go into
the Code Section of a form (which I don't need / want).
When I do go into the Code Section of a form, I get the
Error Trapping settings under the Tools / Options /
General menu there.
I need to have the same setting in MS Access 2002 that
they have in Access 97. I must be able to adjust this
error handling situation in the query section of MS
Access.
Please, please, please help.
-Billy Vick (nc.rr.com)
Access 2002 but the updates constantly bomb due
to "Duplicate Key Was Found" error message. I have
someone that can run the queries for me in Access 97.
They get the same error but under the Advanced Tab on the
Tools / Options menu, they can set the Error Trapping
section to 'Break in Class Module" and Access doesn't
stop when the error occurs. In MS Access 2002, that
option is not available for me to check, unless I go into
the Code Section of a form (which I don't need / want).
When I do go into the Code Section of a form, I get the
Error Trapping settings under the Tools / Options /
General menu there.
I need to have the same setting in MS Access 2002 that
they have in Access 97. I must be able to adjust this
error handling situation in the query section of MS
Access.
Please, please, please help.
-Billy Vick (nc.rr.com)