Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

No default nor customized menus and always maximized forms, report

Discussion in 'Information Technology' started by Adnan, Jul 28, 2006.

  1. Adnan

    Adnan
    Expand Collapse
    Guest

    Hi All,
    How do I keep all forms, reports, tables etc… maximized all the time and no
    menus nor toolbar, not even default menu bar (Start up did not do it)

    Thank you all, for any help, tip, trick provided!
    Adnan, Computer Science Student, Kosovo

    --
    Please post all your inquiries on this community so we can all benefit -
    Thank you!
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Adnan wrote:
    > Hi All,
    > How do I keep all forms, reports, tables etc. maximized all the time
    > and no menus nor toolbar, not even default menu bar (Start up did not
    > do it)
    >
    > Thank you all, for any help, tip, trick provided!
    > Adnan, Computer Science Student, Kosovo


    The Minimize, Close, and Restore buttons are positioned within the
    application main menu bar when an Access object is maximized. If you remove
    ALL menus and maximize a report you will have no way to close it.

    Better would be to create your own main menu that doesn't have anything in
    it. Then set that as the main menu in Startup properties.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. Adnan

    Adnan
    Expand Collapse
    Guest

    Re: No default nor customized menus and always maximized forms, re

    Thank you Rick, creating my own menu is a solution, I’ll try that since there
    are no alternatives. I’ve seen a code that removes all menus on start up and
    then I guess restores them just before the closure…) but as you advised a
    customized menu would do the job, the only thing that I still need is keeping
    all windows maximized within the access application, you said it would be on
    window menu, did you mean window (form/table/report) properties?

    I appreciate your great response/help and everybody else’s contribute.
    Adnan, Computer Science Student, Kosovo

    --
    Please post all your inquiries on this community so we can all benefit -
    Thank you!


    "Rick Brandt" wrote:

    > Adnan wrote:
    > > Hi All,
    > > How do I keep all forms, reports, tables etc. maximized all the time
    > > and no menus nor toolbar, not even default menu bar (Start up did not
    > > do it)
    > >
    > > Thank you all, for any help, tip, trick provided!
    > > Adnan, Computer Science Student, Kosovo

    >
    > The Minimize, Close, and Restore buttons are positioned within the
    > application main menu bar when an Access object is maximized. If you remove
    > ALL menus and maximize a report you will have no way to close it.
    >
    > Better would be to create your own main menu that doesn't have anything in
    > it. Then set that as the main menu in Startup properties.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     
  5. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Re: No default nor customized menus and always maximized forms, re

    Adnan wrote:
    > Thank you Rick, creating my own menu is a solution, I'll try that
    > since there are no alternatives. I've seen a code that removes all
    > menus on start up and then I guess restores them just before the
    > closure.) but as you advised a customized menu would do the job, the
    > only thing that I still need is keeping all windows maximized within
    > the access application, you said it would be on window menu, did you
    > mean window (form/table/report) properties?
    >
    > I appreciate your great response/help and everybody else's contribute.
    > Adnan, Computer Science Student, Kosovo


    Normally in Access if you maximize one object you maximize all objects (except
    popup and dialog forms) so all you would have to do is not provide a way to
    restore anything. To force this just put...

    DoCmd.Maximize

    ....in the Open event of all forms and reports. You can hide the buttons to
    unmaximize forms and provide your own close buttons, but again, you must use the
    built in ones for reports and if the user hits restore then all objects are no
    longer maximized.

    Personally I find the all-things-maximized approach to be an ugly interface. Is
    there a particular reason why you need this?


    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  6. Adnan

    Adnan
    Expand Collapse
    Guest

    Re: No default nor customized menus and always maximized forms, re

    Yeas Rick, I want the database I am working to look pretty much like a web
    page ‘coze it’s going to be used for multiple user on the server.
    I have already gotten one of my inquires answered from a friend of mine
    Milazim to remove all menus, toolbars etc (code below)
    ----------------------------------
    Private Sub Form_Load()
    Dim i As Integer
    For i = 1 To CommandBars.Count
    CommandBars(i).Enabled = False
    Next i
    End Sub
    ----------------------------------
    And I guess you almost answered my last question I had – which I just tried
    but in some windows even though there are no restore events given they just
    restore the other windows behind upon their closure. That’s why I kept asking
    for something that would keep all forms/tables/reports etc always maximized.
    Again, thank you Rick.
    Adnan

    --
    Please post all your inquiries on this community so we can all benefit -
    Thank you!


    "Rick Brandt" wrote:

    > Adnan wrote:
    > > Thank you Rick, creating my own menu is a solution, I'll try that
    > > since there are no alternatives. I've seen a code that removes all
    > > menus on start up and then I guess restores them just before the
    > > closure.) but as you advised a customized menu would do the job, the
    > > only thing that I still need is keeping all windows maximized within
    > > the access application, you said it would be on window menu, did you
    > > mean window (form/table/report) properties?
    > >
    > > I appreciate your great response/help and everybody else's contribute.
    > > Adnan, Computer Science Student, Kosovo

    >
    > Normally in Access if you maximize one object you maximize all objects (except
    > popup and dialog forms) so all you would have to do is not provide a way to
    > restore anything. To force this just put...
    >
    > DoCmd.Maximize
    >
    > ....in the Open event of all forms and reports. You can hide the buttons to
    > unmaximize forms and provide your own close buttons, but again, you must use the
    > built in ones for reports and if the user hits restore then all objects are no
    > longer maximized.
    >
    > Personally I find the all-things-maximized approach to be an ugly interface. Is
    > there a particular reason why you need this?
    >
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     

Share This Page