ACCESS FEED: RE: [MS_AccessPros] On Error Property

Selasa, 29 November 2011

RE: [MS_AccessPros] On Error Property

John-

There is an On Error property for a form, but not controls. That event triggers
when there's an error processing data on the form, and you can look at the
DataErr parameter to figure out what happened. Or perhaps you mean setting an
On Error trap in VBA code?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of yshopper
Sent: Tuesday, November 29, 2011 4:33 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] On Error Property

I am following the instructions here

http://rogersaccessblog.blogspot.com/2010/12/domain-function-example-simulate.ht
ml

but do not find the 'On Error' event property for the Text Box or Form. I do
find the 'Before Update' event. I also see many 'On' events; On Change, On Mouse
Down, On Enter, etc, but no "On Error" I'm using Access 2010.

Am I looking in the wrong place?

Thanks,
John

------------------------------------

Yahoo! Groups Links