Auto-Filling The Boxes
Jan 3, 2011
I'm not 100% sure where to post this, as I'm making the program in VB.net, however It is linked to access and is getting the information / saving it into there.
I have a customers page and a jobsheet page,
the customers page is where the information on the customer is stored e.g. "Company" ,"First name" and "Last name".
When I Go into jobsheet, I have made it in so that company searches for the record from access so there is a list e.g. "Big W" , "Bunnings" etc, and tied up to the company is a name of the person in that company.
My question (after all the babble) is how can I make it so when I choose "Big W" from the list, it auto fills in the "First name" with 'John' and last name with 'Smith' , and if I choose Bunnings it uses the name associated with that and etc for the other companies.
View 3 Replies
ADVERTISEMENT
Jun 12, 2010
I am having a bit of a problem working with textboxes, subroutines, and modules.I have a form (frmMain) with 30+ textboxes. These textboxes collect data input by the user either manually or the user can choose to have the program randomize all the numbers in the textboxes by clicking a button. To randomize these numbers, I have a subroutine in the module called randomizeData(). The problem I am having is that the textboxes on frmMain are never actually updating themselves with the random numbers generated in the module. No errors or anything, but no results either. Here is a simple summary of what I have going on.
Public Class frmMain
Private Sub cbRandom_click()
randomizeData()
End Sub
[code]....
View 11 Replies
Jan 20, 2009
I have 100 text boxes on another form I have to populate. I don't want to use 100 Form3.txt1.Text = Mid(answer,1,1) as shown below, i would like to put them in a loop, like a For loop. But when I try I get Error1'txt' is not a member of 'WindowsApplication1.Form3'.Is there another way of doing this?
[Code]...
View 3 Replies
Apr 4, 2010
Here i have code filling a drop down box with the company name.
Private Sub Filllistcomp()
listcomp.Items.Clear()
'define select statement
[CODE]...
This part works. The drop down menu is filled with all the company names. The following part does not work how ever.
Protected Sub listcomp_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles listcomp.SelectedIndexChanged
'create the select statment that serches for a record
[CODE]...
There is no error thrown either. The information is just not showing up.
View 8 Replies
Jul 4, 2010
I am using a Class_SQL that gets the table, creates the DataAdapter and DataTable.I have a combobox named cboFullname. I can fill the combobox with data from the database, ie: Dim sqlcmdtext As String = "SELECT *, Firstname + ' ' + Surname AS Fullname From Contacts". I can display full records in a datagridview.
I would like to be able to select a name from the combobox and have the record text boxes display the data and be changed with the cbofullname index changed subroutine. Here is my current code to date:
Public Class frmMain Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
View 3 Replies
Jun 25, 2010
For example:
test is a variable
test = 1
How do I make that if test = 1 that a listbox fills with the items: red, blue, green, yellow?
If test = 1 Then
listbox1....
View 4 Replies
Feb 9, 2010
I have been working on this one for a couple of days now. The company I work for wants me to automate a login (coupled with a phone dialer) to a national Satellite retailer. When the call center individual gets a call the ACD system forwards them to a URL and is supposed to log them in. Unfortunately one of the sites heavily uses frames and I cannot programmatically autofill the userid and password and programmatically press the "OK" button on thee website. The website is: [URL]. I have been able to drill down and fill in the userid and password fields, but this has stopped working but I have never been able to Invoke the OK button event.
View 2 Replies
Jul 8, 2005
Im new to vb (used to dreamweaver doing all the work Now im in to progging for pc instead of web LOL
right I have 8 text boxes restricted to 4 characters each, have set the tab order but want to curser to move to the next text box automatically after the 4th character has been entered in each box (if that makes sense!)
An example would be on windows xp setup when you type in the product key the curser moves to the next box after the 5 chars for that box have been entered!
View 7 Replies
Apr 1, 2009
I am writing a program for FEMAP API interface in VB 2008 Express. Some API commands open user dialog boxes which requires yes or OKcancel inputs. So much for automation "Sendkeys" do not work, because code execution stalls at the line which opens the dialog boxes. I need stg that runs in parallel, watches for these dialog boxes, and sends the right keystroke at the right time.
View 7 Replies
Dec 31, 2009
Microsoft's scripting languages (VBScript and JScript) have a POPUP method that allows you to control the time span a message box is displayed on screen before the message box closesI've searched but I do not believe that this functionality (i.e. ability to control the display time) is included in the VB 2008. If I'm wrong can someone point me in the right direction? If I am right and VB2008 only offers a standard message box, can anyone how they have created popup types of messages that only exist for a specified amount of time.
I have a situation where I would like to display an informational message box on screen when an event takes place but I don't want the user to have to acknowledge the event by having to press the OK button as the machine may or may not be attended at the time the message is displayed. If someone is present they can either acknowledge the event by pressing OK or simply waiting for the specified timeframe has elapsed.
View 3 Replies
Aug 4, 2010
Using this
TxtBox = New TextBox()
With TxtBox
.Name = "T" & reader("area").ToString
.Visible = True
[code]....
The name would come out like "T3" Now I want to put a value into that textbox.How can I address the correct Textbox?
View 8 Replies
Jul 13, 2010
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?
View 2 Replies
Jul 22, 2010
I have combo boxes for user choices on the form. One combo box for name, one for phone number and one for email. I first created that to allow user to make select in each combo box. As more "user friendly" interface, I I would like to associate the selection made on cmbBxReqstrName with corresponding phone number and email and cause the phone number and email combo box to "auto fill" in their respective combo boxes based on the selection in the cmbBxReqstrName. It was suggested to me that a two dimesional array might be an option. I read up on arrays but don't quite comprehend the coding part to access the data in the array and fill that to the combo box or I guess use the index from array to index the combo box list.
View 5 Replies
Nov 3, 2010
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.
View 5 Replies
Jan 23, 2011
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.
View 9 Replies
Jan 23, 2011
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.
View 1 Replies
Jul 5, 2011
Im trying to make a program that allows the user to view additional information via moving the cursor over the label to view (make visble) additional information, in the form of text boxes and/or picture boxes. How will i go about doing this?
View 6 Replies
Feb 27, 2009
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 Replies
May 22, 2012
I 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.
View 2 Replies
Mar 20, 2009
what is the syntax to clear a combo box and also a list box?
View 3 Replies
Jun 5, 2009
I am trying to just write something to a cell in a sheet and I am getting the error message:
Exception Exception from HRESULT: 0x800A03EC Stack Trace: at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
[code].....
View 2 Replies
Jan 23, 2010
I have some operations of Picture Boxes etc being performed. After the user finishes with the formatting, I want to give the user an option to print the work.But its the work is not done on the Rich Text Box but on picture boxes. I am not even sure, how many of the picture boxes would be there after the user finishes the job, since I have provided option for dynamically creating picture boxes as well.
View 3 Replies
Oct 7, 2010
I am trying to follow the book 'Sams teach yourself VB 2008'. It was going well until the end of hour 4. For exercise 1 I have created the form with a button and two text boxes, but cannot work out the code I need to move text between the two boxes. The Object Browser does not seem to help - am I reading it wrong?
View 14 Replies
Oct 12, 2011
All functions done, but the main function, the autorun and auto hide didnt work like i wish. for this keylogger, im using checkbox to make it autorun when windows startup and another checkbox to autohide. i already placed the codes but nothing happen. when i tick those checkboxes n restart my pc, nothing happen. is it because im using checkbox?
View 3 Replies
Oct 1, 2009
I am new to VB and am trying to get my webbrowser1 auto refresh on a web page every few seconds. Is there a way to program a button to do this? I am also trying to get the browser to auto select "yes" when a radio button is present and then auto click "yes" on a message box when it pops up. Any ideas where to start?
View 2 Replies
May 8, 2009
how to move info from text boxes on one form to binding source text boxes on another form. I am displaying array info in text boxes on one form and i need to add them to the database on another form. How do I do that?
View 5 Replies
May 20, 2008
I am trying to fill form located here [URL] web browser control.i am using below mentioned code
Private Sub WebBrowser1_DownloadComplete()Dim looping As IntegerDim hDoc As MSHTML.HTMLDocumentDim hCol As MSHTML.IHTMLElementCollectionDim hInp As MSHTML.HTMLInputElementDim hSub As MSHTML.HTMLInputButtonElementDim hTxt As MSHTML.HTMLInputTextElementMe.Caption = WebBrowser1.LocationNameIf WebBrowser1.Busy = False ThenFor looping = 1 To 10000NextSet
[code]....
i am also unable to select radio button regular link.I just want to know how to add text to textarea box "Description" and also want to know how to select specific category from combobox category.
View 1 Replies
Mar 15, 2012
My problem in the Combo Box and SQL query .. I have three comboboxes linked to an Access 2007 database
[Code]...
View 6 Replies
Jan 11, 2010
I'm trying to fill a DGV from a (List Of).. This is my code. It's not working & I don't know why..
Public AllBooks As New List(Of Book)
Public dgvInventory As New DataGridView
Private Sub BookDetails_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].......
View 7 Replies
Nov 4, 2010
Ok basically I want to select a point on a bitmap and then fill all of the color that is the same as the color at that point touching that color with a different color. If that sounds confusing, just think of the paint bucket tool in mspaint or photoshop. Currently I do this by starting with the point selected and then check all the points around it in an ever expanding box until at last no new contiguous points of the color to replace are found.The bad news: This is slow as heck =(I remember my windows 98 computer could handle this just fine with no noticeable delay. So I'm either missing something algorithmically (is there a better approach) or VB.net is just too slow to accomplish this without some sort of different approach/optimization.
[Code]...
As you can see, right now I just select the middle point as where I want to start filling from, and I fill with the color aquamarine. later I want to make this more flexible, but right now I just need this to be faster.
My general algorithm works like this:Start with a 3x3 pixel box with the first pixel (already changed to your new color, with the old color stored) as your start point.Check if each pixel is the color you stored (the one you're replacing) If it is, check if it's next to the new color you're replacing the old color with. If it is, replace it and increase the size of the box.The process ends when no new pixels are replaced.
View 7 Replies
