Jim Lawrence
accessd at shaw.ca
Fri Apr 20 12:52:27 CDT 2012
I am not sure. Never used the DoCmd call where an Application or direct dll call was available. Never timed these features but always assumed direct calls ran faster and were less likely to be buggy. 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 10:35 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Jumping Screen Is there a difference between Application.WindowState = wdWindowStateMaximize and DoCmd.Maximize?Or between ActiveWindow.View.FullScreen and DoCmd.Maximize? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com