Customizing Database Menus

[glen]

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

[June7]

On the ribbon:
File > Options > Current Database > choose settings as desired.

Review http://forums.aspfree.com/microsoft-...at-303789.html

[glen]

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.

[June7]

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.

[glen]

Thanks for your help.

[glen]

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?

[June7]

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.

[glen]

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?

[June7]

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.

[glen]

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.

[June7]

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

[glen]

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.

[June7]

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.

[glen]

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

[June7]

Review
http://www.access-programmers.co.uk/...ad.php?t=51479
http://forums.aspfree.com/microsoft-...me-206240.html
http://forums.aspfree.com/microsoft-...7t-327136.html