Consistent Form/Report opening

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

I just finished an mdb and sent a copy to a friend to try.
On my copy, the forms open in the middle of the window at the desired size
and reports open maximized.
I have a doCmd.restore in the form's activate event to make sure the forms
are alwas open at the size desired.
on my friend's PC the forms opem on the bottom of the window and are
partially hidden and the reports open with olny 1/2 the page displayed-
How can i set my mdb to work correctly on other machines?
 
There may be a difference in screen resolution.
Is there?

================================================
Access 2002 Desktop Developer's Handbook (Getz, Litwin)
There are 3 classes to handle screen resolution in the book.
They are worth the price of the book alone.
Plus you get the book!
 
Joe - yes the screen resolutions are different - friend has a 19 inch screen
and higher resolution..
Thanks
 
There are third-party form scaling solutions available that might help
maintain application consistency in appearance from computer to computer:

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site:
http://www.peterssoftware.com/ss2.htm

FMS has a sizer module at www.fmsinc.com.

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

For more informmation, there are some great articles about form scaling in
the December 2000, and May 2001 SmartAccess newsletter. Check it out here:
http://www.smartaccessnewsletter.com

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com
 
Joe -thanks - i recently bought the 2k2 developers Handbook - but then found
out that 2k2 won't make 2k mdes - and my mdbs are 2k to accomodate users at
work.
So - i tried using the classes form the 2k2 handbook but there are errors
some properties not recogniozed.
Peter - thanks -i'll try yours- hopefully it will solve the problems...
 
Thanks folks - i finally figured out how to save the modules as a class
modues and the errors are gone...
appreciate your responses..
 
Back
Top