Custom Menu/Shortcut bars

T

tmoore4748

I've creadted a database for the tracking of discrepancies found on
aircraft, gotten it fully running, made a switchboard , the works. I've
even managed to figure out how to hide the database window and show only the
switchobard and the items it opens. But, I've got a new problem: I want
users to have only open and close capabilities, not modifying the structure
of the database, unless they're some type of administrator. How do I cread
menu bars and shortcut bars for that purpose? It seems I am able to select
them in the startup window (the same one that allowed me to hide the
database window), but I have no idea how to create the menus I want. Any
ideas???
 
6

'69 Camaro

You can create a custom command bar (command bars now include both menu bars
and toolbars in Access) very easily. Please see the "How to add a custom
button on the command bar to run code on a form" tutorial on this Web page:

http://www.Access.QBuilt.com/html/forms.html#CustomCmdBar

This tutorial instructs how to create the command bar and add a custom
function to that command bar. However, the custom command bar does not
require custom functions, since one can easily drag items (such as menu
items and toolbar buttons) in the list box within the "Customize" dialog
window to the custom command bar to add whatever Access built-in
functionality you may need.

You can also create your own shortcut menus, but many developers just set
the Form or Report Properties that limit what the user sees on the default
shortcut menu, such as the "Allow Design Changes" set to "Design View Only"
to prevent the "Properties" dialog window from being opened in "Form View."

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
A

Albert D. Kallal

You should consider turning the file into a mde. Users cannot get access or
change the designs when you make a mde.

So, a mde file is designed for deployment to each user (by the way...for
maintains, and a proper setup..you should be using a split database).

You can read about that here:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

And, if you want a small sample application that hides all of ms-access, you
can try downloading the 3rd example here:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

If you run the above...you will see that I just used tools->startup to hide
all of the ms-access interface..and you can't modify or see what is inside.

And, if you want a nice tutorial on creating menu bars, here is a nice link:

http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm
 
Top