Results 1 to 3 of 3
  1. #1
    rich is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    Location
    St. John's, Newfoundland
    Posts
    14

    Restore menus?

    Is there any way to restore menus/editibility when they have been removed using ACCESS OPTIONS > CURRENT DATABASE then uncheck 'allow full menus'? Database was created in Access 2007. I always keep a back up of the pre-menu-disable state of my databases, but this is someone elses for which I can't find a backup.

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    1. Open the Database
    2. Open the VBA Editing Window (Alt+F11)
    3. Copy and paste the following Code into a VBA module.

      Code:
      Public Function FullMenus()
          CurrentDb.Properties("AllowFullMenus").Value = True
      End Function
    4. Place the insertion point in the middle of the code.
    5. Press F5 to run the Code.
    6. Close the Database and Open it again.

    Full Menus will be available now.

  3. #3
    rich is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    Location
    St. John's, Newfoundland
    Posts
    14
    Beautiful!

    Thank you so much.

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

Similar Threads

  1. Can System Restore correct Form Size issue
    By fordtough in forum Forms
    Replies: 0
    Last Post: 04-12-2011, 02:56 PM
  2. Access Menus
    By FadingAPE in forum Access
    Replies: 5
    Last Post: 11-16-2010, 09:11 AM
  3. Dropdown menus
    By Mclaren in forum Forms
    Replies: 2
    Last Post: 08-17-2010, 12:30 PM
  4. Access DB backup & restore
    By paulfr in forum Access
    Replies: 1
    Last Post: 09-09-2009, 04:07 AM
  5. How to restore Find dialog in Access
    By AndyKim in forum Access
    Replies: 11
    Last Post: 06-25-2009, 11:28 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