Creating Customized Menu Bars

Aug 4, 2005

Greetings.

I am pulling my hair out trying to create a customized menu bar. Eventually, I want to have a customized menu bar and tool bar for report and different customized menu bar and tool bar for forms. I created the tool bar for the report window. Then when I tried to create a new menu bar I could not remove menu selections without removing the same menu selections from the default Menu Bar.

I selected View->Toolbars->Customize...
Then I clicked on New (command button)
Then I named it (RptMenuBar)
Then I selected 'Built-In Menus' from the Commands Tab
Then I dragged the 'File' from the Command list into the new Menu Bar
Then I went to the new menu bar and dropped down the selections under File and started to left click and drag what I didn't in the NEW MENU BAR. However, it turns out when I did that the same selections were removed from the default Menu Bar.

I was ablel to restore the default Menu Bar. But I want to have a customized Menu Bar and be able to select that new Menu Bar and associate it with every Report that is in my Database.

Any ideas? If you have some good instructional references, please point me in that direction. Thanks.

SueB

View Replies


ADVERTISEMENT

Tool Bars / Menu Bars - GONE

Apr 20, 2006

Help! I'm not sure how I did this, but NO matter what database I go into i can see any toolbar or menu bar. Yes I tried the shift key. How do I turn it all back on?
When I right click I can get the database startup properties, everything has the check, yet I can't see any toolbars or menu bars. I've searched though the help, and I can't see to find out how to put it back.

View 14 Replies View Related

2 Customized Menu In One Database

Nov 5, 2005

Hi,

I have seen a MDE Access db last week with 2 new things in it

1. The db had 2 customized menu (1st one was in English and Second one
was in Local language). There was small button on customized menu bar called 'E' by clicking of which the whole customized menu was
replaced by English menu bar. In fact the db was created for bilingual
user. There was only one customized menu bar at a time. Means if you click command button 'E' it was replacing the local language menu bar with English bar and if you click 'E' second time (This time the button caption is in local langauge), the English language menu bar was re-appearing

2. When the user clicked to change menu to English, all the forms and
report captions turned into English.

It was very new thing for me.

I am interested to apply the same tricks in my db so the user can
handle my db in local language even if don't know English well.

I would be grateful to If somebody amongst you know and donate to our
access family in a sample db (At least replacing menu trick) ...

Thanks,

With kind regards,
Ashfaque

View 3 Replies View Related

Turn Menu/tool Bars On & Off

Jul 15, 2005

What is the best way to turn all the menu bars and tools bars off and back on when a form opens and closes? Can you just loop through the numerated objects?

View 14 Replies View Related

Disable All Menu Bars Except The Right Click Mouse

May 1, 2006

Hi,

For i = 1 To CommandBars.count
If (CommandBars(i).name <> "Right Click Mouse") Then
CommandBars(i).Enabled = False
End If
Next i

I tried to use this code.
However, right click mouse is disable.

How can I disable all menus except the right click mouse option?

Thanks.

View 1 Replies View Related

Creating Customized Serial Primary Key

Nov 20, 2013

I want to create Customized Serial Primary Keys and dont know how to go about it.

View 7 Replies View Related

Forms :: User View - Reduce Amount Of Options On Menu Bars

Aug 15, 2013

I have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?

View 1 Replies View Related

Forms :: Command Bars Custom Shortcut Menu - Font Color Picker

May 15, 2014

I am currently in the process of creating a pop-up menu to allow my users to do some simple text formatting.I have used the following code to do so:

Code:

Dim cmbShortcutMenu As Office.CommandBar
' Create the new pop-up menu instance
Set cmbShortcutMenu = CommandBars.Add("popupFormatMenu", msoBarPopup, False, True)
' Add the bold button

[code]....

The problem is that I now want to add the FontColor picker control and I keep getting an error.I think the problem lies in the type of control I want to add. According to the Microsoft support files I downloaded the fontColor control is of type Gallery and ID = 11949, so the code should look something like this:

Code:
cmbShortcutMenu.Controls.Add Type:=msoControlButton, id:=11949

I need to replace msoControlButton with something else.

