Dependent Drop-down Menus Not Working
Jul 17, 2007
Hi all,
This is my first time posting at Access World Forums and I hope you can help me out.
I think this is a fairly simple problem but due to my lack of experience (this is actually my first time using Access) I am unable to figure out what is wrong.
I have a entry form for a series of problems that needs to be documented on the plant floor.
The issue is in the 'Manual_Entry_Rewinder_Detail' form where I have two drop-downs -one for the category of which the problem lies and another drop-down for the actual problem itself. I have made (or tried to at least) make the problem drop-down dependent to the category drop-down. The purpose is to list only the relevant problems after the category is selected.
I have made a category ID of which I labelled for each problem. This of course corresponds correctly to the actual (an existing) category ID. Please take a look at the two tables: "Problem" and "Category" for details.
I followed this tutorial http://www.blueclaw-db.com/download/dependent_combo_box.htm .
I even downloaded and inspected their sample database with no idea on what is wrong with my own.
Please help!
View Replies
ADVERTISEMENT
Oct 11, 2006
I can't figure out how to create drop menus in design view in a table. I put the option in the toolbar but its gray so I can't use the option. I have followed the wizard and its not working so I am doing something wrong!!
View 1 Replies
View Related
Aug 9, 2007
I've tried to build a second Drop menu, copying the code from the first. When i run it im getting an error 91 (i didnt understand much of what google said on it) the code is as follows:
I tried changing it to btnInput1, but that hasnt helped :( the menu gets built, but the button does not.
Sub BuildAdminMenu()
Dim mnuInput As CommandBarPopup
Dim btnInput As CommandBarButton
Dim btnInput1 As CommandBarButton
Set mnuInput = Application.CommandBars("Menu Bar").Controls.Add(Type:=msoControlPopup, Temporary:=True)
mnuInput.Caption = "&Options (beta)"
mnuInput.BeginGroup = True
mnuInput.Visible = True
mnuInput.Tag = "Build XML Files Menu"
Set btnInput = mnuInput.Controls.Add(Type:=msoControlButton, Before:=1)
btnInput.FaceId = 2761
btnInput.OnAction = "openForm"
btnInput.Caption = "New PR/IEWO"
btnInput.Style = msoButtonIconAndCaption
Set btnInput = mnuInput.Controls.Add(Type:=msoControlButton, Before:=1)
btnInput.FaceId = 2761
btnInput.OnAction = "openSearch"
btnInput.Caption = "Search Entries"
btnInput.Style = msoButtonIconAndCaption
Set mnuInput = Application.CommandBars("Menu Bar").Controls.Add(Type:=msoControlPopup, Temporary:=True)
mnuInput.Caption = "&AdminOptions (beta)"
mnuInput.BeginGroup = True
mnuInput.Visible = True
mnuInput.Tag = "Build XML Files Menu"
Set mnuInput = Nothing
Set btnInput1 = mnuInput.Controls.Add(Type:=msoControlButton, Before:=1)
btnInput1.FaceId = 2761
btnInput1.OnAction = "openAddUser"
btnInput1.Caption = "Add User"
btnInput1.Style = msoButtonIconAndCaption
View 1 Replies
View Related
Sep 12, 2014
I would like the user to enter information directly into an Access table (it's ok). I want one column to have month ended. In this column, there would be a drop down/lookup menu with each month of the year. The user selects the month we are being billed for.
Then another column called week ending date, would display all week ending dates (ends on a Sunday) but only for the month that was selected.
If the user selected another month on another row, the available weekending dates to select from would show only what pertains to the month selected. Is it possible to do this?
View 2 Replies
View Related
Jan 31, 2014
I have a number of drop down menus to select Building Name, Building Number and then Equipment Name and Equipment Number. I want the list to be linked so that when you select the building name the building number is picked up. Also I want the Equipment List's with to change so that once the building has been selected only the equipment available in that building is available to be selected. Is there a way I can do this?
View 3 Replies
View Related
Jul 24, 2014
I have made a database. I have gotten to the point where I use a form to get the information. I am trying to get the information to auto populate fields after using 3 drop menus. They are department name, shop and shift. All of the information comes out of tbl department name, tbl shop and tbl shift.
I also have a table with department name, shop, shift, line, employee total, shift leader total, ratio of shift leaders per line and total employees off. I am trying to figure out once use the 3 drop down how can I Auto populate the remaining fields. Also I am trying to figure out where and how to put in the code.
View 1 Replies
View Related
Aug 18, 2013
I have 2 combo boxes, one Categories and Products. However I have follows a tutorial and when I select the Categories, the products do not show even though the tutorial says it does. I have attached a copy of the DB.
View 4 Replies
View Related
Jan 7, 2014
I have a textbox that has 3 columns in it (Rank, First Name, Last Name)...when the user selects the appropriate choice, it just shows the Rank.
Ex: Lt. John Smith --> just shows Lt.
To get around this I made an unbound text box and have it set to show all three choices when the selection is made in the drop down box. Unfortunately, it isn't working right. This is the code I am using for the text box:
=[OPRID].[column](1) & [OPRID].[column](2) & [OPRID].[column](3)
Is there anything that looks wrong with this code?
What it ends up showing in the text box is: JohnSmith (no rank, no space between the names).
View 3 Replies
View Related
Jul 24, 2012
Is there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?
View 1 Replies
View Related
Jun 18, 2013
I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc
View 2 Replies
View Related
Jan 18, 2006
I was curious,
How do you add a Menu to a form? Like is there a way to have a Main Menu bar and add the individual menus/menu items with custom events? As well can i cusomize the context menu for the form, or make a popupmenu that is executed upon clickin a command button?
There is a lot of help on how to attach menus to properties and such, but I can't find an item "Menubar" in the access interface.
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
View 2 Replies
View Related
Apr 13, 2006
I have an application that hides all the normal Access menus, so that the user can only use the buttons that I have put on the screen forms. Now however, when I open up access, I cannot get to any of the Access menus. It shows the toolbar, but not the normal FILE/EDIT...TOOLS/HELP menu.
How do I toggle this back on? Everything I have been able to find so far tells me to go to the TOOLS menu ---- I cannot get to the TOOLS menu.
Thanks. BTW, I am not really as stupid as this post makes me sound.
Mike Redmond
View 6 Replies
View Related
Jun 26, 2005
I'm sure there must be a simple answer to this question but I have been unable to locate the answer.
I recently finished a database program under Access 97 and unchecked the boxes to allow menus. Now I need to fix a few mistakes and need to access my code or the menus to do this. Is there a way to get access to my code.
Any help would be appreciated.
Thanks
rtamd
View 2 Replies
View Related
Mar 16, 2006
I did something in the start up options with this database.
Now when I open it I can't get Access to function as normal.
There is no right click, no tool barr or menu.
Any ideas?
View 1 Replies
View Related
Oct 25, 2007
Since the introduction of 2003 when you create a custom menu you always get the 'Type in a question for help' tag and the min max close buttons. Is there any way of removing them or disabling them?
:confused:
View 1 Replies
View Related
Jan 30, 2006
I have the following code in the on_load of all of my forms to disable all menus:Dim i As IntegerFor i = 1 To CommandBars.CountCommandBars(i).Enabled = FalseNext iThe problem is that when I open a report in preview mode I cannot close, print, etc.Two questions:1. Is the above approach the best way to disable all menus and toolbars?2. How do I add a custom toolbar (already created) to the report preview only. I've tried doing in in the properties and by me.toolbar = "custom toolbar." Neither approach works. I suspect that the code I've used to disable the menus is keeping me from adding custom menus where I want them?I should also mention that I have also turned off all of the menus, toolbars, etc. in the options/startup.Thanks for your help!
View 2 Replies
View Related
Nov 16, 2004
hello everybody
I've created 2 menus using macros and everything works perfectly.
The 2nd menu has 2 commands and I want the second command of the menu to be "activated" only if a specific form is open.Otherwise the command must be in the menu, but not enabled. I also want to put a line between these 2 commands. Is it possible? Thanks in advance
View 3 Replies
View Related
Nov 14, 2004
Hello everybody
Could someone please explain me how can I create a couple of menus that execute commands in my db? I would like to open certain forms or reports using menus. If it is possible pls give me an example, of 2 menus each having 2 commands. Thank you in advance
View 11 Replies
View Related
Feb 2, 2005
In Tools, Startup I deselected all options but now I want to display the toolbar and menu again. I can't figure out how to undo what I've done.
Help appreciated.
View 1 Replies
View Related
Oct 15, 2005
How do I make my own menus? Is there some kind of wizard or what? I know how to select a menu to use, but as far as making one I've never done/seen it done before.
View 1 Replies
View Related
Jan 11, 2005
hi..
i have to comboboxes in my form. one lists section names, and one lists all staffnames.
how do make the second combo displays only names of staff from a particular section depending on the first combo?
thanks in advance
View 1 Replies
View Related
Oct 25, 2005
Hello i would like to ask if there is any way for me to enable the menus , the menu bar and the database window if i disable them from the startup options of my Db ?
View 9 Replies
View Related
Nov 22, 2007
Hi All,
A previous employee of the company I work for setup an access database, which works well. But he populated some drop down lists and didn't give us the option to add additional items to those lists.
He has also done something that when the database is opened the usual access menus and toolbars disappear.
I'm pretty sure that the lists are collected from a table in that database, but I can't view the tables either :(
I have managed to get the start form into design view and also to open the code builder, but I can't see anything in there.
If anyone can offer any help or suggestions on how to access the tables when it's been locked out, I'd be grateful.
Kind regards,
Rich
View 3 Replies
View Related
Feb 26, 2008
Hi all,
After searching through the "search" field, I realize lots of us are having problems with the menu's in access 2007.
After converting my 2003 DB to 2007, my menus are still there, but displayes as Add-ins instead of as the menu bar. I can't find any options to change during the conversion.
I have tried importing my Logon window with the options "menus and icons" clicked, but this didn't change anything.
If I open the DB in 2003 Format, then go to the options in Access 2007 I can choose the menubar, but if I convert to 2007, the menubar is only available as add-ins. Is there any way round this?
Appreciate any help - it is so time consuming trying to figure this out - and I seem to go round in circles, ticking options on and off... perhaps some dear soul has already found the answer!
View 2 Replies
View Related
Mar 15, 2008
Hi
I went into tools, startup and unchecked allow full menus. Now when I open the DB, I don't have the tools menu so I can check the allow full menus. I need to get this back so I can continue working on the DB. There must be someway to get this back/reverse it.
Access 2003
Thankyou
Garry
View 2 Replies
View Related
Mar 22, 2008
Hi, I have hidden all the menus and added one of my own custom menus to a DB that I was creating. That DB has been completed. Now when I open a blank DB to commence again, I have the same hidden menues and my one custom menu. Is there away in Access 2003 that I can replace the template, for example, MS Excel and Word have .dot and personal.xls. Is there an easy way to bring them all back. I checked in startup for a restore defaults, however this does not work. Any ideas. Garry
View 1 Replies
View Related
