I have a PHP Page that displays airport information in a list in the following order
[code...]
Using that delimited method of ";" then a break, how can i put all of those into a combo box. There are a few hundred.
I've done data binding to my Combos and it works fine but my data base has over 260 000 entries, so I can't let user to move trough it, one by one entry until finds a match.What I am looking for is that user select value from Combo Boxes and Text Boxes get filled in with a matching values from the same row.Auto Complete helps in selection but I still can't work it out how to get values to my text boxes.
[Code]...
I'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.
The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
I've already asked on other forums and people are where replying giving me third party programs that I could use to implement this, something I don't really want to do.
I'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
None of the Microsoft videos I have watched, or the other posts I have seen, have given me the pieces I need to understand this process. This is the one key piece of understanding that I need to finish about 4 different programs I have started in the last 2 years. All of them key on understanding the following processes:
View 1 Repliessaving data from a text field and multiple combo boxes to a file on a server in visual basic 2008
View 1 RepliesBasically say I have a text file with the following contents:
"Tim", "USA", "1982"
"Jane", "Germany", "1980"
"Brad", "France", "1989"
I have 5 combo boxes that need to show the same list of items that come from a single dataset table. I have managed to bind the datatable to the combo boxes no problem at all.. but when I run the application and select an item from one of the combo boxes all the others change to the item I selected. After some research I believe that this problem is something to do with using the one datasource so I have tried assigning the dataset datatable to 2 different variables and used them as datasources for 2 of the comboboxes but the same still happens.
A work around to this I can see is to call the same methods and SQL select statements 5 times over to get individual datasources for each combo box but this doing that sounds crazy to me. how I can get around this easily? Code snippet below shows 2 combox boxes and their datasources. I'm using VS2005, .Net 2
ComboBox1.DropDownStyle = ComboBoxStyle.DropDownList
ComboBox1.DataSource = AllergyListDataSet.Tables("ListOfAllergies")
ComboBox1.DisplayMember = "Condition"
[Code]....
I'm looking at loading data into combo boxes etc from a XML file.my xml file is like this
<Cars>
<Car>
<Make>Ford</Make>[code]....
I want to look through each "car" and if it's a ford I want to continue and get the year etc otherwise move onto the next car.
im trying to pick up Visual basic on my own with no friends/family that have any programming experience.. I'm struggling (surprise surprise)Heres what I'm trying to do...I have 1 combo box, It will list product names.. Lets say 15 of them.. (I know 15 i could just as easily specify them individually within VB.. but lets assume I NEED to read them from an excel file.(Excel 2003)
Part 1 :Really all i need to know for now, is how do I load an excel worksheet into VB so I can call data up from the cells / rows / columns..
Part 2 : How do I define Which Cells from Each row or column I want to populate into the combo box... Presuming for the "Product name" combobox I have placed each of the 15 product names in the excel file under Row 1, column A through Row 15 , Column A.I want to avoid this and just call the xls file into VB. (Excel will be installed on any computer running this application if that matters. )
ok so What I am trying to do is have one combo box with employee name and once you choose the employee name for it to populate another combo box with the pay periods that the employee has in the database. So far I have that down and here is my code for it:
[Code]...
i have a combo box that on form load is populated but i need to know when i click an item, i will be able to code how to populate other combo and text boxes with data about the same person.
View 2 RepliesI have a form that has some combo boxes in it, and a table in SQL Server that stores the Values for the selected item for the combo box.I have read the data out from the combo box and inserted it into the SQL table as a integer. Now I want to read it back in to the form.
View 7 RepliesDim ds_Details_all1 As New DataSet
Dim dgv_newtbcolumn As New DataGridViewTextBoxColumn
Dim dgv_newcbocolumn As New DataGridViewComboBoxColumn
Try
If ds_AEGM.Tables(0).Rows.Count <> 0 Then
[Code]...
I have designed my form like this it has a combo box and several text boxes. In the form load I want to load the customer IDs of my customer table into my Combo box.Customer IDs data type is varchar and this part is working in my form.The next thing that I want to do is if a user select a single user ID from the combo box I need to display the first name last name and there are several fields of that selected customer id in the text boxes.If anyone can help me in this it'll be a great help.I have designed my data base in sql server 2008 and I'm using visual studio 2008.I added a new sqldata adapter and I created the data set.But I want to know how to pass the selected id of the combo box as the select parameter of sql statement and how to bind data to the text boxes.
View 2 RepliesBind multiple combo boxes to same data table with minimal code
View 19 Repliesi wanted to link options selected from Comb box A (general) to specific options in combo box B (specific). I want to pick a word in Combo box A that has specific words/phrases in Combo Box B show. But not all the words to show in the combo box B if they aren't associated with the Word picked in Combo Box A. Ex.When "Soda" is picked in A, only "Coke, Sprite, Fanta" should be visible in combo box b, not everything else.
This is the code i used to make the boxes, but i don't know how to link them. Do i use an If/Else/ Case Else statement or what?
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' fills the combo boxes with values
[Code].....
First i am pretty new to coding and everything so yeah...I wish to make a distance and fuel calculator as my project. Included will be multiple combo boxes with different sets of information (The manufacturer of the vehicle, model of vehicle, the vehicles fuel use per 100Km, its transmission type, users choice of where they will depart from and arrive etc.) Is it possible to achieve this without using a lot of combo boxes? I've experimented using if statements for example:
if combobox1.selected item = "Holden" then
combobox2.visible = true (it's bad i know)
Then from this they would choose their model type in another combo box and then choose their transmission type etc..I don't want to use this because then it will mean i will have to do it for each and every combo box for each and every different set of data because making one 'visible = true' i will have to make the other 'visible = false' and this will cause problems when i start adding a lot onto it.
I am trying to create a program that has the following aspects:2 combo boxes each containg a list of seven cities (both combo boxes have the same cities listed in them)text file containing distances to each city from one another eg if southampton is selected in one combo box and london in the other it will call 164 from the text file this means that each city needs to relate to a certain row or column number depending on the line in which the data is held in the text file. Here is what i have so far code wise:
Private Sub frmDistance_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim rowcolumn(7, 7) As Integer
Dim sr As IO.StreamReader = IO.File.OpenText("Distance.Txt")
Dim row, col As Integer
[Code]...
the problem is where i have the if statements that i have coloured red if i select southampton and london it will only display southampton to cardiff.
I have a question concerning app settings. Is it possible to create a single setting which stores a list of text items and then use that list as the selection in a combo box? I'm trying to create a system that allows the user to determine which options are available in the combo box. In the past I have created a database table to store the options, but I have recently leanred that this solution comes with some inherent problems.
View 3 RepliesSo as the name states; I am a newer coder.
This is the code i have:
Public Sub RandomNumbers()
Dim s(4) As String
Dim RandomNumber As Byte
I don't know if you can tell what I am trying to do here, so I will try to explain. I what to create for random numbers and place them into for different text boxes. I also would like to do this with combo boxes and their selected indexes. So if the combo box has 10 items in it; the new selected index would be the random number generated above.
I'm trying to learn how to write a data layer class to read in information and populate combo boxes, etc.
View 1 RepliesWe are writing a program that pulls a Teacher from a database, then you select the "period" 1 - 7. What is happening is if we pick period 1 on teacher john doe. Then when you pick another teacher it doesn't clear the period that we selected before. How do we clear this information every time we select a different teacher?
View 2 RepliesI am trying to pull wind direction, temperature and speed, data from this webpage, I have had not much success with it at all, I think that I have the correct method but get stuck on the HTML coding. the webpage is: [URL] I sort of know how to get to the HTML code, but get lost on how to define the ellements that are required. I have a screen capture of where I get up to.
View 1 RepliesI used this code to created 2 combo boxes General and Specific...and Only show Specific (Combo when Combo A is chosen.....What i need now is to know how to assign specific values to the items in combo b (Specific).??? If i chose a sode, Fanta, i want the total price to be $10.00 (this price will show up in the finial price box..
View 4 RepliesI am developing a program that makes it easier for users to log on to a website and search for specific data. I have the first portion finished in which I have a form with the Ax Web Browser control.
The web browser control navigates to a local website and automatically logs in for the end user. This is done by using code which automatically fills in the username and password and then submits the form to logon using something similar to this: WebBrowser1.Document.Forms.Item(, 0).elements("txtUsername").value = "user"
Once logged on - there is a search page which contains a combo box and list box. I am trying to set specific values for the combo box and list boxes.For example - the combo box on the website is titled: cbxDate and contains the following values: Today, Yesterday, This Week, This Month.
A list box titled: lstArea contains the following values: Zone A, Zone B, Zone C, All.I am trying to figure out if there is a way through code to select, in this example, "Yesterday" in the cbxDate and "Zone B" in the lstArea on the webpage.If anyone knows of a solution, please feel free to let me know. Be advised that I am using the Ax Web Browser Control.
I am getting an error when i try to populate some combo boxes with a value, the combo box has values in and the right amount the code is getting the right number.
the error msg is "Object reference not set to an instance of an object."
I currently have my cute little first program made... I'm just stepping into the water with this programming thing. I made a program where you can select a shape from a drop-down list and then input some values and click a button and get the area of the shape. I have it working so that when a certain shape is chosen, certain fields are disabled, such as when you pick "circle" from the combo box, the "length", "width", and "number of sides" text boxes are disabled but the "radius" text box is enabled, thus allowing you to enter the radius and find the area. I want to make it so that when you first load the program, all of the text boxes for the length, width, number of sides and radius are disabled until you select a shape from the list. Currently I'm using
[Code]...
This works for disabling the correct boxes when something is selected, but I don't know if I'm even on the right path with that first part.
what is the syntax to clear a combo box and also a list box?
View 3 RepliesI'm developing a new programme that uses multiple table to store Orders placed via my website, on the form that i have created i have a Combobox that displays the Point of sale name. what i need it to do is when the record is updated in need the Point_of_sale_ID value that matches the name from the Point_Of_Sale table to be put into the Point_of_Sale_ID field on the Sales_Order tableI have added the Foreign Keys for the fields, but i cannot find any help in regards to this, i mainly wor with PHP but have taken on the new challenge of VB & ADO.Net, i have rear several book on the subject and have produced several single table programs but am now stuck!! [code]
View 6 Replies