Transferring Data From Second To First Keeping The State Of First Form?
Dec 19, 2010
I m working with a appliction in VB.net
I have a three forms .Menu form which i have set IsMdiContainer as true
Through this form I m opening a new form named " Query"
This form has two drop down and one textbox and some other controls
When user selects ths first dropdown (States)second gets filled with City
When use selects a city I wat to open a New form named as parameter.parameter
form has two textbox and user will enter the paramater and click the submit button.
I want the text of these two textboxes in My "Query" forms 's text box and I want the drop down as it is(filled with city and states)
View 3 Replies
ADVERTISEMENT
Aug 22, 2011
I created a VBA project in Excel. I would like to figure out how to transfer the data back in forth to make a more presentable and user-friendly program in VB Studio.Basically, I need my form in VB to input data to into an excel �workbook.data�, where the calculations are preformed. Then I need to copy the finished excel data cells �workbook.results� and paste them into an end result form in VB. I have tried looking at threads and cannot come up with a solution. There is no data saved each time the program runs, so I don't have a database.
View 14 Replies
Dec 6, 2009
The first form in my project is a simple form for a shop selling cars. At the end of the form is a text box called txtTotal.text, this is the total cost of each sale. When I press the print button I not only want to print a sales invoice(I have that bit done) but I also want the total in txtTotal.text to be added to lblDaysTakings on my second form called frmAudit. Ive searched the web far and wide and cant find anything either suitable or within my level of understanding.
Ive tried code such as
Private Sub cmdPrint_Click()
Dim curTotal As Currency
Dim curDaysTakings As Currency
[code]....
and several other combinations but Im obviously a mile and a half off track as Im not getting anywhere?s a lot bigger than just the print button but I didnt see the point in posting the rest as I have everything else sorted out, its just transfering the numbers from one form to the other thats getting me.
View 5 Replies
Jan 7, 2010
I have the following code in place: Protected Sub btnBuy_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnBuy.Click Session("ShoppingList").add(New OrderInfo(txtQuantity.Text)) Server.Transfer("ShoppingCart.aspx") End Sub
View 5 Replies
Jun 12, 2011
The title of this thread perhaps does not explain my problem correctly.Actually i am developing a financial software for a company.The software is similar to a banking system. The software is being developed using VB 2008 and SQL Server 2008.The company has its branches located at different locations. They are having a centralized SQL Server at their Head Office.The branches are connected to Head Office using a VPN.Now what we are worried about is when the VPN gets disconnected.For that we will be having a SQL server installed at each of the branches.When VPN is connected the the details entered will be directly at the Head Office database,Meanwhile a program will be executed which will get details from the Head Office database at each of the branches in a XML file.When a branch gets disconnected from the VPN another program will get the XML details into the Sql Server installed at the branch. When the branch is connected again Another application will create a xml file from the local server and insert its details into the HO server.The sizes of the XML are reaching upto around 150 to 200 mb. I am using Dataset.WriteXML and Dataset.ReadXMl. I have tested this on my local machine it is taking upto 30-40 secs.I dont know how much it will take when the actual application is installed. How can i speed things up ? Does anyone have any idea on how i can do the whole process more smoothly and faster?
View 5 Replies
Jan 3, 2006
I wanted to write a small piece of vb code to synchronize a few FoxPro dbf tables to SQL tables that having the same structure or at least a few fields that i selected. I had tried a code which I found on the net that running row by row and column by column to update the SQL tables but this code is too slow. In my dbf table it contains around 3000 records at least.
View 12 Replies
Jun 17, 2011
i want 2 copy some part of one table into another but getting error @ this line
sqlCmd = New SqlCommand("insert into name_table(name) values ('" & ds.Tables(0).Rows(1).Item(0) & "'", sqlCnn)
View 4 Replies
Jun 12, 2011
I'm doing a project that requires me to create a book ordering form. I have the books displayed in a listbox named bookselectionlistbox, and when a book is selected, it displays the price of that book in a label named bookpricelabel1. I have a button named addbutton that allows the user to add the book to the shopping cart. The shopping cart is in the form of a combobox named shoppingcartcombobox. Lastly, there is a receipt button that transfers ALL the books from the shopping cart to a seperate label called label3, not just the selected book. The last thing I need to do is have the price of each book also transfer to the receipt section. This needs to be done either on the same label3 on the same line as the book title, or on a seperate label that is adjacent to label3, I have temporarily placed a label there named label5. I am using a case statement for the bookselectionlistbox to say that when a certain book is selected, the bookpricelabel1 will display "$xx". I also have an IF statement under the addbutton label that generates a total price for all the books in the shopping cart, here is an example of the code I used for one of the books:
[Dim visualbasic As Decimal]
[If shoppingcartComboBox.Items.Contains("Visual Basic") Then]
[visualbasic = 55]
[Code].....
View 4 Replies
May 18, 2012
I would like everything in listbox1 to transfer to listbox2. I didn't paste my whole project because it is messy and lengthy but I was able to re-create the scenario with this code:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
bottom line, I want everything in listbox 1 into list box 2 when combo box = a and button is pushed. when I try to execute, only one or less go into the second list-box and the rest stays there!
View 4 Replies
Nov 3, 2011
So my question is that I have 2 list boxes in two forms aside from the main one. and I am trying to transfer what I choose in the side form to transfer to the list box.
several questions: Why does the blank list form I have in the main form create a problem when I enter a name for the list box and why does it appear in the box when I put it there? As you can see in my errors. It doesn't seem to recognize the listbox that I wanted to leave empty in the main form.
Second question is how do I get names to add in the main form list box. I believe I have the right code but I seem to be missing something else as well. I want the names to display in the main list box and the integers to add up together so I can separately figure the tax and shipping myself.
Here are some pictures and codes
Main:
Print:
Audio:
Public Class MainForm
Dim frmAudioBooks As New AudioBooks
Dim frmPrintedBooks As New PrintedBooks
[Code].....
View 39 Replies
Oct 30, 2011
How do you pass one radiobutton from form 2 to form 3? Iv tried:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Form2.rbtnPatterned.Checked = True Then
rbtnPatterned.Show()
End If
But that doesn't work. The radiobutton selected in form 1 doesn't appear in form 2....
View 5 Replies
Jun 6, 2011
I'm developing a project for gathering customer feedback using a Samsung Q1 Ultra, a cheap touchscreen PC. The project consists of two parts: a PC based application that builds the survey and stores the info on an SQL Server, and a survey viewer on the Samsung device which downloads survey data from the SQL Server and stores it on a SQL Server Compact 3.5 database.
My question is, how best can I transfer survey data from the SQL Server to the handheld device's database? Writing a tonne of code to copy data from one database to another seems overcomplicated - is there a handy function or somesuch that I can use to copy data from identical tables on these two separate databases?
View 2 Replies
Aug 3, 2009
My assignment involves wrinting an airline reservation brogram where the user can hit a make reservation button and the user can then input passenger name departure city and arrival city, all of this has to print to a multiline textbox, the professor also wants a find reservation button and a cancel reservation button.
Public Class Form1
Sub get_data()
Dim passengername As String = InputBox("please enter passsenger name")
Dim departure As String = InputBox("please enter departure city")
[code].....
View 5 Replies
Jan 17, 2010
How would I go about transfering data within textboxes on 1 page, to the same textboxes, but on another new page.
Basically, I already have coding that caluclates distance time, price per litre of petrol (it's a bus firm company application), and put's it into textboxes within a group box on my page. Basically I just want a bit of coding which will transfer this info, to different texboxes, but on a different new page, the idea is that I can then do fresh coding on that page without it interfering the coding on the current page.
View 2 Replies
May 4, 2011
Visual Basic 2010.I excel in transferring reports on problems in formulas..[code]
View 3 Replies
Mar 7, 2011
I want to transfer my data from one list box to an other and save the data and display it at the same time with the TIME, Name, and the Quantity. For example, if I have a movie ticket, and says I bought one ticket thats 10 dollars. If I did type all the calculations with tax it should be 10.10 for the 10% tax. This will show on first of my list box. Secondly if I press something like Enter, it will show that 10.10 number and also put it in the other lstbox. I have 3 list box. One to show the current transaction, one to show the history of them and the total amount of all transaction.
View 8 Replies
Dec 28, 2010
I am new to ADO.Net and I mistakenly using the dataset as how we use recordsets in ADO., I know that it is possible to create a Datatable which will only reside in the memory and hold data. What I need to create is like this.
1. Create Datatable.
2. Fill it with sample data at least 3 lines.
3. Transfer the data from datatable to database (access,sqlsrvr etc).
View 2 Replies
May 27, 2009
I have 2 forms in this application. One form is just a simple SQL statement that is generated into a grid. It displays columns/rows. From there I want to be able to click on a row and have the first column of that row transferred to another form. In the second form I want it inputted into a text box. So, the user doesn't have to copy the record back out of the form then open the other form and paste.
The form opening and closing is not the problem. The problem is getting the data to transfer from one form to another!! I am not sure how to do it.. I have only been coding in VB for a few days and no formal training. I am aware of global variables and would be willing to assign the data to a variable and then have it transferred into the textbox of a the second form.
I do not know how global variables work in VB. This is what I got so far............
'The user clicked the transfer button.
Dim obj As System.Data.DataRowView = grid.Current
MsgBox(obj.Item(0), vbInformation, "Selected Data")
[Code] .....
View 2 Replies
Jun 7, 2011
I have a listview and Contextmenustrip control. Listview contains one coloumb. How to transfer ListView data to ContextMenuStrip?
View 2 Replies
Apr 28, 2010
I am working on a project that has the user building scrapbook pages through several different forms. When the user selects something a presses a button I have the information about the selection load to a list box which is on a CheckoutForm. One of the options I have is for the user to save what they have made (this includes the information in the list boxes) and return to a previous form to build another page. I have been trying to use the Me.Close() but it does not save the information and using Me.Hide() displays the wrong elements on the forms.
View 5 Replies
May 3, 2009
I'm taking my first (and only) beginning programing class for Visual Basics 2008. I'm working on my final project and have hit a snag. A little background info - I have been able to code everything except for two final steps (but they are my most difficult steps), on these final steps I've gotten two suggestions on other sites, one person helped me with the coding which I used for my form1, but it I still have several errors, and another person suggested that I use a module.
Here is the issue. I have totals on three forms that need to pass through to a final form, and once they are on the final form they need to show up in an itemized list and need to then be totaled again. I actually have a total of 5 forms including my first form aptly named form1, which incidentally is where someone told me I should set up my whole 'connecting the totals' form, and I believe the guy was on the right path with helping me but, I'm still obviously pretty lost on this last segment of coding. Since I had little difficulty with the majority of my project, I didn't think this last bit would be so difficult. I'm going to list my coding for each form below. My project is due Tue morning May 5th Eastern Standard Time, just in case someone starts reading this on or after that date. Just in case it helps explain the issue, I will also post my listing of error codes from my VB project, and they all are centered around my form1 (which is the form that I'm trying to set up the transfer through of the form totals). I also see that I can post attachments so in case it will help I'm going to post my project in the attachment too.
Error Codes:
Error1Event 'Load' cannot be found.
Error2Handles clause requires a WithEvents variable defined in the containing type or one of its base types.
[Code].....
View 1 Replies
Apr 23, 2010
using Vb net (2005) Wandering if it is possible to use AppSettings in this case: Keeping counts how many time my Win Form app. has run, could someone show me if this can be done
View 4 Replies
Nov 9, 2011
Basically i'm coding a application that can be used as a crosshair.How do I keep this above the game which runs in fullscreen. I've tried
View 5 Replies
Jun 28, 2010
I have written a VBA code in EXCEL that updates my tables in Access. The code is fully functionnal when I am entering new data but I don't know how to make it work when a data (primary key) already exists and that I need this data for another table. I would like to find a code in this format (DAO) :
If value exists in table Then
Return the value.code (not the value but the code related to this value)
else
.addnew
here is what I have tried but does not work:
Code:
Function Find_Last_EngineCode() As Integer
Dim cn_engine As ADODB.Connection, rs_engine As ADODB.Recordset, feuille As Worksheet, plage As Range, last_record As Integer
Set feuille = Application.ThisWorkbook.Worksheets("To_Access")
[code]....
View 1 Replies
Apr 5, 2009
I have a psychology experiment that has users respond to specific text or pictures by pressing either a button for "similar" or a button for "opposite" and then the program records the time from the presentation of the stimuli to the time they press one of the buttons as the latency. I have the information ans some other data successfully exporting to a text document but would like to have just the latency data also go into an excel spreadsheet for easier analysis. Here is the code for one of my buttons that currently writes to the text document:
[Code]...
View 3 Replies
Apr 16, 2009
I'm developing a management program for a driving school, where information about all students is stored and accessed.
The thing is, this school has got two branches, so I need some way for those two computers to share files with each other in order to keep a common database. I would like to use the same program in both computers, to keep simplycity to the maximum.
I know it's using TCP, but I haven't got the lesser clue of how i can achieve that. I've looked around, but I haven't found much of how to acchieve something like that. The files both computers would be sharing are text files.
About the IPs, I'm thinking of using NoIP or one of those to always know both IPs.
View 1 Replies
Jan 16, 2010
Im having a problem when transfering values from form to form.Firstly I have a main menu form,click on a button to go to the dell components form.I choose the components for the computer and when i hit calculate the total is displayed in a textbox for my subtotal. When i press send it will send the sub total from the dell components form to the grand total and display it in the dell sub total in the grand total form.This part works ok, however, i go to the main menu and click on a button to go to the packardbell components form. Do the same again but when i press send, it will send the value to the grand total form in the packardbell sub total textbox but the value in the dell sub total textbox has vanished.Here is the code in the dell components form
Code:
Private Sub btnSend_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSend.Click
Dim frm As frmGrandTotal = New frmGrandTotal(txtDellSubTotal.Text)
Me.Hide()[code].....
Finally, the other problem im having is on the main menu form when I click on the view total button I get this error: Here is the code for this bit
Code:
Private Sub btnViewTotal_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnViewTotal.Click
'frmGrandTotal.Show()
Me.Hide()
End Sub
View 5 Replies
May 1, 2010
I was able to pass my calculation from Form 1 to be used in another calculation in Form2.
Module1
Public ECC
As
[code].....
View 3 Replies
Dec 27, 2009
I'm just doing a quick little application and was wondering how I can keep the user from moving the window outside of the working area I tried this
[Code]...
View 1 Replies
Apr 14, 2009
I have a program that shows a small form appearing at the top of the right hand corner of the screen. When I switch to another opened program, the form disappears. How can I keep this form visible when I switch to another program? I set the TopMost property to true but it doesn't work.
View 1 Replies
