Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding toolbars (A2k)

    I have almost completed an Access project whose functions are selected from a switchboard. All forms have a button to return to the switchboard which has a button to exit Access.
    I am trying to prevent user twiddling and I wanted to know:

    1. How to hide the default toolbars.
    2.Is there a way to place a nonprintable button onto reports to close the reports and return the user to the switchboard?
    3.If 2, then can I disable the close icon on report windows?
    4.If all, then how would I then make any maintenance adjustments?
    5.Am I just being too paranoid?
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding toolbars (A2k)

    In the first place, if you select Tools/Startup..., you can set several options. I would suggest setting the switchboard form as startup form and hiding the database window. You can set whether the standard menu bar, toolbars and context menus are displayed. For maintenance, open the database with the Shift key held down; this will bypass the startup options.

    This is OK if you only want to prevent the users from accidentally messing up things. If you want better security, you can convert the database to an .mde database (Tools/Database Utilities). In an .mde database, users can't open forms and reports in design mode, and all code is hidden. You must keep a copy of the original .mdb. If you need to change anything, modify the .mdb and then create a new .mde database.

    For optimum security, set user level security. You can then define several roles: designer, power user, standard user, ...
    See the excellent overview ACC2000: Microsoft Access Security FAQ Available in Download Center from Microsoft.

    Although you can place a command button on a report, it won't do anything. You can create a custom toolbar with a close button (and other buttons you want the user to be able to use) and set the Toolbar property of your reports to the name of this custom toolbar. It will be displayed automatically instead of the built-in toolber for reports.

    Although it is possible to disable/hide the close button in the upper right corner of a report using Windows API calls, I have never been satisfied with the way that works. Besides, the user can always close a report by hitting the Escape key on the keyboard.

  3. #3
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding toolbars (A2k)

    Thanks Hans for your rapid and ever-helpful response. One small point:you didn't answer Q5!
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hiding toolbars (A2k)

    Nobody dealing with users can EVER be too paranoid! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Hiding toolbars (A2k)

    In response to Question 5, if you are referring to user "twiddling" -- and your users all act like their name is Alfred E. Neuman -- then the answer is NO, you can never be TOO paranoid!! <img src=/S/boxedin.gif border=0 alt=boxedin width=25 height=20>

Posting Permissions

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