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

Stuart McLachlan stuart at lexacorp.com.pg
Wed Mar 21 23:01:46 CDT 2012


That looks as though it is stuck in a loop. Does Ctrl+Break do anything?


On 22 Mar 2012 at 3:54, Benson, William (GE Global Re wrote:

> 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?
> 
> -----Original Message-----
> From: Benson, William (GE Global Research, consultant) 
> Sent: Wednesday, March 21, 2012 11:53 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: Access 2010 cannot get at the form I opened.
> 
> And................. now it is not working again. Even though I did (I thought prudently) go back and put AcNormal on the command line. Which obviously (now I can tell) is not the solution. And it means something else sinister, reeeeeaaaaallllly sinister is going on.
> 
> -----Original Message-----
> From: Benson, William (GE Global Research, consultant) 
> Sent: Wednesday, March 21, 2012 11:39 PM
> To: Access Developers discussion and problem solving
> Subject: RE: Access 2010 cannot get at the form I opened.
> 
> OK, who is going to believe this...
> 
> I changed the code which opened the form from
> 
> 
> Private Sub cmdSelectEquipment_Click()
> DoCmd.OpenForm "Choose Equipment Form"
> End Sub
> 
> 
> 
> To
> 
> 
> Private Sub cmdSelectEquipment_Click()
> DoCmd.OpenForm "Choose Equipment Form", acNormal End Sub
> 
> And then it was no problem.
> 
> Furthermore I thereafter removed
> , acNormal
> 
> And it still worked.
> 
> 
> Does the DoCmd.OpenForm  command work like the Find method in Excel works, where certain parameters in the method are retained and inferred the next time the DoCmd.OpenForm is executed if insufficient arguments are used to over-ride what was used the previous time?
> 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William (GE Global Research, consultant)
> Sent: Wednesday, March 21, 2012 11:24 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access 2010 cannot get at the form I opened.
> 
> I open a form from a button click, and that form is opening behind the one with the button that I clicked. Therefore I cannot see its data.
> 
> Modal on both forms is "No"
> 
> I cannot get at the form in the background to complete work, any idea what is happening? 
> 
> I am not using tabbed forms.
> 
> --
> 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