Screen Resolution Sizing

[dan.cawthorne]

Hello, All,

Well as you can see that my question is about changing the screen
resolution, and i know a lot of people are against the idea of
changing peoples Settings. and all the knock on effects it causing
with other applications.

I've done some searching, and i ain't been able to find any real
decent code.

about 98% of the users that use the database use the screen resolution
of 1024x768 so when i built the database i optimized the forms to
work on the resolution ( I have an awful lot of forms)

the other 2% use the 800x600 as a resolution, which when they open the
database the cant see everything and have to do a lot of scrolling
around.

And they've ask me to keep changing there screen size so they can see
the full form.

what would suggest having on a switch board menu, is a command button
to change the screen size, so, then its at the users discretion if
they want to change the size of the resolution at ease. with a dialog
message to warn them of the effects possibly caused.

then when they close the database. which I'm forcing them through a
dedicated close button (Disabled the X in corner) They are prompted
with an message saying would you like to reset you screen size back?

any suggestion?

Regards

Dan

 

[Douglas J. Steele]

Randy Birch has sample code to change screen resolution at
http://vbnet.mvps.org/index.html?code/enums/enumdisplaychange.htm

Obligatory warning: Randy's site is aimed at VB programmers. Because there
are some significant differences between the controls available for forms in
VB and in Access, many of his examples do not port directly into Access.
While I have used this particular code for test purposes, it was a long time
ago, and I can't remember whether any changes were required to make it work
in Access.

 

[OldPro]

Hello, All,

Well as you can see that my question is about changing the screen
resolution, and i know a lot of people are against the idea of
changing peoples Settings. and all the knock on effects it causing
with other applications.

I've done some searching, and i ain't been able to find any real
decent code.

about 98% of the users that use the database use the screen resolution
of 1024x768 so when i built the database i optimized the forms to
work on the resolution ( I have an awful lot of forms)

the other 2% use the 800x600 as a resolution, which when they open the
database the cant see everything and have to do a lot of scrolling
around.

And they've ask me to keep changing there screen size so they can see
the full form.

what would suggest having on a switch board menu, is a command button
to change the screen size, so, then its at the users discretion if
they want to change the size of the resolution at ease. with a dialog
message to warn them of the effects possibly caused.

then when they close the database. which I'm forcing them through a
dedicated close button (Disabled the X in corner) They are prompted
with an message saying would you like to reset you screen size back?

any suggestion?

Regards

Dan

Explicitly set the top, left, width, and height properties of each
control on the form based on InsideHeight.

If InsideHeight < 5800 Then
' Set the font size of all of the controls to 8
' Set the control sizes smaller...
else
' Set the font size of all of the controls to 10
' Set the control sizes bigger...
endif

 

[OldPro]

Explicitly set the top, left, width, and height properties of each
control on the form based on InsideHeight.

If InsideHeight < 5800 Then
' Set the font size of all of the controls to 8
' Set the control sizes smaller...
else
' Set the font size of all of the controls to 10
' Set the control sizes bigger...
endif- Hide quoted text -

- Show quoted text -

Sorry, I left out the obvious - put the code in a function, call it
from form_load( ).

 

[Tony Toews [MVP]]

Obligatory warning: Randy's site is aimed at VB programmers. Because there
are some significant differences between the controls available for forms in
VB and in Access, many of his examples do not port directly into Access.

FWIW, once you remove the VB6 specific stuff, such as working with VB
forms to show you that things are working, I have yet to have to have
a problem with any code from Randy's site.

Granted there's always a first time. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Douglas J. Steele]

FWIW, once you remove the VB6 specific stuff, such as working with VB
forms to show you that things are working, I have yet to have to have
a problem with any code from Randy's site.

Granted there's always a first time. <smile>

I'm not sure that most of the stuff in
http://vbnet.mvps.org/code/listapi/index.html, for example, will work in
Access (although I haven't tried since Access 97)

 

[Tony Toews [MVP]]

I'm not sure that most of the stuff in
http://vbnet.mvps.org/code/listapi/index.html, for example, will work in
Access (although I haven't tried since Access 97)

Sure, but that code is very VB6 specific dealing with controls and
such.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[dan.cawthorne]

Sure, but that code is very VB6 specific dealing with controls and
such.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Thank you all very much, for all your help, I will need to spend some
time working out how to use the code lol.