View 1 Replies View Related

Creating A Switchboard (main Menu)

Sep 9, 2005

I have recently created a small inventory database just for fun, but I am looking to expand my knowledge with Access since I have not dealt with it hardly at all. I would like to know how to create a regular main menu to the database that gives you options on what you want to do. I would like to be able to look up inventory by serial number, edit inventory, add inventory, and run reports from the main menu. If anyone could help, I would greatly appreciate it.

View 1 Replies View Related

Creating New Ribbon With Drop Down Menu?

Jun 2, 2014

How I can create my own Ribbon which include drop down menus?

View 3 Replies View Related

Creating Drop Down Menu In A Form

Aug 6, 2015

In the Lesson 22 tutorial presented here: [URL] .....

They create form where the called Countries toward the end where:

The have a textbox for Government Type. It is a drop down menu of choices that the database creator can choose such a capitalist, socialist, and communist etc.

However, in the form (with the records source as Countries) there is only a space for input no drop down menu. I know this may seem awful elementary to the seasoned database designer, but how does one get it to be a drop down menu?

I have made the input in Countries table to be a look-up which I typed (see above choices) and the is the control source for the Countries Form government type. But there is still no drop down menu with choices on the Countries form. What must I do additionally?

If this is already talked about in one of the MS Access 2010 tutorials earlier lessons then a referral to that source is all that is needed.

View 4 Replies View Related

Modules & VBA :: Creating A Custom Shortcut Menu

Jun 5, 2014

I'm working to put together a shortcut menu for a form that will be viewed as a datasheet. I'm trying to put together the vba to create the menu. I'd like a lot of the standard options i.e. sort a-z, filter toggle etc. I'd also like to add the menu option that is displayed in the default menu called "Text Filters". I've been unable to find the id code for that option, and since it, when chosen opens another menu, I'm not real sure how to code it. Here is what I have so far:

Sub CreateWIPShortcutMenu()
Dim cmbRightClick As Office.CommandBar
Dim cmbControl As Office.CommandBarControl
' Create the shortcut menu.
Set cmbRightClick = CommandBars.Add("cmdWIP", msoBarPopup, False, True)

[code]....

View 2 Replies View Related

General :: Creating Custom Menu Bar For Form?

Jul 2, 2012

i would like to create custom menu bars for my forms report

View 6 Replies View Related

Forms :: Creating Report Menu To Allow User Filters

Aug 26, 2013

I have been tasked to create a report menu for my users to select a report (there are about 20), select which filters that they want to apply to that report, then run based on what the user selected as the filters.

I have about 30 different filters to create, and based on which report the user selects, the filters that apply will need to be shown. I'm thinking the reports will be in an option group, and based on which report the users selects the filters that apply to that report will be displayed. From there the user can choose to apply a filter or not, and run the report.

I am trying to figure out the best way to tackle this. Should I try to create a table that contains the report name and type of filter to loop thru the controls to set visible, and build the SQL?

View 6 Replies View Related

Modules & VBA :: Creating Custom CommandBarControl Objects For A Shortcut Menu?

Aug 16, 2013

I finally got tired of having 100 macros managing my different custom shortcut menus, and decided to figure out how to generate the shortcut menus programatically (because lets be honest, Macros are the devil.)

I found a good tutorial here : [URL] .....

and was able to create some basic shortcut menus like the following:

Code:
Sub CreateCopyShortcutMenu()
Dim cmbshortcutmenu As Office.CommandBar
Set cmbshortcutmenu = CommandBars.Add("CopyShortcutMenu", _
msoBarPopup, False, False)
'ID 19 adds copy command
cmbshortcutmenu.Controls.Add Type:=msoControlButton, Id:=19
End Sub

Nice and simple, now I have a copy command. But the problem is that I also need some custom commands. Most (possibly all?) of these would be function calls.

View 3 Replies View Related

Customized Msg Box For User Security

Dec 20, 2006

Hello everyone.

Not sure if this is possible...but I hope it is!

I have created user security with limited access for specific groups to certain forms in my database.

