screen resolution

[JohnE]

Hello. My question pertains to the screen resolution. I am wondering if it
is possible for Access 2003 (eventually to 2007) to change the screen
resolution when it opens and closes. What I would like to do is have the
application open up and change the users screen resolution to a predetermined
size. Can this be done? If so, how as I am not that good with vba code?
Also, when the user closes the application, the screen resolution is restored
back to what it was before the app opened up. Is this possible? If so, how
(same reason as above)?
Thanks for responding.
.... John

 

[Rick Brandt]

Hello. My question pertains to the screen resolution. I am
wondering if it is possible for Access 2003 (eventually to 2007) to
change the screen resolution when it opens and closes. What I would
like to do is have the application open up and change the users
screen resolution to a predetermined size. Can this be done? If so,
how as I am not that good with vba code? Also, when the user closes
the application, the screen resolution is restored back to what it
was before the app opened up. Is this possible? If so, how (same
reason as above)?
Thanks for responding.
... John

Possible in some PC setups, not in others, and always a terrible idea. You
don't sometimes toggle between two different programs on your PC? Merely
setting the resolution back when your app is closed would not be acceptable
to hardly anyone and your app would just look amatuerish for the need to do
so.

Games are the only acceptable case for changing a user's resolution and I
don't know if even they have done that for a while now. You just need to
design your app for a minimum resolution specification using your user-base
to establish what that minimum size is.

With the proliferation of LCD screens now you could possibly change to a
resolution that the user's display doesn't even support causing them to lose
their display entirely or at least distort it beyond usability.

 

[Rick A.B.]

Hello.  My question pertains to the screen resolution.  I am wonderingif it
is possible for Access 2003 (eventually to 2007) to change the screen
resolution when it opens and closes.  What I would like to do is have the
application open up and change the users screen resolution to a predetermined
size.  Can this be done?  If so, how as I am not that good with vba code?  
Also, when the user closes the application, the screen resolution is restored
back to what it was before the app opened up.  Is this possible?  If so, how
(same reason as above)?
Thanks for responding.
... John

John,

There is a program called Reschange.exe. You can find it at
http://www.12noon.com/reschange.htm

I have never used it for an access app but I do for a Terminal program
and it works well.

Hope that helps.

Rick

 

[Daniel Pineault]

You can make your forms dynamic and adjust to the user's resolution. Check
out the code at http://www.mvps.org/access/general/gen0002.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.