Rocky Smolin
rockysmolin at bchacc.com
Sat Sep 25 11:05:30 CDT 2010
A.D.: I tried your resizing routine this morning, and sorry to say it did not fix the flashing problem. But, I now think that my original assumption was wrong - it does not have to do with the resizing because I commented out the call to the resizing module in a form that jumps consistently on opening and it still jumped. So there's something else going on there that I can't figure out. This only happens with the mde, not the mdb, BTW. So I commented out ALL the code in one of the jumping forms in the _Open and Current events of both the main form and sub-form on the theory that there was something in there that caused the jump. Still jumped. So I copied the mdb to machine #2, fired it up in A2007, created and mde in A2007- no jumping. So then I copied over the mde that had been created in A2003. No jumping. So apparently it has to do with running the mde in A2003. Could it be the installation on A2003 on my primary machine? I copied the mde created in A2003 to my laptop and ran it in A2003. Jumps. Last test - copied mde created on machine #1 in A2003 to machine 2 where I tested the mde in A2007 but also have A2003. On that machine in A2003 the forms jumps on opening whether screen resizing is used or not. So it's still a mystery but I've eliminated a few possibilities. Regards, Rocky Smolin Beach Access Software 858-259-4334 Skype: rocky.smolin www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal Sent: Wednesday, September 22, 2010 12:44 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Resizing of forms to suit screen resolution in force Rocky, Could you kindly open my sample db, click on various command buttons on switchboard form so as to open the demo forms one by one and advise whether the behavior is found OK ? You can also test the custom resize feature by dbl clicking a demo form's blank area. It should take only a few minutes. Best wishes, A.D. Tejpal ------------ ----- Original Message ----- From: Rocky Smolin To: 'Access Developers discussion and problem solving' Sent: Wednesday, September 22, 2010 11:02 Subject: Re: [AccessD] Resizing of forms to suit screen resolution in force A.D.: I have had a problem with 'jumping' screens - forms that seem to jump a millimeter or so when they open - or maybe flash and repaint. It only happens with mdes not mdbs, and I have always thought it had to do with the form resizing code I got from the ADH. Do you know about this and does your method eliminate this problem? MTIA Rocky Smolin Beach Access Software 858-259-4334 Skype: rocky.smolin www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal Sent: Tuesday, September 21, 2010 10:09 PM To: Access Developers discussion and problem solving Subject: [AccessD] Resizing of forms to suit screen resolution in force The topic of automated resizing of forms so as to suit current screen resolution comes up from time to time. My sample db named Form_Resize (in Access 2002-2003 file format, reference: DAO 3.6), meant to cover this requirement, has been uploaded to Rogers Access Library. Link - http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45 Apart from automatic resizing to suit current screen resolution, the sample offers custom resizing (up or down in steps of 5 percent) of any given form, if so desired by the user, with the option to freeze the custom size so that thereafter the form opens to custom size (over-riding the size dictated by actual resolution). At any stage the behavior can be reset to normal (i.e. automatic resizing to suit current resolution). Resizing is effected through a self contained class. Six styles of demo forms are included in the sample as follows: (a) Simple controls - all free to float and resize. (b) Simple controls - with certain controls having tag property settings for locking their position and / or size. (c) Combo box and list box. (d) Nested subforms - Continuous. (e) Nested subforms - Datasheet. (f) Tab control having (i) Nested subforms and (ii) Option group. Also - an option group directly on the form. I shall be thankful if interested members could kindly make it convenient to run the sample and confirm whether any aspects need further tweaking. Explanatory notes are provided in file Notes.htm accompanying the sample. Best wishes, A.D. Tejpal ------------ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com