However, when a user attempts to open one of the restricted forms a Generic Microsoft Access Message Box opens. Am I able to customise this box so that the box Heading is not "Microsoft Access" and so that the user is not offered the option of "Help"?

Really all I want is a box that says;

"You do not have the permission to open this form."

I only want an "Ok" box as an option (not the "Help" box as well)

Any help would be extremely grateful.

Thanks in advance,

Rob

View 2 Replies View Related

Autonumber With Customized Prefix

Dec 28, 2004

Ok...I've looked at old threads and now I'm more confused than before.
I'm trying to find a way to make my field "PCRTrackingNumber", work like this: 05-0001...05-0002...05-0003...and so on. The 05 represents the year. I currently have the field setup as autonumber, set to Long Integer and increment. Even if it looked like 05-1...05-2...05-3...etc. that would be fine. Basically just looking for a way to add "05-" to the prefix.
I was trying to think of a way to combine a field to the autonumber field and use that instead...but need some help.
Thanks, Jeff

View 2 Replies View Related

Customized Primary Key With Auto Number

Oct 6, 2004

Hello,
I am a beginner and know a little about access. I am trying to create a customized Primary Key with an auto number. I want it to look like this: VP001 ,next record, VP002 and so forth. When I enter a new record and want it to do this automatically. It could be VP1, then VP2, I don't need the extra zeros but it would be nice. I don't know how to do this. If someone could please help walk me through this. Remember I am a beginner with databases and need help.

I would appreciate it

Thanks
Biz

View 2 Replies View Related

Forms :: Dealing With Customized Subforms

Jun 25, 2013

I have a form that I designed that contains two subforms.The first subform is an entry subform so you can post the current client visits.The second subform I want to just display all prior client visits and make updates or deletions if needed.

It does not appear that I can make the first subform entry= yes additions allowed=YES in the properties.The second subform I want entry=No and addition=no..When I pull up the properties sheet for each of the subforms these options do not appear. They appear only on the main FORM, FORM property sheet. I thought I could create two new forms with the properties I desire and then copy them into the main form.

View 5 Replies View Related

Sending Customized Emails On Update

Jan 19, 2012

I have designed an Access database with a certain table called EmailAlerts.

This table has two fields: EmailMessage and Recipients.

The EmailMessage field stores the body of the mail to be sent to the corresponding email addresses in Recipients. E.g.:

EmailMessage | Recepients
Hello | abc@xyz.com
Goodbye | pqr@xyz.com

Now what I want to do is, whenever a record is added to this table, I want to send the email to the corresponding recipient. How can I do this?

View 5 Replies View Related

Email Record From A Form In Customized Layout

Sep 13, 2006

when a record is open in my form, i want a button that says.. send email confirmation..

this will then transfer particular fields to an email template and send the email

how can i begin to understand how to make this work

View 14 Replies View Related

Modules & VBA :: Saving Picture To Specific Folder With Customized Name?

Feb 8, 2014

I have below module to save picture under named folder:

Code:
Option Compare Database
Public Enum acFileType
acPicture = 1
acFiles = 2
End Enum

[Code] ....

But how to save the picture with customized name, say "Materials 0001.Jpg"

View 7 Replies View Related

Customized Error Message Pop Up If Entered Data Is Invalid

Mar 8, 2014

I'm just trying to implement a "customised error message" that will pop-up if data is entered and it's invalid. (I've created a "query" and a "search" form which these two link together).

View 3 Replies View Related

How To Show A Full Menu On The Menu Bar

Feb 19, 2007

Hi everyone,
I was trying out the options on the startup item of the tools item on the menu bar and my access window has gone except the following menu items: File,Window and Help.
Can someone kindly show me how to bring back these seemingly lost items?
Thank you for your willingness to help me out!

View 2 Replies View Related

How To Hide All The Bars

Jul 28, 2007

How can I remove all the bars specially the menu bar:
File, Edit, View, Insert,...

View 3 Replies View Related

Scroll Bars

Nov 7, 2005

I'm trying to auto scroll the Detail Section where the user will able to see the last record on my continuous form.

Can anyone tell me how to do this?

My sincere thanks!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved