I am using the following code for populating the combo boxes in my application. It is really nice. If any one requires, may use this. It takes three parameters. The first, the name of the Combo Box and the second, the SQL Statement to populate the combo box and the third is the number of column to be displayed (from the SQL statement)
[Code]...
I am building a form in access database.
I have a combo box which is linked to a query which is looking up a unique reference number from a table called Tbl_Submitted_Requests.
What I need the form to do is auto populate the other text boxes when the user selects the unique reference from the combo box. How can I get the text boxes to auto populate with the data that is associated with each unique reference?
So 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 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.
I 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."
what is the syntax to clear a combo box and also a list box?
View 3 RepliesI have a small requirement and that is as follows: I am calling a stored procedure and based on the results from the stored procedure, i want to display the data into textboxes. I am using DataSet and DataAdapter for the same. Can anyone help me. My code is as follows:
Dim sqlStripCmd As New SqlCommand("prcAdt_mwo_strip_det_sel", connection.conn)
sqlStripCmd.CommandType = CommandType.StoredProcedure
sqlStripCmd.Parameters.Add("@strip_no", SqlDbType.Char, 3).Value = txtMwoStpNo.Text
[code]....
I am getting the data and am able to display it into a datagrid, but how do i put it into textboxes.
I am trying to get my head around datasets, etc. The following code pulls data from an sql server and stores it in a data set. I then set the grid's datasoure to this data set. Now I want to populate a combo box on 'form load' with information from a field (surname) within the authors table.How do I approach this? I can do it in design mode but I want to do it in code as I feel you get a better understanding of what is happening under the hood.
[Code]...
I am trying to create a unit converter program. At the moment I'm trying to populate my combo box with results that have been calculated. I have two sets of results to display. I want them displayed side by side and have been trying very hard to do this. So far I've managed to get the result to display but only the original unit, it's start, increment and end value. Not the converted unit, start, increment and end value.
Then I managed to display both the original inputs and the converted inputs but they were showing directly below one another instead of being seperated into two seperate columns, i.e. original input, start, increment and end and the converted unit, start, increment etc.
This is the code snippet I am working with:
lstTableResult.Text = "" + (FormatNumber(lcInputValue, CInt(mdDecPlaces))), "" + (FormatNumber(lcResult, CInt(mdDecPlaces)))
The code above is incorrect and shows errors, i.e. is asking for end of statement.
The code below works, but it is only one code line, I've just split into two to make it work... not what I actually want.
lstTableResult.Items.Add(FormatNumber(lcInputValue, CInt(mdDecPlaces)))
lstTableResult.Items.Add(FormatNumber(lcResult, CInt(mdDecPlaces)))
I am building a form that will eventually list a group of functions on the left. If you drag a function onto the form, it will create a listbox and a label at the loction you dropped it to. If you drag a function into a listbox, it will add that function as a listbox item. I have this working kind of. The problem is that once I create a new listbox, I am no longer able to add items to the previous ones. Here is my code:
Public Class Form1
Private MouseIsDown As Boolean = False
'rivate Functionlist As ListBox
[code]....
I Want to populate a combo box in vb 2008 with mysql, but when i run the thing that appear is "System.__ComObject"..kindly check the errors..
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
conn = New ADODB.Connection
[Code].....
Recently started working with VB.NET, and I'm just playing around with the controls and everything. What I want to do, is populate a drop-down list or a combobox (on program load) with data from a dictionary. I'm used to php, so I tried a for each dictionary.items as newitem combobox.items.add(newitem) but I can't get it working. Can someone give me an example of this? And what if i wanted only the key to show in the drop-down, and the corresponding value shown on a label besides it when I make a selection?
[Code]...
I thought I would have a go at creating an inventory system - as I can learn VB.net on the way and its useful to use. The first hurdle I have come across is I would like to link a combo box with active directory to populate the name of who is requesting the stock item - can anyone point me in the right direction of how this is done please?
View 4 RepliesIf I want to populate 3 text boxes with information such as name, quantity on hand, and price from the selection of a combo box. Is there some all around code where I can get the information from the text file to VB .net ? Ive heard use arrays, then I heard arr file and none of these are seeming to work yet can some one please help me.
View 14 RepliesI am populating text boxes when a user selects a company name from the cbo box. When I make the first selection everything looks good, but when i make another selection the text boxes do not clear and repopulate with the new values. Here is the code in the selected index change event.
[Code]...
Im trying to populate a combo box with a column in an excel file.Im not even sure where to start. I searched around but couldn't find the info I needed or samples to learn from.
Can anyone point me in the right direction to where I may accomplish this?
how to go about populating some text boxes with results from calculations. To be more specific, I'm trying to do some trig to calculate various parts of a ci0rcle and will be populating any two of the text boxes then click on a button to get the missing values. I was thinking along the lines of a loop until all values have been calculated.
View 14 RepliesI have a form which has a Combo Box Control. I have selected the drop down style property to DropDown. I have also set the DropDown Width to 250.I have set the auto complete mode to suggest and the auto complete source to listitems.it works absolutely fine when i click on the drop down. but when i type in somethin, the auto complete mode activates a drop down which has a small width.i wanna know how to increase the width of the auto complete drop down via code so that the list items are viewed properly.I am using C#
View 3 RepliesI am trying to create a WPF browser application that allows you to search and display recipes. The combo box presents choices, the Ingredients display in one list box and the "cooking" instructions appear in the other list box. What's happening is the first time you make a selection from the combobox nothing displays, and this could be happening because the first line of code under Selectionchanged clears the List Boxes however, it should be populating those list boxes with content, shouldn't it? Anyway, as you make other selections List boxes 1 & 2 get populated but they do not match what displays in the Combo box, i.e. if you select "Easy Taco Dip" any random recipe might appear in List Boxes 1 & 2.
Option Explicit On
Class Page1
'User Makes a selection from the ComboBox which populates List Boxes 1 & 2
[Code].....
I was having a heck of a time populating a gridview combo box.I learned a ton in the last 48 hours but would really like to know the answers to the bottom three questions.You guys are the experts, so I'm hoping you will enlighten meBut the summary of it is below:I was never able to get the ComboBox to bind to the data source. I tried everything until I turned blue. So I went to the basics and coded all the automatic stuff. I'm curious as to why the automatic binding didn't work. Perhaps its because my gridview datasource was LINQ.Here is how I pulled it off. I hope someone down the road benefits from the last 48 hours of my delima:First of all, know that I have two drop down lists on my form, one is the GPField and the other is the BankField. These are already populated DDLs that are static. So I used them to cheat on the values instead of using enums.
Sub fillGPFieldListDDL(ByVal obj As Object)
Dim db As New CompanyDataDataContext
Dim myConn As New Connection With {.ConnCls = ConnCls}
[code].....
i am using a couple bound comboboxes in a bound datagridview. It seems though, when the combo's are changed, and the tableadapter is filled again, the changes are not being saved to the table. Is there a special trick to getting the data in the combo boxes to saved when the values are changed?
View 4 RepliesI have two combo boxes: cboRepairCategory (plumbing, landscaping, etc) and cboVendors. I am using Stored Procedures in SQL to store the data from my database and then load them into the combo boxes.The cboRepairCategory will be loaded first. Once the user has selected what type of repair it is I want it to restrict the amount of vendors that can be selected, so instead of saying:CREATE PROCEDURE dbo.up_Fill_Vendor_Combo
AS
SELECT VendorID, CompanyName
FROM Vendors
[code].....
I would select only the vendors that have the RepairType of say Landscaping, so thecboVendor would load now only Vendors with Landscaping instead of all vendors.My question is this: Is this done in SQL in my Stored Procedure or is it done in VB in my functions for my combo boxes. I've never tried this before I am totally lost on it. I have fiddled with the code on both ends but to no avail.
im trying to learn how to code more efficiently and was wondering how to preload combo boxes better. im working on a project atm that has many comboboxes with the same menu information. how to i link the information in a sub procedure when the comboboxes all have different names?
View 3 Repliesi've been searching everywhere to try to get this setup. I am running Visual Basic 2008 I have 1 Combo Box that Has 3 Entries, Kyocera>Konica>Toshiba I have a 2nd Combo Box that has entries for each of those manufactors ...Kyocera has 3035,4035,5035....the konica has c250,c352,c452......the Toshiba has c3520, 4520
[Code]...
i've been searching everywhere to try to get this setup. I am running Visual Basic 2008 I have 1 Combo Box that Has 3 Entries, Kyocera>Konica>Toshiba I have a 2nd Combo Box that has entries for each of those manufactors...Kyocera has 3035,4035,5035....the konica has c250,c352,c452......the Toshiba has c3520, 4520
I want it so when i click on Kyocera the 2nd combo box only reads 3035,4035,5035 and when i click konica it only reads c250,c352,c452 etc etc
I have an employees form with the employees home anddress and work address. I am working with VB
2008 Express.In each address I have a combobox bound to a table of the States.Wn I select any state
in either one the other is locked to it. How can I break this synchronization.I tryied using a
different dataset, another bindingsource, with the same results.
I have a school project where i have a form that works as a class registration. There is cboGradeLevel and cboCourse and cboNumber. If cboGrade level is freshman i only want the numbers that start with 1 in cboName to be displayed, sophomore =2, junior =3, senior =3. Then i want cboCourse to work the same for the second number in cboNumber. english=1, history=2, math=3, science=4. So if freshman and history were selected i only want the numbers that start with 12- to be displayed. What can I use to make this happen?
View 2 Replies