Screen resolutions

K

Kevin Riley

I am making a multiuser database, each person has a form
on their desktops, They may have different resolutions on
the computers, I want to know how to program the database
form to switch to a certain resolution when they use the
program and then switch back after they are done with it.
 
J

Jeff Conrad

Hi Kevin,

Changing a user's screen resolution to fit the needs of
your program is a big "No-No" for Access development
(and probably all software development). User's have
set those preferences for any number of reasons, some
of which may be vision restrictions. If you changed my
screen resolution, that would be the last time I use
your program.

The *preferred* method is to can add code to your forms
that will resize all controls to various screen resolutions.
That way each user can still have their own preferences.
Here are some links for you if you want to pursue this option.

1. Download an MDE file from the Developer's Handbook web
site. You can then reference that MDE in your application
to use the resize code.
http://www.developershandbook.com/

2. Purchase the Developer's Handbook for your version of
Access. In my opinion the book is WELL worth the money.
Not only do you get the resize code, but a wealth of other
information, code, and database samples. Go to the same
site listed above for more information.

3. Peter's software has a resizing utility at:
http://www.peterssoftware.com/ss.htm

4. The following link has also been posted as an alternative:
http://www.jamiessoftware.tk

5. Here is another possibility, but I have no experience
with this one either:
http://www.pdtech.co.uk/prod01.htm
 
M

Mike Labosh

(nice suggestions by the way)

Another idea is to redesign the form:

Here's a fictitious order form that has well over a hundred fields..
Customer name, acct #, shipping address, billing address, order history of
current outstanding balance, lots of order header stuff, like bill date,
ship date, order date, FOB point, BOL certs, manifest info, tax rates,
volume discount fields, gobs of columns for the line items: product code,
description, cost, tax, quantity, price subtotals, tax totals, shipping
totals, payment method info... Oh wait, it's a chemical company, so we need
lots and lots of checkboxes about hazmat, placards, whether the truck driver
needs an environment suit (I have seen this) whether the warehouse guys need
face masks... I could go on and on.

This form sounds like it needs an enormous screen resolution. Or Tabs.

Put the customer stuff on one tab, order stuff on another tab, line item
stuff on another tab, totals on another tab, shipping stuff on another tab.

ALL business applications should be able to run comfortably on a screen with
640 x 480 at 256 colors. The screen setup, window size and location are the
users' decision, not ours :)

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!
 
P

Peter De Baets

There are third-party form scaling solutions available that might
help:

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site:
http://www.peterssoftware.com/ss.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

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com
 
Top