Results 1 to 2 of 2
  1. #1
    casinc815 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2013
    Location
    Chicago, IL
    Posts
    46

    Thumbs down Form Locked, Ribbon hidden, Property sheets unavilable.

    My family came back from vacation and while away the mice played.
    Those lovely mice are teenagers in high school and they got into trouble
    with MS Access.

    It appears that before I left for vacation we spent a week discussing


    security of applications and use of runtime versions.

    Now, I seem to have inherited a problem. The student's place code in
    the OnOpen event of the Switchboard that locked the applications's property sheets
    and minimized the ribbon. By doing so, this method cascaded throughout
    all of our Access applications and now development has come to a hault
    for we do not have property sheets or a ribbon to work with.

    When starting an application, I hold down the [SHIFT KEY] hoping to bypass
    the problem to get into the event on the open form to comment out or remove
    the evil code. Then I should be able to save, close and restart the application.
    The bypass key allows viewing of the ribbon but the property sheet, and well,
    all functions are frozen. The navigation pane is open and you can view all controls
    but their is no design function available.

    This is starting to not look good and a lot of work will probably have to be done.

    Any advice is deeply appreciated.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    What are the file extension of the files you are trying to open?

    There are global settings you can make to the Application that is Access. However, what you are describing should be specific to the client DB and not effect every file you open because code in one file was altered.

    Alternatively, I could write some script and place it at your drive's root that would cause the symptoms you are describing. Hopefully they did not employ Access and switches and only changed the extension. Did you notice a change in the file size of your DB's?

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

Similar Threads

  1. Form missing in Navigation Pane (not hidden)
    By Merganser in forum Forms
    Replies: 7
    Last Post: 09-11-2014, 06:55 PM
  2. Property sheets
    By RickyBeau03 in forum Programming
    Replies: 4
    Last Post: 12-20-2013, 04:01 PM
  3. Replies: 2
    Last Post: 12-28-2012, 02:28 PM
  4. Replies: 0
    Last Post: 01-18-2011, 07:09 AM
  5. Replies: 3
    Last Post: 11-24-2010, 09:50 PM

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