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.
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.
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) ...
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?
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?
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:
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.
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.
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)
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?
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.
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)
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
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 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.
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).
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!
