Change Menu Bar In VBA
Feb 9, 2005
Can someone provide me with direction on changing the menu bar in VBA? I have 2 menu bars 1) the default "Menu Bar" in access and 2) a custom menu bar "custom 1". I am using Access 2000 and am attempting to change the menu bar, but it reverts back to which ever one I have listed in my database startup options for Menu Bar.
I have an autoexec macro that runs a module that checks to see who the current user is. Based on the current user, I want the menu bar to change accordingly. An example of my code is:
If CurrentUser() = "User A" then
DoCmd.ShowToolbar "Menu Bar", acToolbarYes
DoCmd.ShowToolbar "Custom 1", acToolbarNo
Else
DoCmd.ShowToolbar "Custom 1", acToolbarYes
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
End if
There are no startup options checked. This module is the only place where I am referencing the toolbar. I cannot see anything that would cause it to revert back to the menu bar option listed in the start up. Any suggestions?
View Replies
ADVERTISEMENT
Aug 6, 2014
I have a database that was created in Access 2003. I'm using this MDB in Access 2010.I need to change a user created menu. The update involves changing an existing entry and adding a new menu item. The menu looks like:
Project
Time Entry
Time Spread
I need the "Time Spread" to change to "Time Spread Daily" with a changed macro name. After that a new menu entry is "Time Spread Monthly". This menu will run a new macro that will display a form.I think the only way to do that in 2010 is to use VBA.
View 1 Replies
View Related
Oct 9, 2007
Hi All,
If it is possible to change the format properties of a menu/toolbar could someone please point me in the direction of some guidance/ let me know how to go about it I would appreciate it.
Specifically I'm trying to change the menu bar's /database window's property to match my forms (and company branding).
I've Googled various phrases in both UK and US spellings (to be on the safe side) and searched a few forums (this one included) and cannot find much beyond creating customised menu/tool bars.
Many thanks
View 1 Replies
View Related
Oct 14, 2013
I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to select more than one of the options in the form of checkboxes. This is not what I intended.
I've attached to pictures to demonstrate the problem. The first is ComboBoxQuery (the one with the problem) and the second is ComboBoxQueryWorkign (the one without a problem).
I'm not sure why this is happening and I've tried comparing all the properties of both these combo boxes and changing some of them to see if I can eliminate the problem without any joy.
I use a very standard SELECT statement to pull the data for the combo box:
SELECT CountryID, CountryName FROM tblCountryInfo ORDER By CountryName
View 7 Replies
View Related
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
May 15, 2006
Ok, This is something I have long wanted to do, but cannot figure out.
I am working on a database for a company that orders a large number of Items. I have these all in one table (itemCode, itemDescription, price, categoryCode, etc). I have another table with categorys (categoryCode, categoryDescription) . Each Item is asigned a categoryCode and the appropiate relationship exsists. Right now I have a comboBox in a form that when selected opens a drops down menu with all the Items. Then another one auto loads up (continuous form) and I get the same drop down list of all the Items.
What I would like to have is a combo box then when it is selected shows the categorys, then based on that selection, I see all the Items that are in that category.
I guess another way of saying this simply is, I would like to create a drop down menu inside of a dropdown menu.
Is this possible? Does anyone have another alternative suggestion that might work well? I'm relectant to use a list box, becoase ideally it would be a drop down menu inside of a drop down menu as seen on many websites.
Thanks in Advance!
:)
View 2 Replies
View Related
Apr 5, 2014
I am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form
2346 location warehouse price 29.99 (button - green)
2347 location shop price 29.99 (button - red)
View 1 Replies
View Related
Jul 2, 2005
I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?
Thank you very much for help.
View 2 Replies
View Related
Dec 9, 2005
Before anyone get to upset with me I did search the board looking for the answer but only got more confused. I found the code I wanted to shut down the toolbars and menu bars but I need to allow the print options on the menu bar. How do I allow the menu bar up but only allow printing ?
jon
View 4 Replies
View Related
Apr 4, 2006
I have this code in the opening for of my database but the tool bar "passdown" does not open. Could someone please help me understand why?
thank you
jon
Private Sub Form_Open(Cancel As Integer)
ChangeProperty "StartupForm", dbText, "Frm-UserLogon"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
DoCmd.ShowToolbar "passdown", acToolbarYes
End Sub
View 2 Replies
View Related
Oct 3, 2006
Hi,
I have a question.
I create a custom menu, and then assign hyperlink for running Excel application (C:Program FilesMicrosoft OfficeOffice10EXCEL.EXE). When I click on it, it has security message,
/////////////
Opening C:Program FilesMicrosoft OfficeOffice 10Excel.EXE
Some files can contain viruses or otherwise be harmful to your computers. It is important to be certain that this file is from a trustworthy source.
Would you like to open this file?
''''''''''''''''''''''''
How can I erase this security message? Thanks.
View 1 Replies
View Related
Feb 8, 2007
I was trying to change the form that appeared on Load by going to Tools>Startup and changing the settings there.
However now I have lost most my my menu bar i.e. Edit, View, Tools etc. I only have File, Window and Help. :eek:
How do I retrieve the menu bar in its original state?
View 3 Replies
View Related
Mar 1, 2008
In my access 2003 the principal menu is not more visible.
I have used the command:
CommandBars ("Menu Bar"). Visible = True
but it doesn't make to appear the menù.
What can I do?
View 2 Replies
View Related
Aug 10, 2005
Hello,
I was wondering if there is a way that I can create a 'message' that will appear whent he mouse is scrolled over a button. I have command buttons that launch my reports but would want the user to know what fields are included in each report...therefor, they can put the cursor ontop of a certain button and a small list will show them what is in that specific report
Cheers :)
View 4 Replies
View Related
Apr 29, 2006
I have a question of creating a few menu bars.
I made 3 menu bars.
When the user log in the database, the database program will detect the user name, and then output his own menu bar.
It works fine.
However, I got a problem, when I created the first menu bar, the menu bar have control box for the forms, the other 2 menu bars do not have it.
How can I make 3 menu bars with control box, minimizs, maximinize, close form boxes?
View 1 Replies
View Related
Aug 25, 2006
Hello, I have created my own Menu bar in access and would like to add sub menus to it.
Any help? Thanks.
View 3 Replies
View Related
Jun 27, 2005
I could not find Menu design in Access...Is it available during design time?
When I searched for it I found AddMenuItem to programatically add menu...
I vaguely remember seeing menu design in VB 3.0 7 years ago...I am looking for something similiar..
This probably the simplest and stupidest question..please excuse me for that.
Thanks
View 2 Replies
View Related
Aug 4, 2005
I was just editing my Access database (stored on the intranet) when a message popped up saying "Disk or network error".
I clicked the only option ("ok") and closed the DB. When I reopened it, it said someone else was viewing it and I only had read permissions. I close it again, and see that in the directory where my .mdb file is stored I have the .ldb file remaining even though it isn't open.
I restart my machine, and try and open it again. I have to compact and repair the DB at Access' suggestion, yet now I only seem to have limited functionality....??
I.e. there is no Tools menu, I can't right click on forms or tables to choose Design View (although if I highlight them in the database pane and click the BUTTON for Design View I am able to proceed)....
What's going on?!!
I've tried going to File > Open and in the little arrow on the Open button choosing "Open Exclusive", but it opens and does the same thing as above...!!
I've checked a different database in Access, and I don't seem to have gone potty, in every other one I'm able to see the Tools menu, etc...?
Anyone got any clues as to how I can get my lovely database back on its feet and functioning properly? :confused: :eek: :rolleyes: :mad:
View 5 Replies
View Related
Jan 3, 2006
:confused: hi ,,,
i have this Microsoft Application and i have unchecked the check box (Allow full menus ) in the starup ... So when ever i run the application i only get
the menu bars : File, Window, Help, AdobePDF
how can i get the other menu bars ?
any suggestions
thankx:o
View 6 Replies
View Related
Mar 23, 2006
Hi,
I created my own menu bar in one MS Access file, let's say db1.mdb.
Can I import it to another database file (let's say db2.mdb)?
Thanks.
View 1 Replies
View Related
Apr 24, 2006
Greetings,
I have just opened Access and for some reason my menu bar is gone. I have fiddled for a few minutes try to find and restore it - but I am clueless. It is working fine in all other programs.
How do I restore it?
~rbinder
View 2 Replies
View Related
Apr 26, 2006
Hello,
I do not want any menu bar in some application I have made using a switchboard. In the start-up function I unchecked all the checkboxes but some menu functions keep coming back. How can I overrule this?
View 5 Replies
View Related
Apr 13, 2007
I am about to create the menu (navigation) structure for my system but wanted it to be fancy. Anyone got any suggestions or GOOD websites that have different menu types. any help/suggestion would be appreciate!
View 1 Replies
View Related
Apr 25, 2007
Ok i admit i think ive done a really stupid thing here.
In my database on the start-up menu (tools > start up) i have disabled all the menus as well as menu bars and short cut menu bar and toolbars.
However now i need to change information about the start up...
How would i go about this?
Much Appreciated
Ben
View 1 Replies
View Related
May 21, 2007
I craeted a startup menu and unchecked all the backend functions - now I cant getinto design view - what should I do?
View 14 Replies
View Related
Aug 10, 2007
I was in the startup options and unchecked a couple of toolbar boxe and now I dont have a full menu any more.
Please help
View 6 Replies
View Related
