Results 1 to 5 of 5

Thread: Access Active window Maximize? [RESOLVED]

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2004
    Location
    SouthWest
    Posts
    120

    Resolved Access Active window Maximize? [RESOLVED]

    Hello all-

    I have a macro in access that im running through vb. in the macro it maximizes a form that im opening but how would I maximize the active window? heres the code I have.....


    VB Code:
    1. Set moApp = New Access.Application
    2.     moApp.OpenCurrentDatabase App.Path & "\Andrade.mdb"
    3.     moApp.Visible = True
    4.     moApp.DoCmd.RunMacro "Boda", , ""

    Thanks a million for any help!
    Last edited by jandrade15; Apr 29th, 2005 at 05:52 PM.

  2. #2
    Addicted Member
    Join Date
    Jan 2002
    Location
    Glasgow, Scotland
    Posts
    202

    Re: Access Active window Maximize?

    have you tried:

    VB Code:
    1. DoCmd.Maximise
    if you fail to plan, you plan to fail

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Nov 2004
    Location
    SouthWest
    Posts
    120

    Re: Access Active window Maximize?

    Yeah I gave that a try and that didnt work?

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Access Active window Maximize?

    Use these to max the application window and the second to max the mdi child window.
    Note: the VBA Editor window requires a different method.

    VB Code:
    1. Application.RunCommand (acCmdAppMaximize)
    2.     Application.DoCmd.Maximize
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Nov 2004
    Location
    SouthWest
    Posts
    120

    Re: Access Active window Maximize?

    Once again your the man Robdogg!!!!
    Thanks for always giving that helping hand!!!!
    You always give sample code and thats what makes it tons easier on us newbies and also makes it easier to learn and grasp more of what were doing....... So THANK YOU!!!!!!!
    -Jose

Posting Permissions

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



Click Here to Expand Forum to Full Width