Error Trapping in Access 2002

Status
Not open for further replies.
C

c2N1YmExMzky

I want to trap for "error 3201 - you cannot add or change a record". This

occurs when a transaction is being added to a table that captures all

transactions for a part master table. The transaction table is linked to the

part master table as a 1 to many relationship with referential integrity.

What event or where should I put the code to trap this error to present other

options to the application user?
 
K

Ken Slovak - [MVP - Outlook]

Post this in an Access group, not an Outlook group.

"scuba1392" <scuba1392@stephengould.com> wrote in message

news:C2B2670D-6F83-4D0B-A240-6CF2B014E81D@microsoft.com...
> I want to trap for "error 3201 - you cannot add or change a record". This
> occurs when a transaction is being added to a table that captures all
> transactions for a part master table. The transaction table is linked to
> the
> part master table as a 1 to many relationship with referential integrity.
> What event or where should I put the code to trap this error to present
> other
> options to the application user?
 
C

c2N1YmExMzky

Thanks I'll move it to MS Office - access - programming.
wrote:


> Post this in an Access group, not an Outlook group.

> >

>

> "scuba1392" <scuba1392@stephengould.com> wrote in message
> news:C2B2670D-6F83-4D0B-A240-6CF2B014E81D@microsoft.com...
> >I want to trap for "error 3201 - you cannot add or change a record". This
> > occurs when a transaction is being added to a table that captures all
> > transactions for a part master table. The transaction table is linked to
> > the
> > part master table as a 1 to many relationship with referential integrity.
> > What event or where should I put the code to trap this error to present
> > other
> > options to the application user?


>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
A Run-time error '430' on certain emails when trying to set "Outlook.mailitem" as "ActiveExplorer.Selection.Item" Outlook VBA and Custom Forms 2
E Complite error on SaveAsFile method Outlook VBA and Custom Forms 3
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
M Compile error: User-defined type not defined Outlook VBA and Custom Forms 0
R Error when trying to forward current email item Outlook VBA and Custom Forms 7
M ERROR: None of your email accounts could send to this recipient Using Outlook 2
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
C Send/receive error 80040119 Using Outlook 2
W error with the permission for the file Outlook VBA and Custom Forms 0
L Outlook 2019 MAC sync error after working for 4 hours Using Outlook 1
A Run time error 424. object required in outlook 2013 Outlook VBA and Custom Forms 10
M error code 0x8DE00006 Using Outlook 1
M Desktop Version Of Outlook Generating Error Using Outlook 4
M Send/Receive error 0x800CCC0F Using Outlook 0
T Outlook 2016 CSV Translator Import Error Using Outlook 6
ManaarZakaria I'm afraid of this issue, cause of strange error Exchange Server Administration 2
P Suppress dialog box on email check error? Using Outlook 5
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S VBA Macro - Run-time error '424': object required - Help Please Outlook VBA and Custom Forms 3
avant-guvnor Outlook.Application now produces error Outlook VBA and Custom Forms 5
P Run Time Error 91 when linking contact to task in VBA Outlook VBA and Custom Forms 1
N Error 0x80090326 when trying to setup IMAP account on Outlook.com Using Outlook.com accounts in Outlook 1
N Saving And Deleting Outlook Attachments with Unknown Error Message Outlook VBA and Custom Forms 1
Dennis Gaudenzi Your setup couldn't be started because of an unexpected error (mapi 0x80040604) Using Outlook 14
M Outlook 2013 fails to start -- missing WindowsCodecs.dll error Using Outlook 3
Steshelter ICloud Unexpected Error Using Outlook 5
Rupert Dragwater "there was an error reading this theme" Using Outlook 3
A Error: The name cannot be matched to a name in the address list Using Outlook.com accounts in Outlook 0
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
J Outlook - 2013 - Error msg when copying folders from Online Archives to another user's mailbox Using Outlook 0
Vijay Error in rule- Run a script Using Outlook 1
B Automation error running VB macro code Outlook VBA and Custom Forms 8
J Object Variable or With Block Not Set Error in Outlook 2016 and not Outlook 2013 Outlook VBA and Custom Forms 3
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11
Diane Poremsky The Attachment Size Exceeds the Allowable Limit Error New Slipstick.com Articles 0
Diane Poremsky RMS Error: System clock has been tampered with New Slipstick.com Articles 0
Diane Poremsky Error Opening Outlook and Control Panel's Mail Applet New Slipstick.com Articles 0
K Error: Paper Size Invalid Using Outlook 0
M Error 0x 800CCC92 Using Outlook 0
Diane Poremsky Cannot start Microsoft Office Outlook Error Message New Slipstick.com Articles 0
S Autosave attachments error using Len Outlook VBA and Custom Forms 2
J Error 75 Outlook VBA and Custom Forms 4
C Copy email to excel runtime error 5020 Using Outlook 5
B "The properties of the message…have been changed" error Outlook VBA and Custom Forms 1
I Windows 10 - .msg files on disk show Explorer popup error Using Outlook 5
M Outlook 2010 Error: Your IMAP server closed the connection Using Outlook.com accounts in Outlook 1
T Client-side rules not working, but no error Using Outlook 1
Similar threads


















































Top