Results 1 to 7 of 7
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    Divide Access to half a screen width

    Hi,



    it is possible to using vba divide access in order to get picture like here below:

    Click image for larger version. 

Name:	dzielenie.jpg 
Views:	12 
Size:	156.2 KB 
ID:	30640

    In Excel i would use:

    Application.WindowState = xlMaximized
    Szerokosc = Application.Width / 2
    Wysokosc = Application.Height
    Application.WindowState = xlNormal
    Application.Width = Szerokosc
    Application.Height = Wysokosc
    Application.Top = 1
    Application.Left = 1

    Thank you for your help,
    Best Wishes,
    Jacek Antek

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Looks like a split form to me. Alternatively if these are separate windows then only by using subforms - particularly if you are using tabbed documents

    in the form resize event put

    me.subform1.height=insideheight/2-me.subform1.top
    me.subform2.top=insideheight/2+60
    me.subform2.height=insideheight/2-me.subform2.top

    If you are using overlapping windows, you could probably use code similar to excel, but I don't have time to check it out - you would need to identify the hwnd of the relevant form/object windows. Alternatively in the form open event use the form move property to specify where it should appear within the access window.

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Thank you Ajax,

    i do not want to resize only forms but whole access window...

    In windows there is shortcut for it: windows sign + left arrow (and your active opened application will be split to half a screen).

    Best wishes,
    Jacek

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    that shortcut works for access as well

  5. #5
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Exatcly but i want to do this programatically...


    Jacek

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    OK - can't help, but since this is windows functionality I would have thought your excel code would work

    Regret I can't help further but good luck with your project

  7. #7
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Thank you Ajax,

    i think that i solved the problem. Simply i am using ac dialog form and i will be resizing only form - no whole Access.

    Best Wishes,
    Jacek

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2017, 10:59 AM
  2. Replies: 4
    Last Post: 01-25-2016, 12:44 PM
  3. Replies: 3
    Last Post: 04-10-2015, 02:35 PM
  4. Section Width is greater than page width
    By snowboarder234 in forum Reports
    Replies: 3
    Last Post: 07-31-2013, 09:06 PM
  5. The section width is greater than the page width?
    By Gary_Marshall in forum Reports
    Replies: 2
    Last Post: 11-13-2009, 01:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums