Data Entry And Calculation?
Oct 9, 2010
I have a program to make for a class i am in and i am stuck on this one part, its a form application where you have to enter the first and last name of five students along with their final grade then you click a submit button after each one and i need it so that after all five buttons are clicked it activates the summarize button and i can't figure out how to do that and another thing when you hit the summarize button it has to compare the grade against the value of a text box containing the pass threshold to amount how many passed or failed.
View 1 Replies
ADVERTISEMENT
May 3, 2011
I have an application that has 3 list boxes, one selects a workshop, the other a location. the third is to display selected costs.to do the calculation a loop is required. i have written the code but when i calculate the cost the final result to be displayed ends up as being the cost of the last work shop and location * 3,What is supposed to happen is the location is multiplied by the number of days(3 in this case) and added to the workshop cost.the loop is supposed to add all cost from the list box till all have been added.what is happening is the calculation goes to the last entry as stated the multiplys this total by number of days(dbl)?
View 1 Replies
Oct 13, 2010
Currently we are using a VB script macro created in word to create some fairly simple forms based off of data entered on a data entry form. I am very new to VB, and I have been able to create many applications using forms, but I have absolutely no history creating reports. I have been reading up on the reports, and it looks like they are designed to use with data sources like tables. I merely want to take either data from the entry form, or from data derived internaly from processing the user entered data and populate a defined report "form". I have been searching, but there is so much on printing reports, that I feel overwhelmed. I am not looking for the exact answer as much as a link or place to look for a sample for what I want to do.
View 2 Replies
Oct 26, 2010
create website involving payments plus some data entry eg booking of some facilities with the main data kept at a LAN window system.
View 4 Replies
Apr 16, 2012
CODE:
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
View 2 Replies
Dec 22, 2010
I have here a huge csv file with millions of rows entries. I want to load this data in a vb.net application, what datatype should i use, datatable, array or sth. else? It needs to be as fast as possible. how i can optimize the loading of the data? I once loaded this data in a datatable and it took days.. then i exportet it as xml data and loaded this xml file with the data. this was about thousand times faster.
View 5 Replies
Dec 19, 2009
I need to store a calculation to use later and obtain a new calculation
[Code]...
View 4 Replies
Sep 26, 2011
I have an application that receives data input from an automated set of devices. This data stream I have managed to capture & get it into a list box which I can sort based on the Device ID & the time that the response was received.There is a set time window for the devices to transmit their data into the application and during this each device is not limited to the number of responses it can send (ie :- Device 1 can send in 2 responses where Device 3 can send in 40 responses, etc).All of the responses are captured, listed & sorted within the listbox (this bit is working ).I now need to extract the last (ie:- latest) entry in the listbox for each Device ID & this is where I am stuck. I can retrieve the last item in the list but cant seem to extract the last item for each Device ID.[code]
View 2 Replies
Sep 21, 2011
Basically, our users enter values onto a spreadsheet and I have been asked make the spreadsheet output to a CSV file preferably each one completed appears as a single line in the CSV.Upon examining the spreadsheet, I cannot figure out the best way of acheiving this, or if it is easily acheivable in the first place.I have attached an example of the spreadsheet data, to give it some context the spreadsheet records times that carers have visited a client, which can happen many times a day over many days per week, there is also a yes/no for each day on the sleepin.
View 5 Replies
May 27, 2009
I have a data entry screen to collect data. At the bottom of the form I have buttons to add a new record, save current and add, save current and end, and an end without saving. The buttons all function properly. After clicking the save current and add new record button, a new blank record comes up with the cursor on the save current and add button. I haven't been able to figure out how reset the tab order so the first field in the entry screen is ready for data. I'm coming up empy on my research.
View 2 Replies
Jan 11, 2011
I have used the following code to get bandwidthIt works but i have following doubts1.I need Total Internet Data transferred in MB, how do i convert?, total data transferred (download+upload) varies with other bandwidth monitoring applications. how do i get exact data transferred?2.I need to exclude file transfer in local LAN in Data Transfer, The follwoing method includes internet data transfer + Local file transfer
Option Explicit
Public Enum OperationalStates
MIB_IF_OPER_STATUS_NON_OPERATIONAL = 0
[code].....
View 1 Replies
Jun 22, 2010
I have attached that file. The sample of data are as below:
PUBLT 167_89 656 PB -38321.478 6807.984 657 PB DAUD 200005041 278.271074.5150 69.4035 08370074.1830 69.2755 083800254.1925290.4620083900254.5615291.010008400008390098.2710 74.3630 20.3943
[Code]...
the main problem here is i want to use 2 value from 2 line in one time to do that calculation... if those data in one line its not a problem..
View 10 Replies
Jan 18, 2012
i need to take data input from a textbox such as this
13:41 A spider loses 20 hitpoints due to your attack.
13:41 You gained 18 experience points.
13:41 Loot of a spider: 2 gold coins, meat
13:41 A wolf loses 25 hitpoints due to your attack.
13:41 You gained 27 experience points.
[Code]...
View 8 Replies
Sep 8, 2009
i am pulling together a cash register that will allow both bar code product entry and manual key entry.imagine if you have a tin of beans in front of you, in a small corner shop they would probably type "47" and then hit "Produce". Fairly straight forward as I have the button Produce to act upon my code and update my salestrans.mdb but,if you scan the bar code I want the same form to handle both 'real' actions, (i assume that keyboard emulation barcode scanner includes "ENTER" after providing 13 digits)....
Q. in perhaps a long winded way i want to know how to kick off an event based on the "ENTER" key being activiated by the barcode scanner)?i do not want to have to hit any buttons if i am scanning bar codes.
View 9 Replies
Nov 4, 2011
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
View 2 Replies
Nov 14, 2009
I am trying to create a data entry wpf form and I am getting the following error when trying to create a window1 loaded event: "table name table adapter is not a member of file name.new data connection set table adapter.table adapter manager" I understand the error message and checked all my names but to no avail. Below is my class statement and window 1 loaded event:Private data connection as new data connection setprivate tatable as new data connection set table adapter.table name table adapterprivate tamanager as new data connection set table adapter.table adapter managerprivate view as collectionvie
View 1 Replies
Jul 1, 2010
Suppose I have a parameter query called FillByStatus in my "Customer" DataTable and I want to fill the CustomerTableAdapter On Form_Load using this query. So I can do that by using the following code:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.OrdersTableAdapter.Fill(Me.CustomerOrdersDataSet.Orders)
Me.CustomerTableAdapter.FillByStatus(Me.CustomerOrdersDataSet.Customer, "Active")
End Sub
View 3 Replies
Jul 10, 2009
I am trying to make a program with a bar code reader for the first time. I am programming with VB 2005. I want to differentiate a bar code entry to keyboard entry. My questions:
1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
View 2 Replies
Dec 29, 2008
I'm new to developing and I work for a small company. I do have previous Microsoft Access experience and have used VBA code to enhance Access applications. But now I have been asked to develop a form for data entry using VB.NET. Is it possible to create a data entry screen from VB.NET that adds, saves, retrieves and manipulates data without using a database for storing the data. Users will not have Microsoft Access (or any other database) installed on their machines. They will only have the .exe file that I create after compiling the VB.NET application.
View 7 Replies
Jul 2, 2010
Using this tutorial How Do I: Create a One-to-Many Data Entry Form? as a reference Suppose I have a parameter query called FillByStatus in my "Customer" DataTable and I want to fill the CustomerTableAdapter On Form_Load using this query. So I can do that by using the following
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.Load
Me.OrdersTableAdapter.Fill(Me.CustomerOrdersDataSet.Orders)
Me.CustomerTableAdapter.FillByStatus(Me.CustomerOrdersDataSet.Customer, "Active")
End Sub However, when I do that my related DataGridView (orders) is empty, how do I make it so that doesn't happen?
View 1 Replies
Jun 18, 2012
Back on my form with a ton of financial data entry textboxes but I want to have the data formatted at runtime, as I enter the data.I have a format declared as Public Const cFmtCurrency = "##,###,###" ' don't need decimal for the local China currency What would be the least compicated way to have these textboxes (19 of them) format the Long Integer values as I enter the data. I think a Lost Focus event would be silly; there must be a better, more efficient way.Also want to use this format when I retreive records from the db (don't see a reason to mask data in db)
View 7 Replies
Apr 28, 2009
Im new to this forum and VB Programming. I have installed Visual Basic Express 2008 and SQL Server. The first thing I did was create a new project and within that project created a new sql database. The database I created is to keep a list of clients and I have fields such as client_ID, Firstname..etc The next thing I did was create a data entry form for all the database fields using textboxes. Also 2 buttons named save & cancel. So when the user fills out the client info and clicks on save I want the data to be written to the client table. I know the code has to be written within the save button but I don't know where to start like opening the connection, writing to the database and closing the connection.
View 8 Replies
Feb 3, 2011
I wish to implement a Quicken like data entry into a text box. If you have used quicken check register, you know when you start typing into the Payee field, it presents you with a list of payees that match what you have typed so far as well as the catagory, amount etc.
I wish to implement similiar functionsality in a VB program (VS2008). I have some text(description) and a few atributes which are associated with the description.I wish to persist the data and am thinking about using a text or xml to do this.
I really think that a database would be overkill. I am looking at the textbox's auto complete property. The documentation says that the AutocompleteCustomsource is"AutoCompleteStringCollection" and am wondering how to really use this. I had started by thinking that I would
set up a dataset object (its native ability to read/write xml being a plus) but am wondering how to associate the customsource with the appropiate column in the (one) table in the dataset. The other possibility I am thinking is building my own class(probably inheriting from sorted list) that would also expose an AutoCompleteStringCollection.
View 8 Replies
Jan 5, 2010
I formatted my datetimepicker like this "dd/MM/yyyy". I want to move curser once the user enter date then (without enter '/') go to month and then go to year.
View 5 Replies
Dec 7, 2010
basically, i have a database full of records and i want my list box to be able to display all the data from one column in one table in it. i can do this, but only when i enter the same amount of items into the listbox's "items collection" as the number of records in the database. other wise with my code alone, i get this error message:
Incorrect coding?:
ListBox1.Items(inc) = ds.Tables("TTDB").Rows(inc).Item("ChildName") -
Error Message:
InvalidArgument=Value of '0' is not valid for 'index'. Parameter name: index
[code]....
View 1 Replies
Feb 13, 2011
I use in java JTable looks like a excell sheet create columns and rows and enter data in it.In vb 2008 what control i can use, I think table control layout not supported to data entry it supports control to in it and then add data .
View 1 Replies
Aug 21, 2010
I am using vb 2008, DataBound Controls and typed dataset. My form is having Group Box (initially hidden) and some text box, combobox controls for Data Entry, and the code is
bsSales.AddNew()
txtCreditDays.Text = 20
dtDueDate.Value = dtSalesDate.Value.AddDays(txtCreditDays.Text)
cboGodown.SelectedIndex = 0 '
Default
gBox.Visible = True
dtSalesDate.Focus()
I have set the combo box to select the 1st record in the list however, when the next Statement that is "gBox.Visible=True" is executed, the Combo Box is again set to -1 position. Why is it?
View 2 Replies
Jun 21, 2010
how can i control Data Entry in 3 different table with BeginTranaction / Commit /Rollback in vb.net 2008. i am using sql server 2000 at back end and used SqlClient,SqlConnection, ExecNonQuery method.
View 1 Replies
May 24, 2010
I am developing a data entry s/w for entering data from Scanned PDF Documents,
how to show pdf document side by side to vb.net form to easily enter data
View 3 Replies
Apr 16, 2012
If I wanted a character in a datagridviewcolumn replaced when it's typed, not when the cell is left, how could I achieve that? Is there an eventhandler tied to that?
View 1 Replies
