Doug Murphy
dw-murphy at cox.net
Wed Jun 22 19:02:11 CDT 2011
More info on this challenge. I created a new split form. Put button on main form which has no fancy code. The button opens my test form in Dialog mode. Test for has a button that runs docmd.close acform, me.name. When Windows explorer is open in the background it is brought to the front and Access is move to the back. I have seen this on two different computers now. Is this a new feature? Any thoughts on how to keep the Access window in front? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Wednesday, June 22, 2011 4:27 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Focus going to Windows explorer when Acccess form closes Hi Arthur, I guess I wasn't clear. The application isn't closing when the form closes. What happens is that form some reason If Windows Explorer is open in the background on the computer it is moved to the foreground with Access still open behind it. There is really no code running in the form that closes aside from Docmd.Close acForm, Me.name. doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, June 22, 2011 3:53 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Focus going to Windows explorer when Acccess form closes Not me. I have lots of A2K7 apps which do this (close form, etc.) without problems. My apps stay open until the final Exit button is clicked. After that I cannot predict where the focus will go, since it depends on what you did prior to opening my app. But that is not your problem, AFAIS. Something in your code is wonky. Do you have embedded anywhere a call to Application.Close? Just a WAG. Arthur On Wed, Jun 22, 2011 at 6:33 PM, Doug Murphy <dw-murphy at cox.net> wrote: > Folks, > > This is why I love Microsoft Products. I have a client with an Access > database. He asked for some additional functionality so I added a form > to collect Customer information notes. He has Access 2010 running on > Windows 7, same as my setup. The Customer information form allows > input of notes and transactions. It is opened from the main Customer > form by clicking a button. > The Customer information form is an Access split form (new to Access > 2007 and 10, where you can edit the record in the top of the form and > see a record list in the bottom. I like them for some purposes.). The > Customer Information form opens as a popup dialog so the focus stays > on the form until it is closed. I should say the forms open as > individual forms and do not open in the Access 2007/2010 tab view. The > interesting thing with this is that if Windows explorer is open on the > computer when the Customer Information form is closed the focus moves > to the Windows Explorer screen. > Access is still running in the background so you can move back to it. > If Windows Explorer is not open or is minimized then Access retains focus. > Bizar! It works the same on my computer. > > Has anyone else seen this behavior? > > -- 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