Suppress Warning Messages (1 Viewer)

[anski]

I have a form. I want to suppress this message: Do you want to suppress further error messages telling you why records cannot be pasted?

I made my own message box and the latter successfully appears but after I click on OK the above message still appears.

 

[pbaldy]

See if SetWarnings works for you.

 

[isladogs]

You can also suppress the warning messages related to action queries by unticking the checkboxes in Access options.
However I would caution against suppressing the messages you quoted as, without them, you will not know whether or not an action has worked successfully. In what way is your message box better than the original?

 

[anski]

See if SetWarnings works for you.

It does not. Maybe I'm placing it in the wrong event. I have tried On Error, After Update.

 

[isladogs]

are you running an append query or a sql statement in code?
If so, try using

CurrentDB.execute "Your SQL statement here", dbFailOnError

 

[anski]

This is the form. The user can copy that transaction (in red) and paste that to the next new transaction. That is okay but I want him to write a description first (in blue) before they paste the transaction. I found a way to undo the paste function and show my own message. There is no append query or sql statement involved.

 

[pbaldy]

So they just highlight all the records and copy/paste? I doubt many of us do that. I'd probably have a button that copied via SQL, after entering a description.

 

[anski]

I do that specially when the entries are repetitive and you just change the amounts. I will assume that others will do that. I just want to anticipate possible problems.

 

[pbaldy]

I'm all for avoiding repetitive entry, I just don't think many developers use a method requiring the user to copy/paste like that. Maybe I'm wrong. I'm thinking more like:

Microsoft Access tips: Duplicate the record in form and subform

How to duplicate the current record on a form in a Microsoft Access database, along with the related records in the subform.

allenbrowne.com