MACE, Terry
terry.mace at baesystems.com
Tue Sep 7 22:15:19 CDT 2010
Yes I do Regards Terry Mace -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Wednesday, 8 September 2010 9:49 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Strange Behaviour with Popup Forms in Acc2007 I might have missed this but under Access options, Current Database, you do have the overlapping windows option checked instead of tabbed documents, right? On Tue, Sep 7, 2010 at 3:23 PM, MACE, Terry <terry.mace at baesystems.com> wrote: > John, > > None of the forms are modal but all are pop up. I've also found another area in the database that exhibits the same behaviour and it's also fired from a double-click event. All the ones that are fired from a command button work fine. > You may be right in that it is a bug. > > Regards > > Terry Mace > Logistics Support Officer & Maintenance Supervisor > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Wednesday, 8 September 2010 3:28 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Strange Behaviour with Popup Forms in Acc2007 > > Terry, > > Since no one has offered anything... > > It surely sounds like a bug, although it may also be that this form is not opening modal or popup > whereas one of the others you mentioned are. > > If that is the case, then this would be the expected behavior and your old application simply did > not respond as it should have. > > Modal forms are supposed to be on top at all times and cannot lose the focus. Popups are supposed > to start out on top but can lose the focus. > > Are any of the other forms mentioned being opened modal or popup? > > John W. Colby > www.ColbyConsulting.com > > On 9/7/2010 12:29 AM, MACE, Terry wrote: >> Hi all, >> >> Our company is moving from Acc97 to Acc2007 and an app that I wrote a long time ago is behaving 'incorrectly' when converted to Acc2007. >> >> I have a continuous form set to popup with a double-click field, which when clicked opens another popup form, which then opens a further form. In Acc97 each form opens one on top of the other as they should. >> >> In Acc2007, the second form opens behind the first form and is not visible. If the forms are moved around to get to the second form, the third form will then open on top of the others. >> >> The forms that open on top are started from a command button, whereas the one that doesn't starts from a double-click text field. >> >> The code that is not working is: >> Private Sub Part_Number_DblClick(Cancel As Integer) >> DoCmd.OpenForm "frmItemSelect", , , , , , Me.Part_Number >> End Sub >> >> When stepping through the code, the form is in front until the End Sub statement is executed, when the form with the code comes back to the front. >> >> Any ideas on getting the forms to open in the right order would be most appreciated. >> >> Cheers >> >> Terry >> >> "Warning: >> The information contained in this email and any attached files is >> confidential to BAE Systems Australia. If you are not the intended >> recipient, any use, disclosure or copying of this email or any >> attachments is expressly prohibited. If you have received this email >> in error, please notify us immediately. VIRUS: Every care has been >> taken to ensure this email and its attachments are virus free, >> however, any loss or damage incurred in using this email is not the >> sender's responsibility. It is your responsibility to ensure virus >> checks are completed before installing any data sent in this email to >> your computer." >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > "Warning: > The information contained in this email and any attached files is > confidential to BAE Systems Australia. If you are not the intended > recipient, any use, disclosure or copying of this email or any > attachments is expressly prohibited. If you have received this email > in error, please notify us immediately. VIRUS: Every care has been > taken to ensure this email and its attachments are virus free, > however, any loss or damage incurred in using this email is not the > sender's responsibility. It is your responsibility to ensure virus > checks are completed before installing any data sent in this email to > your computer." > > > > -- > 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 "Warning: The information contained in this email and any attached files is confidential to BAE Systems Australia. If you are not the intended recipient, any use, disclosure or copying of this email or any attachments is expressly prohibited. If you have received this email in error, please notify us immediately. VIRUS: Every care has been taken to ensure this email and its attachments are virus free, however, any loss or damage incurred in using this email is not the sender's responsibility. It is your responsibility to ensure virus checks are completed before installing any data sent in this email to your computer."