[AccessD] amending code for variable form name - Syntax help

Paul Hartland paul.hartland at googlemail.com
Wed Jul 16 01:21:19 CDT 2008


I saw the thank you Kath....Also while I am here thank you to Stuart, that
way may work much better for me as well.

Paul Hartland

2008/7/16 Kath Pelletti <kp at sdsonline.net>:

> That's weird - posted a thank you to you and Paul last night - but I don't
> think it came thru.
>
> Anyway - thanks. Spot on.
>
> Kath
>
> ----- Original Message -----
> From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, July 15, 2008 4:33 PM
> Subject: Re: [AccessD] amending code for variable form name - Syntax help
>
>
> > Just use frmCallingForm.Visible =True
> >
> > Since you have dimmed the variable as a Form, you don't need the
> > Forms!....Form bit.
> >
> >
> >
> > On 15 Jul 2008 at 14:57, Kath Pelletti wrote:
> >
> >> Need some syntax help.
> >>
> >> I need to set a form's visible property to true. It works if I explicity
> >> use the form name, eg.
> >>
> >> Forms!frmPersonDetails.Form.Visible = True
> >>
> >> But where I use a variable eg:
> >>
> >>     Forms!frmCallingForm.Form.Visible = True
> >>
> >> it doesn;t. How do I amend the code to include the variable
> >> frmcallingform? The code which creates and sets the variable form name
> is
> >> shown below:
> >>
> >> Dim frmCallingForm  As Form
> >> Set frmCallingForm = Forms("frmPersonDetails")
> >>
> >>
> >> ______________________________________
> >> Kath Pelletti
> >> Software Design and Solutions Pty Ltd
> >> Ph: 9505-6714
> >> Fax: 9505-6430
> >> kp at sdsonline.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
>



-- 
Paul Hartland
paul.hartland at googlemail.com



More information about the AccessD mailing list