[AccessD] how to have access ignore a form that is canceled

Bill Benson bensonforums at gmail.com
Mon Jul 27 20:38:16 CDT 2015


As I wrote before I get put into break mode with that error reported even
though I had on Error Resume next so I don't see what trapping error code
2501 will do for me. I will try again tomorrow
On Jul 27, 2015 8:09 PM, "Jim Dettman" <jimdettman at verizon.net> wrote:

>
>  Yes and maybe I didn't understand, but trapping 2501 is the norm...
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Heenan, Lambert
> Sent: Monday, July 27, 2015 05:37 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] how to have access ignore a form that is canceled
>
> Can't you just trap error 2501 - "OpenForm action was cancelled" ?
>
> Lambert
>
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Bill Benson
> Sent: Monday, July 27, 2015 5:08 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] how to have access ignore a form that is canceled
>
> Yes, that setting is there.
>
> The problem as I see it, is that Access doesn't like me to cancel a load of
> a form when there was a calling routine that opened it. My feeling is, so
> what? Thats the idea. There ought to be a way to trap for that and
> disregard
> I have forbidden the form to open by design!
>
> On Mon, Jul 27, 2015 at 4:24 PM, Jim Dettman <jimdettman at verizon.net>
> wrote:
>
> > Bill,
> >
> >   With the VBA editor window open, click on tools/options.  Click the
> > general tab.
> >
> >   Make sure your selected to break on unhandled errors.
> >
> > Jim.
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of Bill Benson
> > Sent: Monday, July 27, 2015 03:38 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] how to have access ignore a form that is canceled
> >
> > I am running this
> >
> > DoCmd.OpenForm "frmComments", acNormal, , , acFormEdit, , CStr(Me.ID)
> >
> > When the openargs is null, I cancel form load.
> >
> > How can I get Access to ignore that the form wont open instead of
> > throwing me into break mode?
> >
> >
> >
> > My error trapping is not working, and the problem arised before
> > Form_Error in the calling form so I cannot continue past it (which
> > makes sense since it is not a data error I guess).
> >
> > Private Sub cmdAddComment_Click()
> > On Error Resume Next
> > DoCmd.OpenForm "frmComments", acNormal, , , acFormEdit, , CStr(Me.ID)
> > If Err.Number <> 0 Then
> >     MsgBox "Could not open the comments form"
> > End If
> > End Sub
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list