jwcolby
jwcolby at colbyconsulting.com
Sat Apr 21 08:08:15 CDT 2012
When my forms jump around like that it is often because I have left a toolbar active which has to be removed by Access / windows. Make sure that every form has all toolbars unchecked at design time before you save them Then open and maximize. If there are any toolbars, Access opens the form with the toolbar, then removes the toolbar and resizes. Lots of jumping around. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 4/20/2012 11:33 PM, Rocky Smolin wrote: > > Application.WindowState = wdWindowStateMaximize won't compile - says > wdWindowStateMaximize is not defined. When I replace wdWindowStateMaximize > with 2 then .WindowsState method or data member not found. > > In ActiveWindow.View.FullScreen = True compiler says .View is an invalid > qualifier. > > An alternative to DoCmd.Maximize has promise - maybe another method of > maximizing will stop those last two Resizes. But I need some syntax that > the compiler likes. > > Rocky > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence > Sent: Friday, April 20, 2012 10:15 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Jumping Screen > > Have you tried the direct methods of(?): > > Application.WindowState = wdWindowStateMaximize ...or... > ActiveWindow.View.FullScreen = True > ...or > MySplashPage.Height = SysInfo1.WorkAreaHeight MySplashPage.Width = > SysInfo1.WorkAreaWidth MySplashPage.Top = SysInfo1.WorkAreaTop > MySplashPage.Left = SysInfo1.WorkAreaLeft ...and then center the your form > > I have not tested this as it has been a while since I have done anything in > Access. > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > Sent: Friday, April 20, 2012 7:49 AM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Jumping Screen > > Dear List: > > This is getting serious now. I made some changes to my A2003 product to fix > the problem of some of the forms not opening centered and maximized when > running the A2003 mde in A2007 and A2010. That problem is solved. > > But now the forms jump unacceptably when the form is opened in the mde > version. > > I tried to track it down by seeing if there's an event that's causing it. > So I put message Boxes in all the likely suspect events in just one form - > the Main Menu (figure if I can solve for this one form, I can do all). > > Now in this application, whenever I go to a new form I close the calling > form - stops the user from navigating the open windows instead of my > carefully crafted menus. :)c > > The ADH code for resizing and other housekeeping functions is in the Open > event (I tried moving this to the Load event - no difference). None of the > other events mentioned here have code except for the MsgBox. When I open > the Main Menu then, here's the sequence of events: > > Open > Resize > Load > Resize > Activate > Got Focus > Resize (after this one, the form actually appears) Lost Focus Current (no > record source on this menu - just a menu - at this point, part of the screen > shifts) Resize (big screen shift upwards) Resize (big screen shift > downwards) > > So it's those last two resize events that are causing the jumping problem. > In the mdb - not so much. In the mde - unacceptable. > > Biggest problem - I don't know how to stop this behavior. > > Any ideas are welcome. > > MTIA > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.bchacc.com<http://www.bchacc.com/> www.e-z-mrp.com > <http://www.e-z-mrp.com/> > Skype: rocky.smolin > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >