Rocky Smolin
rockysmolin at bchacc.com
Tue Apr 3 09:51:26 CDT 2012
A.D.: Thanks for your reply. I'll give that a try although converting the entire app may be a big job. I use the following code in each form: ' If mde then turn off windows in taskbar and menu bar Set db = CurrentDb If InStr(1, db.Name, "mde") <> 0 Then Me.MenuBar = "=1" On Error GoTo Err_Form_Open End If To turn off the menu bar. Do you think that might be causing the jumping? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com www.e-z-mrp.com Skype: rocky.smolin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal Sent: Monday, April 02, 2012 8:55 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Forms Jumping in mde Rocky, As far as I recollect, your earlier problem had its roots in run time alteration of tool bars. In the present case, you might like to experiment whether the problem gets resolved if the forms are made pop up, as in that case there should be no resultant disturbance as a result of varying real estate occupied by tool bars. Best wishes, A.D. Tejpal ------------ ----- Original Message ----- From: Rocky Smolin To: 'Access Developers discussion and problem solving' Sent: Monday, April 02, 2012 23:50 Subject: Re: [AccessD] Forms Jumping in mde OK, Last Clue - I put the mde on my test bed and ran it in 2010 - no jumping; I ran it in 2007 - no jumping; I ran it in 2003 - JUMPING!!! Something to do with 2003 apparently even though the mdb was developed and is maintained in 2003 and compiled to the mde in 2003. Could it be just my install? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, April 02, 2012 10:20 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forms Jumping in mde I'm noticing that there is a small jump when using the mdb. SO it may not be related just to the mdb but the mde may be exaggerating the effect. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, April 02, 2012 9:49 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forms Jumping in mde Or even better, is there some way to eliminate that jumping without having to do a lot of reprogramming and testing (just commenting out the closes won't work completely because I do some navigating based on whether another form is open). TIA Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, April 02, 2012 9:36 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Forms Jumping in mde Dear List: I have an application which, when compiled into an mde, causes the forms to jump annoyingly when they open. I had this problem with another application years ago and got a fix from A.D. but that doesn't seem to work on this app. In each form I do the form resizing from the ADH and call the routines to translate the form into a different language. Suspecting these might be the problem, I commented out all calls to those routines. No difference. I also close each form that calls another form so that only one form is open at a time. I commented out those closes. And the jumping went away. I originally put those closes in there to keep the users from using the open windows for navigating but I turn off the menu bar with the windows list box, and turn off the windows in the taskbar if it's the mde. Is there some limit or downside to having a lot of windows open at once? There are about 150 forms in this app. 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