Results 1 to 15 of 15
  1. #1
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171

    Customizing Database Menus

    Hello,


    I created one test database.
    I hide the ribbon.But the file and quick access toolbar still visible.
    How I can hide these menus?
    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    On the ribbon:
    File > Options > Current Database > choose settings as desired.

    Review http://forums.aspfree.com/microsoft-...at-303789.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171
    June, after study this article http://www.access-freak.com/tutorials.html#Tutorial05 I created one sample database.it working fine.
    But I don't understand this custom button " Click me " function.
    what is his function?
    and why it give error?
    Thanks.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    The button is just a demo of customized ribbon and is supposed to simply trigger a message box. You would have code in the OnButtonPress event to do whatever you wanted, such as open a form or report.

    I can't see anything wrong with the programming and don't understand why the call back won't trigger. It does work in the sample database attached to thread I referenced in post 2. Download it and see if it works for you.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171
    Thanks for your help.

  6. #6
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171
    June Plz you check this sample login database.
    here without login or close form I cannot go inside database.
    Please you check and tell me that what code or procedure is used in this?

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    What do you mean by 'cannot go inside database'? If you don't want the default form to load and code to run when you open db, hold down shift key while the file opens.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171
    I mean that this is a sample database.
    I downloaded it from some website.
    when the database start then without login I cannot open table or form or use some menus until I put user name and correct password.
    But in my database which I made there I can open any table, form without login.
    so I want to know how it possible?

  9. #9
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    Hold down the shift key when file opens. This will override the defaults. Modify database as you wish, even remove the default form from database startup options.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171
    Sorry, due to my poor English I can't explain that what I want.
    I don't want to override the defaults.
    In pic 01 there is sample Login form which I download from some website.
    In this case if I not login and I want to try click outside from login form so I can't allowed outside from login form.
    So I want this procedure that how it possible that untill I am not login My mouse click should not work outside from login form.
    But in other case in my database.
    My login form is still on screen and I didn't login but my mouse click is work outside from login form.
    I want to avoid this that untill I not login my mouse click should not work outside from login form.

    Hope you will be understand now.

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    Disabling mouse click might be possible but I don't recommend it. If you don't want users to use the navigation pane or shortcut menus, then use project settings and code to prevent that. Post #2 references a link with example of how to do that. Here is another http://office.microsoft.com/en-us/ac...010341516.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  12. #12
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171
    Thank you June.
    But at last I found the setting for which I was searching.
    look in pic. after changing these setting into yes I get the thing which I want.

  13. #13
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    Modal will keep user from do anything else until form is closed but then they can interact with navigation pane. You want to permit that?

    Also, modal setting is a nuisance when developing database, it interferes with debugging. Don't set forms as modal until you are confident code is working properly. I seldom use the property.
    Last edited by June7; 09-25-2012 at 05:08 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  14. #14
    glen is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    171
    Ok thanks.
    Mainly I am working now a days on customizing Ribbons and Menus.
    But after seeing that Login sample database which I attached here I was curious that what procedure is used here.I was thinking that there is something coding for this but then I checked properties of that form with my login form so I noticed this.
    I am very happy bcoz you are helping me and I am really improving in access.
    But the main problem for me is VBA coding.it is little bit complicated for me.
    and secondly I hided all ribbons and menus from my database but I don't know how to remove file menu.
    I want just blank database showing only login form.
    and secondly how to disable and enable Shift key that while holding shift key no one can override my database.
    Thanks

  15. #15
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625

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

Similar Threads

  1. Customizing the Autonumber field
    By wasim_sono in forum Access
    Replies: 3
    Last Post: 10-24-2014, 03:00 PM
  2. VBA code menus
    By redbull in forum Programming
    Replies: 2
    Last Post: 08-13-2012, 02:41 PM
  3. Customizing the Northwind Access Template help required
    By JulieBright in forum Database Design
    Replies: 12
    Last Post: 04-02-2012, 08:58 PM
  4. Restore menus?
    By rich in forum Access
    Replies: 2
    Last Post: 08-09-2011, 10:10 AM
  5. menus are lost
    By eddwads in forum Access
    Replies: 2
    Last Post: 01-08-2010, 08:34 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