[AccessD] Resizing of forms to suit screen resolution in force

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




More information about the AccessD mailing list