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

Stuart McLachlan stuart at lexacorp.com.pg
Wed Mar 21 23:13:59 CDT 2012


<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
> 




More information about the AccessD mailing list