Results 1 to 14 of 14
  1. #1
    Join Date
    Jun 2008
    Posts
    163

    Unanswered: form - how: always on top, fixed position (access 2003)

    I have a form that acts as a switchboard/navigation bar, how do I make it stay on top of all windows and give it a fixed position? Thanks!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Have a good look through form properties. Particularly at Popup, Auto Centre, Top, Left... those kinds of properties should lead you to where you want to be

    Post back if you can't figure it out!
    Last edited by StarTrekker; 07-16-08 at 05:30.
    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

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    ST; you forgot one key one

    modal
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well... ummm.... I hate modal ??

    :blush:
    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

  5. #5
    Join Date
    Jun 2008
    Posts
    163
    Thanks guys, I'm currently trying it out. =D

    How do I set the height of a form? And is there a way to create an on open event that will close ms access toolbars?

    [EDIT]
    accidentally activated modal on a form with no close form command available. I think I see one of the reasons why it wasn't suggested. X_X
    Last edited by coffeecat; 07-17-08 at 21:59.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    How do I set the height of a form?
    With the Height property or by sizing it in Design View.

    is there a way to create an on open event that will close ms access toolbars?
    Not sure, but in Tools - Startup, you can turn off full menus and toolbars.
    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

  7. #7
    Join Date
    Jun 2008
    Posts
    163
    I found the height, eventually, i kept highlighting the wrong part of the form. Thanks ST

    I changed the settings for the start up. Since I'm planning on having just a couple of clients, I guess adjusting the settings per computer is fine.
    --

    How do I hide the objects window and set a form to automatically open when the mdb file is accessed?

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by coffeecat
    accidentally activated modal on a form with no close form command available. I think I see one of the reasons why it wasn't suggested. X_X
    You have a form with no close command?! That's your fault then, eh

    If you're working on an mdb, remember you can right click the form and chose "Design View" when you want - so you're not completely stuck if you do this again!
    George
    Home | Blog

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    CTRL-F4 works good too.
    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
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    How do I hide the objects window and set a form to automatically open when the mdb file is accessed?
    You need to take your time when you look at new things.

    Go back into Tools - Startup and tell me what options are there and what they do and then I'll answer this question!
    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

  11. #11
    Join Date
    Jun 2008
    Posts
    163
    You have a form with no close command?! That's your fault then, eh
    Hehe, yeah, pretty embarrassing. Thank goodness the right click was still enabled. =D

    I have a huge form that serves as a background image (I set all the other forms as pop-up). My bgimage form has no close, control, and scroll -and until I'm done with the rest of the DB i won't disable the right click on it yet.

    Speaking of which, is there an easy way of making a background?
    ---

    @st:

    application title, icon, display form/page = empty/none
    menu bar, shortcut menu bar = default

    enabled ticker boxes= display db window, display status bar, allow full menus, allow default shortcut menus, allow built-in tool bars, allow toolbar/menu changes, use access special keys.

    In parenthesis in the bottom of the startup window: "show startup window, show immediate window, show vb window, and pause execution"

    I tried fiddling around with the settings and got something close to what I wanted. Thanks! =D

    ---
    While looking around for sample mdbs, I found an mdb that when opened, it would automatically open a form (it was also a pop-up modal, . Something like the splash screen for the northwind demo. I was wondering how to set that.

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    application title, icon, display form/page = empty/none
    menu bar, shortcut menu bar = default

    enabled ticker boxes= display db window, display status bar, allow full menus, allow default shortcut menus, allow built-in tool bars, allow toolbar/menu changes, use access special keys.

    In parenthesis in the bottom of the startup window: "show startup window, show immediate window, show vb window, and pause execution"
    Listing these things doesn't tell me what they do. Look closer at each option and actually find out what each of them does. The answer you seek is right before you!
    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

  13. #13
    Join Date
    Jun 2008
    Posts
    163
    Thanks ST! =D

  14. #14
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're most welcome
    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
  •