[AccessD] Access 2010 cannot get at the form I opened.

William Benson vbacreations at gmail.com
Thu Mar 22 00:10:00 CDT 2012


I thought acdialog was "modal"

I live in an excel world. SHOWMODAL is it.

So when I am used to acdialog versus acnormal I assumed acdialog meant
modal.

A thousand.. no a million pardons begged, Stuart!
On Mar 22, 2012 12:15 AM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

> <quote>
> acDialog The form's Modal and PopUp properties are set to Yes.
> </quote>
>
> So the correct answer to my previous question:
> Is the the  Popup property of the front form  set to Yes?
>
> Was "Yes"  :-)
>
> --
> Stuart
>
> On 22 Mar 2012 at 4:09, Benson, William (GE Global Re wrote:
>
> > I cannot believe I missed this (and forgot to check it) ... I was
> opening the first form using acDialog. Doh!
> >
> > Justifies its not allowing me to see anything behind it.
> >
> > EXCEPT THAT IT SOMETIMES WOULD ... (which kinda threw me off the scent).
> >
> > So now I have to apologize  for wasting anyone's time.
> > Bill
> >
> > -----Original Message-----
> > From: Benson, William (GE Global Research, consultant)
> > Sent: Thursday, March 22, 2012 12:00 AM
> > To: 'Access Developers discussion and problem solving'
> > Subject: RE: Access 2010 cannot get at the form I opened.
> >
> > Could it be because I declared the calling form as a form level variable
> within the code module of the called form and then try to reference one of
> its controls?
> >
> > Option Compare Database
> > Option Explicit
> > Dim frmEnterSolarEquipment As Form
> >
> > Private Sub Form_Load()
> > txtSerialNumber =
> Nz(frmEnterSolarEquipment).Controls("EQUIP_SERIAL_NUMBER"), "") End Sub
> >
> > Private Sub Form_Open(Cancel As Integer) Set frmEnterSolarEquipment =
> Forms("Enter Solar Equipment") End Sub
> >
> > -----Original Message-----
> > From: Benson, William (GE Global Research, consultant)
> > Sent: Wednesday, March 21, 2012 11:55 PM
> > To: 'Access Developers discussion and problem solving'
> > Subject: RE: Access 2010 cannot get at the form I opened.
> >
> > More symptoms... the form is open in the background of the form which
> called it (as I said) but I cannot type anything in the VBA window, I
> cannot click on its title bar, I cannot even click on the calling form
> which "looks" like it is active -- the title bar is highlit. So it is
> almost like Access/VBA is in some kind of suspense.
> >
> > Suggestions for debugging?
> >
> > --
> > 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