Getting Run-time error '2501' - The RunSQL action was canceled (1 Viewer)

pwalter83

Registered User.
Local time
Today, 02:36
Joined
Dec 19, 2011
Messages
31
Hi,

I am getting this error- 2501 when I try to press the 'Add Record' button when the form is incomplete. At that point I get this pop-up that says:

MS Access cvan't append all the records in the append query.
Do you want to run the action query anyway ?

When I press No, then I get the 2501 error.

Does anyone know how to handle or trap this error.

I want the functionality that when the incomplete form is being submitted to be entered in the table, then it should warn the user instead of showing this error. I have also attached the screenshots of the pop-up and the error 2501.

Thanks !

Paul
 

Attachments

  • Pop-up.zip
    217.9 KB · Views: 176
  • Error 2501.zip
    233.9 KB · Views: 190

pwalter83

Registered User.
Local time
Today, 02:36
Joined
Dec 19, 2011
Messages
31

Users who are viewing this thread

Top Bottom