making adjustment for the start bar on the side of the screen

Discussion in 'Microsoft Access VBA Modules' started by Southern at Heart, Nov 30, 2009.

  1. I want my 2 windows to be tiled vertically.
    Window1 is on the left and needs 25% of the screen
    Window2 is on the right and needs 75% of the screen
    I've done this with something like the code below, but this doesn't take
    into account if the user has the start bar on the side. Is there a way to
    tell if it is, and how many pixels it's taking up?
    thanks, southernatheart

    lngHorizontal = System.HorizontalResolution
    lngVertical = System.VerticalResolution
    'RESIZE THE EXISTING DOCUMENT
    Application.WindowState = wdWindowStateNormal
    Application.Move Left:=0.2 * lngHorizontal, Top:=0 'Resize the page
    Application.Resize Width:=(lngHorizontal * 0.55), Height:=lngVertical * 0.72
    ActiveDocument.Save
     
    Southern at Heart, Nov 30, 2009
    #1
    1. Advertisements

  2. Southern at Heart

    Dirk Goldgar Guest

    "Southern at Heart" <> wrote in
    message news:...
    >I want my 2 windows to be tiled vertically.
    > Window1 is on the left and needs 25% of the screen
    > Window2 is on the right and needs 75% of the screen
    > I've done this with something like the code below, but this doesn't take
    > into account if the user has the start bar on the side. Is there a way to
    > tell if it is, and how many pixels it's taking up?
    > thanks, southernatheart
    >
    > lngHorizontal = System.HorizontalResolution
    > lngVertical = System.VerticalResolution
    > 'RESIZE THE EXISTING DOCUMENT
    > Application.WindowState = wdWindowStateNormal
    > Application.Move Left:=0.2 * lngHorizontal, Top:=0 'Resize the page
    > Application.Resize Width:=(lngHorizontal * 0.55), Height:=lngVertical *
    > 0.72
    > ActiveDocument.Save



    I think maybe this question is not about programming Microsoft Access, which
    is the focus of this newsgroup. Is it Word, perhaps? If so, you would do
    better to post in <microsoft.public.word.programming>.

    --
    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    (please reply to the newsgroup)
     
    Dirk Goldgar, Nov 30, 2009
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. CR
    Replies:
    0
    Views:
    272
  2. Victor Cheung
    Replies:
    0
    Views:
    153
    Victor Cheung
    Dec 12, 2003
  3. JonWayne

    Progress bar in status bar

    JonWayne, Apr 6, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    3,705
    JonWayne
    Apr 7, 2005
  4. Victor Torres

    How to create a Thinking Bar not a Progress Bar

    Victor Torres, Apr 14, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    16
    Views:
    5,885
    Tony Toews [MVP]
    Apr 18, 2009
  5. Southern at Heart

    Start Bar on side messes up my resize

    Southern at Heart, Nov 29, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    176
    Southern at Heart
    Nov 29, 2009
Loading...

Share This Page