ACCESS FEED: Re: [MS_AccessPros] On Error Property

Selasa, 29 November 2011

Re: [MS_AccessPros] On Error Property

I found it. When you right-click a control, there opitons for Properties and for Form Properties. I needed the Form Properties.

Thanks

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>