Results 1 to 13 of 13

Thread: Maximize forms

  1. #1
    Join Date
    Dec 2007
    Posts
    70

    Unanswered: Maximize forms

    How can I make sure forms are always maximised. When you open them sometimes they are maximised and sometimes they only fill half the screen!!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Just put DoCmd.Maximize in the open event of your forms.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    I always create a macro call "Max Me" which has the DoCmd.Maximize in it
    then all i do is call the macro on the onload event in a form/report
    or call it from code Docmd.runmacro "Max Me"
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I'm curious - why run a macro with 1 command to maximize verses just putting the docmd.maximize command in the OnOpen/OnLoad event of the form?
    Last edited by pkstormy; 12-19-07 at 21:47.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes... seems even weirder to call it from code with DoCmd.RunMacro "Max Me"... seems all too hard :P
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    yes both are right

    that was the first code I wrote way back version 1 i think
    and it stuck with me.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Ahh... understandable... I think we all have little things like that, which just hang around. I avoid Macros like they have the plague or something. Even when writing a macro and referring to it 50 times would save 50 event procedures, I'd still prefer to write the 50 procedures!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    agree...
    macros just don't feel right to me..
    in part because you loose control over things like error handling and the like
    but chiefly I suspect they just aren't code.. and I come from a code background, or perhaps macros aren't 'macho' enough to for me to work with

    but sometimes they are very usefull, and lets face it some of the code constructs such as docmd, openform/report wahtever are infact macros masquerading as code, and lets be realistic ultimately its all interepted as byte code soemwhere. The macro implementation of a task should be at least as efficient, if not more efficient, that a hand written piece of code for exactly the same task as Access developers should know the internals of Access better than we do.

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    One of the main reasons I avoid macros is that you can't find out where they are called from... whereas in code, you can just do a project-wide search.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Anything that you can Macro, you can code... You can even convert your macros into modules (and have the option to add generic error handling too).


    So if you find it easier to make macros, then do...
    ...But don't forget to right click and save as module!
    George
    Home | Blog

  11. #11
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Obsucatory little buggers they are.

  12. #12
    Join Date
    Oct 2007
    Location
    Washington D.C.
    Posts
    24
    Hello, I'm Friz and I am a recovering former user of Macros. It has been three years since my last Macro...

    [pauses for comedic effect]

    Yeah, took me a while to finally get rid of my macro dependance. Back in the late 90s when I first started using Access I fell into the trap of using macros simply because for a n00b they are way too easy to use.

    Once I finally got up off my butt and began to learn VBA I was able to convert all of them to code and I haven't looked back since!

  13. #13
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I think many people would be in the same situation as you Friz.

    LOL @ your sense of humour! Appreciate it
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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