Results 1 to 5 of 5
  1. #1
    Torinjr is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    53

    Hiding/Disabling Toolbars and Editing Options

    I have an AutoExec Macro that opens a Form. The form has 3 buttons, Add Data, Edit Data and View Item Rates. It looks like this:



    Click image for larger version. 

Name:	Untitled1.png 
Views:	31 
Size:	13.0 KB 
ID:	20572

    I want to be able to Hide all the tool bars, menus etc to prevent users from changing the layout, data entries etc. So effectively they can only see whats displayed in the picture. If they click Edit Data button, which is password protected, I want the database to then display the Access Toolbars as normal, providing they had entered the right password of course.

    Is this a good way to provide security to my database or should I be trying something else? And how do i go about this?

    Thanks

  2. #2
    Torinjr is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    53
    I have found that going File, Options, Current Database that i can hide all the tool bars, navigation pane etc. This hides them upon opening the database. The shift key can be held down to over-ride this. This is what i was trying to do, but it would be nice to disable the shift key from over-riding this, and instead over-ride it by clicking the edit data button?

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I use this function to bypass the shift key. I would be careful using this thing. I use it on FE files that are copies of copies. So, after I bypass the shift key, I have no intention of returning.
    https://support.microsoft.com/en-us/kb/826765

  4. #4
    Torinjr is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    53
    Thanks,
    Any idea how I can use a button in a form, the same way that the shift key is used?

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I am not sure I understand the question. Obviously, you cannot click a button on a form during startup of the application. So I guess you are asking to change features that you have programmed to automate during startup.

    You might be able to change the name of your macro via VBA. Maybe this (never tried it before though).

    DoCmd.Rename "Autoexec_Not", acMacro, "Autoexec"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-19-2013, 10:21 AM
  2. disable editing options
    By smahdih in forum Access
    Replies: 7
    Last Post: 10-30-2011, 05:42 PM
  3. Switchboard with no toolbars - Oops
    By EDEd in forum Forms
    Replies: 1
    Last Post: 10-10-2010, 03:49 PM
  4. Allow Built-in Toolbars
    By DianeG in forum Access
    Replies: 0
    Last Post: 08-26-2010, 06:04 PM
  5. Customized Toolbars
    By croydon in forum Programming
    Replies: 4
    Last Post: 10-07-2009, 11:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums