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.
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.
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.)
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]
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.
In VB.NET I would like to create a complicated data structure with multiple types of data stored in an array like format (see below). I am trying to create a data structure that would look something like this: [Name; xLoc; yLoc; zLoc; [Jagged Array]] Note: Name needs to be dimensioned as a string, xLoc and so forth as integers. The Jagged Array would look like this:
I have an Address Book project with a listbox. The listbox is bound to the database via the little arrow pop-up box in the corner of the listbox. I have the DisplayMember set to FirstName, and obviously only display the First Name of the contact in the ListBox. Is there an easy way to change it so that it displays the First and Last names? I can't change the binding because I need it to get the ID of the record selected.Here's the basis of my code...
Private Sub MainForm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'CompanyDataSet.Contacts' table. You can move,
I want when Push Button data from Excel(The next cell data) go to the next Line in Textbox.
Private Sub Button18_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button18.Click Me.TextBox1.Text = wshTest.Range("B2").Value
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
The above line prints the data contents of the ROData array in position three. I would like to be able to assign a specific position accross the line to have the printer print the data at without left padding the array data.
I am trying to click on certain rows in a datagridview and have the information in the rows sent to a textbox. It does not append each row to the textbox though, which is what I want it to do. it just replaces it with the row I click on. What's wrong with my code. I have tried cell click too.
Private Sub dgProducts_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgProducts.Click Dim i As Integer
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
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.
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
I have a problem on Data Grid View.Actually, i need to transfer data from a VB 2005 form by clicking on the form which consist of a two dimensional array grid - Infact the form will consist of a picture on which a 2 dimensional array grid, which would represent the various coordinates on the map. The user will have to click on the points on the grid to export those results to the x an y coordinates on a datagrid view.
I have data formatted as an ASCII text file with easting, northing, and depth fields. I've attempted an arrayList with some success, but there has to be a better and more efficient approach.
I have a 2 dimensional array 'allData(100,2) Is it possible to write the values from this 2-dimensional array to a csv, without using loop?
currently, I have a code but it uses Interop. Unfortunately, I need to just use csv because our servers does not support Interop. Here is my code when using Interop:
I am using Visual basic express 2010. I have a set of data in a text file and I want to read that text file into the visual basic and create a chart. I am able to import the data into visual basic but I don't know how to use that data and create a 2d line graph from that data. [code]What I want to do in visual basic is create a chart like the chart created by microsoft excel.
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.
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?
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)
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.
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.
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.
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:
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 .
