We recently updated our
Terms and Conditions for TechRepublic Premium.
By clicking continue, you agree to these updated terms.
Welcome back!
Invalid email/username and password combination supplied.
Reset password
An email has been sent to you with instructions on how to reset your password.
Welcome to TechRepublic!
Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
Sorry, I am not sure what you are asking for, or rather I do not know how you are doing the deletion and with what program?
What do you mean by error handling? System, DAO/ADO, or do you want to raise your own error and if so, then under what cercumstances?
Is this a bulk deletion? (DELETE * From Table). If so, then make sure you use the option: dbFailOnError.
Or are you are trying to say: When I delete records in a loop and there are no records to delete then an error occurs on the Delete command? If so, then always do a check on the BOF and EOF first to see if there are any(more) records to delete and after a delete move off the deleted record with MoveNext.
Other than that, just set an On Error Goto … statement at the begining of the proceedure.