Connecting Tech Pros Worldwide Forums | Help | Site Map

How can error messages be displayed when using Command Buttons - Access 97 ?

bjbounce2002@hotmail.com
Guest
 
Posts: n/a
#1: Nov 13 '05
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!)


Larry Linson
Guest
 
Posts: n/a
#2: Nov 13 '05

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]


Closed Thread