PC Review


Reply
Thread Tools Rate Thread

Auto For Access

 
 
=?Utf-8?B?RjFzdG1hbg==?=
Guest
Posts: n/a
 
      19th Jun 2006
Hey All,
Is there a way to set an access database to auto adjust settings in order to
appear correctly on each users screen? I have a few users who have their
desktop set to an extremely low resolution leading to a zoomed and blocky
access display. Will they have to adjust this themselves or is there a better
way. Please explain where to put and how to use any code. I am a VBA rookie.
Thanks, Adam
 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      19th Jun 2006
There's not a nice solution for this.

If you buy the Access Developers Handbook by Getz et al (Sybex), the chapter
on Forms (cpt 8 from memory) has code that shows how to resize the form and
its objects based on the screen resolution of the user.

But I find that clunky, and I hate the very concept that some developer
thinks he has the right to enlarge all his text so it fills up my entire
screen. I did not buy a high res to give him that option.

So, ultimately you define the mimimum resolution your application will run
at, and design for that. Used to be 800x600. These days I find must people
accept 1024x768 as a minimum, and accept that they need to upgrade their
monitor if they have less than that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"F1stman" <(E-Mail Removed)> wrote in message
news519CB06-5A29-42A0-B10E-(E-Mail Removed)...
> Hey All,
> Is there a way to set an access database to auto adjust settings in order
> to
> appear correctly on each users screen? I have a few users who have their
> desktop set to an extremely low resolution leading to a zoomed and blocky
> access display. Will they have to adjust this themselves or is there a
> better
> way. Please explain where to put and how to use any code. I am a VBA
> rookie.
> Thanks, Adam



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto update of Access DB from 3 other Access Databases AGOKP4 Microsoft Access External Data 1 25th Jul 2009 04:03 AM
How do I access the access data via Excel 2002 with auto update ? =?Utf-8?B?a2FydGhpaw==?= Microsoft Excel Programming 1 9th Feb 2007 01:56 PM
Auto Log Off for MS ACCESS 97 PRAV Microsoft Access VBA Modules 1 30th Aug 2006 10:49 AM
Access Auto Tab =?Utf-8?B?Sm9obk0=?= Microsoft Access Getting Started 3 2nd Oct 2004 02:57 PM
Auto Access Tiffany Microsoft Access 1 8th Mar 2004 06:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:50 PM.