By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,863 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

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

P: n/a
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!)

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

<bj**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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!)

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.