| re: How can error messages be displayed when using Command Buttons - Access 97 ?
Error messages aren't suppressed just by using VBA code initiated by Command
Buttons. You need to discover WHY they do not display. Look through all the
VBA code involve for "DoCmd.SetWarnings False", and for "On Error Resume
Next", both of which can suppress error messages.
Larry Linson
Microsoft Access MVP
<bjbounce2002@hotmail.com> wrote in message
news:1107002684.786889.113440@f14g2000cwb.googlegr oups.com...[color=blue]
> Hello,
>
>
> I am using forms with command buttons to close form or run action
> queries. The error messages such as "Null value in required field" or
> "duplicate value in primary key" are suppressed. The error messages
> appear when runnign the apend query manually or when closing the form
> using X, but not when using command buttons.
>
> Does anyone know how can the messages be displayed when using command
> buttons?
>
> Your help would greatly be appreciated.
> Kind Regards
> Mark
> Qld Australia.
>
> (using Access 97 too!)
>[/color] |