Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Different Size Monitors (Access 2000)

    I remember seeing some code to modify so that it didn't matter what size monitor you were viewing a db from, it always maximized on the screen. Can anyone remember seeing something like this?

    Thanks!

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Size Monitors (Access 2000)

    I have used an API function to check the current screen resolution for a specific value (such as 800x600). If the resolution is not 800x600, the current resolution is stored in a table, the resolution is changed, then original resolution is restored when the user exits the application. Let me know if you'd like this code - I'll be happy to post it! <img src=/S/trophy.gif border=0 alt=trophy width=15 height=15>

    I think you're referring to an add-in that resizes objects on a form depending on the window size, right? There are several utilities out there - most are for sale. One is on <A target="_blank" HREF=http://www.peterssoftware.com>Peter's Software page</A>.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Size Monitors (Access 2000)

    Dear MarkJ,
    I would really appreciate the code for checking & adjusting screen resolution when different size monitorsare used wAccess 2000
    Thank You
    Ed B

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Size Monitors (Access 2000)

    Hi Ed,

    Sorry for the delay. I had forgotten how specific the code was to my project. I've modified it so that it's pretty generic now.

    Let me know if you have any questions about getting it to work. I borrowed the API examples from and a useful freeware tool called <A target="_blank" HREF=http://www.allapi.net/>The API-Guide.

    HTH <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

    Mark
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    May 2001
    Location
    indiana
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Size Monitors (Access 2000)

    Hi Mark
    I just recently used the procedure you provided to change the screen resolution. Things look pretty good, however while the resolution is changed, the taskbar at the bottom of the screen is gone, and the access screen only goes down to where the taskbar *should* be. Everything goes back to normal once i get out of access. I am running access 97 on Win2000. any help would be appreciated.

    thanks

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Size Monitors (Access 2000)

    It always worked that way for me too (even on Win9X). The taskbar was never visible (because it is apparently not resized in the process). There should be a separate API call to resize the taskbar, although I don't know exactly what it is at the moment.

  7. #7
    Star Lounger
    Join Date
    Dec 2001
    Location
    Fredensborg, Denmark
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Size Monitors (Access 2000)

    Hi Mark

    I stumbled over your code and tried it out, since I may need it for a new application.

    It works fine and as a pleasant surprise to you (unless you already tried it on XP) the task bar looks just fine. I am run running Windows XP and Office XP.

    However, I found the following when testing:
    1. I set the screen resolution to 800x600.
    2. I run your code and change to 1024x768.
    3. I do not reset on exit, i.e. I want to keep the new screen resolution.
    4. I reboot and find that the screen resolution is now again 800x600.

    I thought it would stay 1024x768 after a reboot.

    This is not at all serious and will not cause me any trouble since I will always reset the screen resolution to what it was without asking.
    This is a message just to let you know - and thank you for the code.

  8. #8
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Size Monitors (Access 2000)

    Hi Claus,

    Thanks for your note. I used this resizing method for one application about a year ago and have not done much with it since.

    I did not realize that the resolution change is not permanent. Thanks for the information there. Also, as you read from the earlier posts, I have noticed some issues with Windows 9x and 2000 with the taskbar not resizing along with the resolution. The next time I have a need for this type of API call I'll definitely revisit the issue and post any updates I come across.

    Best,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •