Dropdown Menu/list Issue Pulling Records From Access Db
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.
View Replies
ADVERTISEMENT
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).
View Replies
View Related
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
View Replies
View Related
I've created a form where the user should be able to select an option, then a second list will be populated based on that selection. The next part is where I am running into trouble.
The user can also select a time window which can limit their search, if they so choose. Code:
View Replies
View Related
I have a set of db results that I cannot filter completely in my query and I'm trying to figure out how to eliminate the "duplicate entries" after the fact.
My problem is I'm pulling columns for lot number and transaction time, but some (not all) lot numbers have two transaction times so I can't filter out these double entries with a "DISTINCT" statement in my query since the transaction times are distinct, but I only care about the first one. I'm looping through pulling my results as such: Code:
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
I have a database that has an email column that either contains an email address someemailaddy@mail.com or a value "n/a" All I want to do is loop through the column in ASP by checking to see if the "@" is in the address and if it is feed the email address into a mailto: href tag . I think something is wrong with my code because it just returns the name but not the href.
<% IF InStr(1, contactObjRS("Email"), "@") = 1Then %>
<a href="<A href='mailto%=contactObjRS("Email'>mailto%=contactObjRS("Email") %>"><%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %></a></font>
<% Else %>
<%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %>
<% End If %>ted.
View Replies
View Related
I need to create a page which updates a products information within a record.
the tables are,
products (ID,CatID,sID)
supplier (sID,sName),
category (CatID, CatName)
The above tables supplier and category have relationships to products by using the sID and CatID
I need to update the product details by having a select/option for a supplier and category but if not changed by the user the value already within products table stays the same, therefore the list must be dynamic so that the first item in the list is the one relating to the value in the products table. Also the value must be the ID numbers but must display the names not the ID's to the users within the select/option.
View Replies
View Related
How to display sql database data to dropdown list in asp?
View Replies
View Related
I have a form page in ASP where the first menu/list function as a filter of
the second menu list. Once I select an item form the first combo I get the
second menu full of options. This is correct. My probem is that the first
combo gets the default value again and I do not see what I did choose.
View Replies
View Related
I would like to display 15 items (lines) in the dropdown list, but by
default the list displays only 11 lines. How can I have all the 15 items
displayed in my dropdown list
View Replies
View Related
This is probably really stupid, but I cannot figure it out, and none of the references I've found seem quite right for what I'm trying to do. How do I do the below, but have the option values and Option Choice Text Description pull from the db instead of requiring manual data entry?
<option value="1" <%If (Not isNull((RS.Fields.Item("ID").Value))) Then
If ("1" =CStr((RS.Fields.Item("ID").Value))) Then
Response.Write("SELECTED") : Response.Write("")%>>Option Choice Text
Description</option>
Can anybody point me to some resources for this?
View Replies
View Related
I have an access database that holds among other info, web addresses and email addresses. They are in a hyperlink format in Access. When I run the ASP code, they disappear. I want to pull the data out, with the web addresses as hyperlinks.
View Replies
View Related
I have an access database from which I am pulling records. The main table contains all the info for a specific person and their business. I am retrieving the data and sorting based on last name, and I am also retrieving and sorting the data based on the specific region a person is in.
What I would like to do is also sort based on a sector that a person’s business is a part of. I would be able to retrieve all the records for each sector and sort them just as I did with region, but I don’t want to list ALL the sub-sectors. Code:
View Replies
View Related
I need to include a variable value that I am getting from the URL into a dropdownlist selection.
<%
Dim strFlagCode 'Holds the vessel Flag Code
strFlagCode = request.QueryString("flag")
'-- Variables we are using
dim objConn, objRS, strSQL
'-- Define our objects
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
'-- Database path and Data provider
objConn.ConnectionString = Server.MapPath("Static.mdb")
objConn.Provider = "Microsoft.Jet.OLEDB.4.0"
objConn.Open .....
View Replies
View Related
I am trying to list a database (SQL) i a dropdown list but I just cant get it to work... I am writing in ASP. This is some of the code:
mySQL="SELECT ras.raser FROM ras ORDER by raser"
<tr>
<td width="220">Raser</select></td>
<td width="342" height="23">
<select name="idRas">
<%do while not rstemp.eof
pRaser= rstemp("raser")
%>
<option value='??????????' </option>
</select>
</td>
</tr>
View Replies
View Related
I'm trying to build a asp dynamic list were you can select a option in the first list and depeding on that value the second list will change to match. For instance I choose a customer in the first list, the second list then has to give all the codes from that customer. The list is variabel, as the value;s are from a database.
If tried some stuff with ASP and Javascript, but the page reloads after selecting one option, but because it reloads, it delete's the text that is written in the rest of the form.
View Replies
View Related
how to validate a menu/list? I can use dreamweaver to validate a text field but not a menu/list.
View Replies
View Related
How can I make and populate list menu with name of files from one folder and then select one of their?
View Replies
View Related
the problem is tat i have two dropdown list, i have to select an option from one of them and the result will display it in another drop down list base on wad i selected earlier.
Then after clicking the submit button it will insert all this information into the database. but for right now it is inserting all the information once i select the option in my first dropdown list without clicking the submit button. how do i solve this?
i have this code : onchange="document.vForm.submit()"
which is to submit the values from my first drop down list and display it to another dropdown list.
View Replies
View Related
does anyone know how to read in a list menu value into asp? I need to get the value and then display results with it.
View Replies
View Related
I have a dropdown list where u can add students name inside the listbox. As u can see there is a "Please select one" option in the dropdown list also. When i click on the option, it will be added into the listbox also. Can someone pls help me to solve this in JavaScript. My attachment.
if (document.teamForm.newMember.value == "-- Please Select One --")
{
alert ("You can not select this option.")
teamForm.newMember.focus();
return false;
}
View Replies
View Related
I could not solve for the past 3 days. I am try to build a website using ASP and VBscript. I am still a newbie to it.Let's get to the problem. What I am trying to do is to have multiple dropdown list. Each list menu ( except the 1st) dependes on the choice made in the one above.
I am using dreamweaver, it did generate a the form and everything and I was able to filter the results. The problem is that I don't know HOW TO REFRESH THE LIST. In other words, I can't figure out how to change the list menu options when the choices above change. I have tried to find some tutorial about it, but all I found was with JavaScript and I don't wanna mix VBS with JS.
View Replies
View Related
Does anyone know how to make it so that when someone clicks on certain menu item on one list it automatically updates a second list with values.For example,if i click the Make of a car in one list, i want the second list to automatically update with the relative Models.
I've seen it done on various sites such as www.autotrader.co.uk but can't think how its done. So far i'm populating the first list dynamically with a database but don't know what the next step is to get the second one to do it.
View Replies
View Related
I have an old application ( pre-VB5) that I need to add a select/option list to. This is an edit program so the values for the form will be retrieved from a database. How do I set the value of the dropdown with the value from the database. The value in the database is either new, trial, maint., employee, beta, or null. I need to set the dropdrown to one of these values. An example of the select;
<td>
<select name="ordReason">
<option></option>
<option value="New">New</option>
<option value="Maint.">Maint.</option>
<option value="Trial">Trial</option>
<option value="Employee">Employee</option>
<option value="Beta">Beta</option>
</select>
</td>
View Replies
View Related
i have this error in my form. okay i have two dropdown list which i have to slect an option in one of the drop down list an it will display the result in another drop down list and then by clicking the submit button it will display all the information into the database. but right now, the problem is tat after selecting an option frok the first dropdown list it is submitting into the database without clicking the submit button. how do i solve this?
i have this code : onchange="document.vForm.submit()" which will submit the values and retrieve sum other values and display it into the other dropdown list. i cant take this code away.
View Replies
View Related
I have a drop down list on an asp page. Can I have tooltips for each item so when the user scrolls odwn through the drop down I display a tooltip (as some options are long and I do not want to incrase the width of my drop down).
View Replies
View Related
I currently have an "Add customer" page on my site. On this page you can choose multiple "brands" from a list box. (These brands are dynamic and come from a seperate table in my db). These brands are split up into an array and each added as a row to a database table.
Now I am working on a "Modify customer" page. It has all the same fields as my Add page except that the fields are already filled in with information from the db. I can't seem to figure out how to have my list box have multiple items selected when you first come to the page.
View Replies
View Related