I have a dropdown menu (HTML's form->select) i have options in it, and I need as soon as one of the options is chosen (onChange)to update my database's (mdb) field
like this:
mdbVar("some_field")=1
mdbVar.update
that simple, but i cant figureout how to connect the onChange to this code.
I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
I'm using this code to populate a drop down menu and i'm using a query to populate the menu with certain info. from the table column. How could I add other drop down menus to this form and have them filled with different info than in the first drop down menu but still be in the same form? Code:
I have 2 drop down menus with data populated dynamically from a database.
Category
Subcategory
If i select an appropriate category the subcategory should change instantly to show the subcategories relating to the selected category. But i can't use a form submit, because before the forms are other textboxes with other values that i don't want to wipe on a page refresh.
I need to somehow preload the categories and their related subcategories. I've been trawling through examples, most are harcoded combobox values which won't work for me.
I have a dynamic drop down menu created from an Access 97 database. The munu contains numbered indexes. Is there a way to have Index 10 displayed after Index 9 instead of after Index 1.
i have three dependent dropdown list.when select city in first box then 2nd list will show all company for selected city. 3rd will show all jobs of co. any suggestion?
I have an access db called boards and a table in it called notes. I have 3 fields in the table ID, subject, and notes. I have code to search the db and display the results in the notes field.. This code works very well. I wanted to modify this code so that I can use a dropdown menu instead of type in the search field but i cannot get the dropdown menu code to display the search results. Code:
I am trying set up a page where the user can view records chosen by the year. I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.
My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.
i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.
Can anyone recommend, pop up /hover menu that populates data from the database? At the moment we are using http://dhtmlcentral.com/projects/coolmenus/ but it seems to take a while to load. I'm just wondering if there is more efficient script available.
I'm trying to display thousands of people's names so a user can pick one. Is a dropdown the best way to do this? Is there a better way? I've never had to deal with that many names, so I don't know how it will affect performance.
This code only allows for 1 date from my database to be added. I need to be able to populate it with all matching dates. I'm not to sure on how to do this.
An HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user has selected one value from the dropdown it should show values from (tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a button "GO" it should show all the value's from the database that been selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
Below is what I have for one of the drop-down menus. Could anyone help with how to add the VB code to this so that the selected menu item will submit to the database as well? Code:
I have two columns in my microsoft access database.
1st column is company_logo (jpg image) 2nd column is company_name (text)
I want to build a form, a dropdown box which I would populate with the help of a sql statement from my database. The both columns from up there are associated.
When the user clicks on that dropdown box, I need that company_logo and company_name to be shown one beside another. It should list all the companies availible (taken from that sql statement or recordset).
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
Let's say I have a dynamic list/menu, which gets its values from a database table, for example a list of contact people where the value is an ID number and the label is the name. However, if the value the user wants is not in the list I would like to place a hyperlink which will...
(1) open a small window, with an ASP form to allow the user to add a new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about. I don't like the idea of forcing the user to leave the current screen, go to some other form, add the entry they need to the lookup table, then come back; this seems like a logical approach, but just wondering how to make it work.
This seems like a common enough situation; anyone have any code samples or suggestions about how to do this?
Can any one help with code for form menu in which sub menu appear on selecting the main menu. This is one field of an access database to be submitted by user.. Now I have code only for selecting from main menu. Code:
i have menus and sub menus written in java script in an asp page.at times teh sub menu bars overlap with the text fields of some of the pages.I want to set some option on the menu bars so that if they overlap with the text feilds of the page still they remain on the top and r visible over the text feild.
Does anyone have any code to display a dynamic dropdown menu (similar to Windows Start menu)? There seems to be a browser compatability problem with most that I've seen.
i had done coding for two dependent dynamic drop down boxes.taking code from http://forums.aspfree.com/t53159/s.html......it is working nice but now select 2nd box and populate 3rd one.i m very confused how make a changes in code for 3rd one.if any of u have time i can send my code for urs technicalful advise
I have code to present on this forum, but not with me at the moment. This is what is happening now. On my page there is a drop down box that calls on an onChange javascript function. The drop down box dynamically displays locations depending on the location of the cars.
Therefore...if Toyota Camrys are in Philadelphia and New York, the drop-down box will display: ALL, Philadelphia, and New York. Selecting one will filter out only those in that location.
What i want to do is...change it so...it displays dynamically the locations horizontally...here is an example: PREFERED LOCATION? ALL PHILADELPHIA NEW YORK (all are links to filter out those that do not match the location). i need to do it to save space and make it more user-friendly.
I know this is supposed to be easy but I can't get this to work. I have a dropdown that pulls all the Projects (tp_title) available. All I want to do is get the ID (tp_id) of that record so I can get the developer assigned to that project (tp_assigned_to). Then, when I get the developer, I need that to be redirected to a second page. Code:
I've got an XML file that I use to populate a treeview control and a dropdown box. That works fine, although I now want to be able to sort the list of people in the dropdown list. Someone suggested using an XML template, but I'm a bit of an XML newbie and not sure how to do this. Code:
Lets say you have a dropdown box with few options in it. Several products have such a dropdown box. is there a way to do this following stuff.
I want one of that options in the dropdown box to be 'unique'. When selected, it would dissapear, or it can't be clicked on, on another product's dropdown. 'yes or no' answer would do just fine for now.