How do I create a Text based Menu for a Database 1

[JamesBBB]

hi All,

Ive got a question about menubars, I have had a good look through tek-tips and read many articles, but am still at a loss.

Basically I want to be able to get rid of all the menu bars that contain icons, which is fairly easy.

But what is troubling me is I want to get rid of the menu items of text eg

File Edit view Insert etc etc

and replace them with my own text such as

Options Email Fault.

This is real easy in VB5, but in access, I am having major problems in understanding how to do it.

Can anyone please help me, preferably with any examples, as Ive tried some of the help examples and am not getting anywhere.

many thanks

James

 

[Remou]

An Advanced Search produced this:
Make customised menubar available to all users
thread702-1244228

 

[fneily]

Couldn't done to much searching. This will be the fifth time I posted these instructions.
Creating Custom Menus.
A) Create a Menu bar first
a. Click View, slide to Toolbars and click on Customize
b. Click the New button
c. In theToolbar Name box, type in a name (such as the database name) for your Menu bar
d. Move the blank new menu bar out of the way of the customize window.
e. In the Customize box, click the Properties button
f. In the Type box select Menu Bar
g. Click the Close button

B) Add some built in menus to your customize bar
a. In the customize dialog box, click the Commands tab
b. Select Built-in Menus in the Categories list
c. In the Commands list, click the File menu entry and drag it to your bar
d. Drag the Edit menu from the Commands list to your bar
e. Drag View, Records, Window and Help to your bar

C) Add your own version of the Tools Menu
a. In the Categories list, click New Menu
b. In the Commands list click New Menu and drag it to your bar
c. Right click the New menu , select the existing text in the Name box and type &Tools and then press enter
d. At the top of the Access window click the Tools menu.
e. Hold down the CTRL key and click the Spelling command. Drag it down to the Tools menu on your bar and drop it in the blank dropdown menu.
f. Repeat to bring the Autocorrect and Options submenus down to your bar.
g. With the right mouse, click the Options command on your menu and then click Begin A Group.

D) Add Another menu to your bar
a. In the Categories list, click New Menu
b. In the Commands list, click New Menu and drag the text to your bar
c. Right click the New Menu on your bar and in the Name box call it something pertaining to the database
E) Add custom menu commands to open forms in your application
a. In the Customize dialog box, click the Commands tab
b. Select All Forms from the categories list
c. In the Commands list, drag a form name to your new menu on your menu bar and drop it off. If you want to change the name to something more user friendly, right click it and type the name in the Name box
d. Let’s say the form finds a record of some type. You want to put an Icon on the menu bar. Steal the binoculars from the Find command by doing the following: Right click the Find button and then click Copy Button Image. Then click your menu and right click and click Paste Button Image.
e. Repeat above steps for the forms you want to use.
F) Tell your Form to use the created Menu bar
a. Drag the new menu bar to the top and dock it.
b. In the Customize dialog box, click the Toolbars tab and click on the check next to your new menu bar to hide it. You only want it to show when your form is opened.
c. Close the Customize window.\
d. Go to the Design view of your form and open the forms Property Sheet.
e. Click the Other tab of the sheet
f. Set the MenuBar Property to your menu bar.
g. Click the form view and check to see if it worked.

 

[TheAceMan1]

adding a little formatting for [blue]fneily[/blue]:

Creating Custom Menus.
[ol][li][blue]Create a Menu bar first[/blue]
[ol a][li]Click View, slide to Toolbars and click on Customize[/li]
[li]Click the New button[/li]
[li]In theToolbar Name box, type in a name (such as the database name) for your Menu bar[/li]
[li]Move the blank new menu bar out of the way of the customize window.[/li]
[li]In the Customize box, click the Properties button[/li]
[li]In the Type box select Menu Bar[/li]
[li]Click the Close button[/li][/ol][/li]
[li][blue]Add some built in menus to your customize bar[/blue]
[ol a][li]In the customize dialog box, click the Commands tab[/li]
[li]Select Built-in Menus in the Categories list[/li]
[li]In the Commands list, click the File menu entry and drag it to your bar[/li]
[li]Drag the Edit menu from the Commands list to your bar[/li]
[li]Drag View, Records, Window and Help to your bar[/li][/ol][/li]
[li][blue]Add your own version of the Tools Menu[/blue]
[ol a][li]In the Categories list, click New Menu[/li]
[li]In the Commands list click New Menu and drag it to your bar[/li]
[li]Right click the New menu , select the existing text in the Name box and type &Tools and then press enter[/li]
[li]At the top of the Access window click the Tools menu.[/li]
[li]Hold down the CTRL key and click the Spelling command. Drag it down to the Tools menu on your bar and drop it in the blank dropdown menu.[/li]
[li]Repeat to bring the Autocorrect and Options submenus down to your bar.[/li]
[li]With the right mouse, click the Options command on your menu and then click Begin A Group.[/li][/ol][/li]
[li][blue]Add Another menu to your bar[/blue]
[ol a][li]In the Categories list, click New Menu[/li]
[li]In the Commands list, click New Menu and drag the text to your bar[/li]
[li]Right click the New Menu on your bar and in the Name box call it something pertaining to the database[/li][/ol][/li]
[li][blue]Add custom menu commands to open forms in your application[/blue]
[ol a][li]In the Customize dialog box, click the Commands tab[/li]
[li]Select All Forms from the categories list[/li]
[li]In the Commands list, drag a form name to your new menu on your menu bar and drop it off. If you want to change the name to something more user friendly, right click it and type the name in the Name box[/li]
[li]Let’s say the form finds a record of some type. You want to put an Icon on the menu bar. Steal the binoculars from the Find command by doing the following: Right click the Find button and then click Copy Button Image. Then click your menu and right click and click Paste Button Image.[/li]
[li]Repeat above steps for the forms you want to use.[/li][/ol][/li]
[li][blue]Tell your Form to use the created Menu bar[/blue]
[ol a][li]Drag the new menu bar to the top and dock it.[/li]
[li]In the Customize dialog box, click the Toolbars tab and click on the check next to your new menu bar to hide it. You only want it to show when your form is opened.[/li]
[li]Close the Customize window.[/li]
[li]Go to the Design view of your form and open the forms Property Sheet.[/li]
[li]Click the Other tab of the sheet[/li]
[li]Set the MenuBar Property to your menu bar.[/li]
[li]Click the form view and check to see if it worked.[/li][/ol][/li][/ol]

See Ya! . . . . . .

 

[JamesBBB]

Hi fneily,

Thanks for the help, It was me, I didnt read the text the first time round hard enough, I just saw icons on my first attempt and then after you saying this is how its done, made me revisit the text and got it working.

Many thanks again

James

 

[Darrylles]

Hi,

Does this replace the APPLICATION level menu bar though?

I.E. Get rid of ALL menu-bars and replace File, Edit etc. etc with a cutomized bar?

ATB

Darylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.