[AccessD] code help please

Andy Lacey andy at minstersystems.co.uk
Wed Dec 1 06:42:40 CST 2004


Better safe than sorry Erwin, I know, but if you're thinking of the problem
of Access not shutting down correctly then according to MS this was a very
specific problem:

"You have code behind a subform control that references a Boolean control
such as a check box on the main form, and are using an If..Then statement to
implicitly test for a value of True, as shown in the following example:

If Me.Parent![CheckBox] Then"

See http://support.microsoft.com/default.aspx?scid=kb;en-us;190074


--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: RE: [AccessD] code help please
Date: 01/12/04 11:14

>
> I would prefer
>
>  if isnull(me.txtPONptes) = true then
>
> I know there use to be a bug in one of the access versions with this
"if
> x then" without the "= y" part.
> They where wrongly interpreted due to this missing operator.
> Some Access books advice to write the full comparison for better
> readability and bla bla bla...
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
> Sent: Wednesday, December 01, 2004 9:16 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] code help please
>
> Joe
>
> if isnull(me.txtPONptes) then
>
>
> IsNull is a function.
>
> -- Andy Lacey
> http://www.minstersystems.co.uk
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
> > Sent: 01 December 2004 07:47
> > To: 'Access Developers discussion and problem solving'; 'ACCESS-L'
> > Subject: [AccessD] code help please
> >
> >
> > It is almost Midnight here
> > What is wrong with the following code please?
> >
> > Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As
> > Integer)
> >     if isnull me.txtPONptes then   < This is null line is the
> > trouble maker
> >         Me.lblPONotes.Visible = False
> >         Me.txtPONptes.Visible = False
> >     End If
> >
> > End Sub
> >
> > JOE HECHT
> > LOS ANGELES CA
> >  jmhla at earthlink.net
> >
> >
> >
> > --
> > _______________________________________________
> > 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
>
>
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list