Return Data From An Access Record From User Input?
Feb 17, 2011
It's been a good few years since I dabbled in VB and I'm very very rusty so any help would be great! What I'm looking to do is search an access database with user input and display the relevant record.I have a single table set up in an access database called school_info with the following fields and data:
Tres________DfE________Name_________Type
001________1234________School 1________Primary
002________4321________School 2________Secondary
[code]...
I've linked the database to my new project, connected the database and added the 4 fields to my form. When I run it, the data shows in the boxes fine.The Tres and DfE fields are show in text boxes on the VB form, and the school and Type are show in labels. What I really want to do is be able to manually type in either a Tres or DfE number into the relevant text field and have the other labels auto populate with the relevant data that's stored in the database table.
View 9 Replies
ADVERTISEMENT
Mar 11, 2010
i have a access database with two tables, one for customer and one for booking.
I then have a form application i made in VS 2008 which lets a user enter details such as their name phone number ect into text boxes.
All of the information the person enters thoughout the program is shown via labels at the end, all on one form.
Would it be possible to then have a button that when clicked saves all of this information into the access tables into the correct columns, im sure it must be possible i just don't really know where to start.
View 14 Replies
May 25, 2009
i've added new item called service- based database. after that, i've created doctor table, course table, exam table, and an empty table called exam_report to allow program selects randomly from the other tables.
how it works: first the user will get a form with many buttons: courses, doctors, exams, and exam report. second if the user click over exam report, a new form will appear with many columns. this form should has exam course - exam day - exam time - 3 doctors name who will observe the students.
behind code: the doctors shouldn't be the instructors of the course - the doctor has no appoinment in this day - the doctor has no hloiday and so on..
okay my code is the following :
Public Class Form6
Dim j, a As Integer
Dim d, f, h As Integer
[Code].....
View 3 Replies
Jun 28, 2010
I would like to develop a structure to maintain my user's text input somehow on each form to allow user to return to the form and see the prior input for potential editing. My app has four forms which accept user input and form a string for output to printer. In the eventuality that the user notes a mistake in the input after leaving the app, I would like to develop a structure to "save" the user input at the form level and allow for repopulating the text boxes with the prior user input. Make sense? I have no idea how accomplish that functionality. Maybe it's too complex for my purposes. What do the pros think?
View 2 Replies
Nov 27, 2010
im currently designing a system that enables the user to input a customer record. the customer record is broken down into 11 fields: customer id, title, forename, surname, house no, town, city, county, postal code, contact number, date of registration. Problems - i need to be able to insert the new record into a file and for them to be organized into surname order (for a binary search to work) at this moment it will only sort by first field (which is unnecessary as the customer id number is generated automatically and is all ready created in order). Also, im having trouble with sorting the array that contains all the variables from the text file.
[Code]...
View 3 Replies
Apr 25, 2011
I'm trying to create a program, that upon opening, will read an input file containing a delimited employee record. The record will contain the name of the employee, their salary and the number of years they have been employed.I'm looking to display only the name of the employees in sorted order(alphabetically) and then when the user of the program selects a particular employee, I want to display the salary and number of years for that employee.I would like the user to be able to edit the recors for the employee and I would also like to have a way for the user to be able to add/remove an employee record and update the input file before the program is closed.
View 5 Replies
Apr 4, 2011
In this application I need to allow users to enter a month as integer (1-12) then use integer tryparse to validate that input, that seems to be the easy part. I need two create two functions, one that returns the name of the month and the other returns the number of days in that month. The arrays are supposed to be defined and initialized within the function so that the main program can take the user input and call the two functions, then return the appropriate values as output to labels. I am not sure how to declare the arrays in their appropriate functions and then how to call those functions to retrieve the right value from the function.
View 1 Replies
Nov 3, 2011
Option Strict On Public Class Form1 Private Sub btnDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDistance.Click 'The btnEnterSpeed click event accepts and displays up to ten speeds from the user'and then calculates and displays average speed
[Code]...
I cannot figure out how to incorporate the number of days into the input box then get it to loop and count the number of times the User inputs in the number of days. Then I have to incorporate it into the equation to get the total distance D = MPH * Hours. What I have right now wil not count up the number of days and locks up after I input one number and will not add anything to the listbox. Because I also have to make sure that they cant add nonnumaric values and the number of hours per day cannot exceed 20. I have put things in and taken them out but it has been 2 days and I am lost now
View 1 Replies
Mar 11, 2010
I need something tje user can type in data to such a parts QTY cost etc. There are no predefined parts list so the user can enter any part name/Number and there is no limit to amount of parts that can be entered.
Does anyone have any idea what might be useful. It was thinks of a listview bu i can't see that you can type into that. I cant use comboboxs because there are no predefined list and i know there is some way to generate text at runtime (i think) but i don't know how to do it and i would prefer a clearer approach.
View 3 Replies
Dec 3, 2009
I've been working on an application for awhile that, basically, allows the viewing and printing of a maintenance database. It allows the user to view basic information for the object and then view the maintenance history. My approach for the maintenance history is simply to have unique tables per object since a history has to be kept for each, however, I'm running into a problem in the application that allows the user to view the general information from one DB and the Maintenance history from the other DB.
Say you have Object ID BG1. I can enter the object ID into a search field, pull the data from the general DB and display the data, but I also need it to pull the information from the maintenance history and display. If maintenance history for this object is not found, then create a new table within the DB, fill the columns with the required fields and allow for the user to edit the history.
View 6 Replies
Jun 15, 2009
I'm just trying to create a graph where the user can input data into textboxes and then plot the data. I am attempting to use Zedgraph, but open to other suggestions. The program below creates a plot, but it won't update when the textboxes are updated.
Imports ZedGraph
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
View 7 Replies
May 10, 2010
I have used following code to create and write the user input data to XML through Dataset. Hope it can be understood by looking the following code:[code]But the above code is not working. it is not writing the value in XML file.
View 8 Replies
Apr 16, 2009
I am using a RichTextBox to allow user data input.I need to allow a user to select all, and change the font value of the text within the RichTextBox.
View 1 Replies
Mar 15, 2012
How do I determin if a user has given me what I am asking for in terms of data type.
Example if my prompt to the user say "Give me a number of double data type"
How can I tell that the user entered a double xx.yy?
Or if I am testing for integers and I get user input ABC.GH?
I know about CDbl and CInt and CStr but these don't work unless data is provided. Also how do you test if the conversion took place? Also how do you differencate between 12.00 being integer?
View 4 Replies
Sep 30, 2009
I want to create a page in asp.net website . it has to have one text box . the user enter the productcode in the textbox and click on search . when the user click search i want to display all the information about that product from product table.
[Code]...
View 2 Replies
Dec 18, 2010
I have two pages the first one will receive all data that are required from the user such as username e.mail and then the same page will do the calculation but when clicking on result button two things should happen: 1-the result and all user inputs should be sent to the second page 2- the same information should be sent to the user email as the e.mail messege
View 1 Replies
Mar 8, 2009
I'm trying to make a program where user can input data from a textbox into an array and when the user hit the enter key, it compare it to a data grab from a text file. Here is my code so far:
Private Sub TextBox_KeyDown(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox.TextChanged
Dim input As String
[Code]....
I got the part where the program can graph data from text file and put it into an array called "varia3". The part I could not get is allowing user to enter data into the textbox. When I run the program, the sec I try to enter a letter or number into the textbox the program ended.
View 2 Replies
Apr 12, 2011
So I'm developing a Windows Forms Application in Visual Basic 2010. The user searches for data and fetches results, updates fields and some other CRUD operations. I want to provide a user input validation. Usual stuff i.e. some fields need to be always numbers>0, others need to be non-empty in order to avoid Null access on some objects and others just need to be some fixed strings.
[Code]...
View 3 Replies
Sep 15, 2010
This is what I'm trying...
Dim myCommand as SqlCommand
Dim myTable as New xsdObject.ObjectDataTable
myCommand = DataAccess.GetSQLCommand( "MyStoredProc", _
[code]....
'How to access my data ?
View 1 Replies
Nov 4, 2011
Use ExecuteSQLCommand and return my data in a datatable and access it? This is what I'm trying.[code]...
View 2 Replies
Mar 1, 2010
Im writing a data access layer for my application.There are several functions that need to return a list of items like Employee Name, and EmployeeID so it can be bound to a dropdownlist.What would be the proper datatype to return, a Dictionary?The lists only contain 2 columns, a name and id.
View 5 Replies
May 6, 2012
I'm writing a windows application that need to access the raw data of the microphone input. Basically there's an electronic circuit connect to the microphone jack, and I need to get that data and process it. All I could find are some examples of using API to save the data to a wav file or something like that. But I need to process the data in real time. Get the exactly value of the input on that time. Is it possible?
View 2 Replies
Jun 9, 2010
So far i have a really basic form application that allows a user to enter some information and does a small calculation, displaying all of the information gathered on the final form.
Im looking to try to save this information but have no idea where to start,im trying to just take whatever is in my text field and put it in a table row. I created a one table database in Access and linked it to the form with a button to try and save it.
I thought it would be as simple as tablename.rowname = textbox.text or something but apparently not and all ive ended up with so far is this:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Me.Validate()
Me.TblCustomerBindingSource.EndEdit()
Me.TblCustomertableadaptor.Update(Me.DatabaseDataSet.tblCustomer)
End Sub
I dont even think im close, ive just been fiddling with the predefined code in Visual Studio, trying import ect but the button just doesnt seem to do anything.
View 2 Replies
Apr 13, 2011
I've worked out how to display charts in VB 2010 Express, but now I'm needing the user to input data into a spreadsheet/table that will be used within the program. I know that table is no longer available and neither is the OWC11 set. Is my remaining option then to use DataGridView? I know it is SQL based and I don't have much experience there yet, but I didn't want to commit to it if there is another method that would work just as well. The values that are put in by the user does not need to be preserved.
View 3 Replies
Jul 22, 2011
I'm developing a windows forms application using VB.NET. I'm currently working on DataReport (by Microsoft, not Crystal). Everything works fine when using DataSet as DataSource. But I have a question on how am I going to put data to my DataReport from a user input? Preferably when the user is on the act of printing(clicking the print button in the ReportViewer), a Form will pop-up and ask him for input. That input I'm talking about is random names of people, and we don't have to track their names so there's no reason to put it on the database.
Here's my simple setup:
MainForm.vb (Form)
MyReportViewer (ReportViewer)
MyReport.rdlc (DataReport)
[Code]....
If it is impossible to do it on the act of printing. Maybe on the MainForm_Load event or before the generation of report can do.
View 1 Replies
Apr 22, 2011
I've created a basic search form. I have a textbox with a search button and an Access Database as the backend. I have also added it as a new datasource. What I'm looking to do is grab the search string from one textbox and return the data to another textboxt. I have a table called "VehicleInfo" and I want to search the field in my table called "VehicleID" and return the vehicleID I searched for into another textbox. I'm really new to VB. I understand databases and basic code structure, I just don't have a good grasp yet on how these two work together.
Public Class frmMain
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Garage_ServiceDataSet.Service' table. You can move, or remove it, as needed.
Me.ServiceTableAdapter.Fill(Me.Garage_ServiceDataSet.Service)
[Code] .....
View 7 Replies
Nov 19, 2009
So, I run a select statement in SQL and then it has something like " where clientName = 'John Doe' " I can generate a datagrid or dataset off the SQL statement, but it will only be good fro one client...... I would like to be able to populate a dataset/grid using the select satement and then having something like a combo box of names the USER can choose. Then the user selects the name and the datagrid is populated with that clients info or w/e........
[Code]....
View 2 Replies
May 13, 2011
I created a sql stored procedure that will insert data for me depending on user input. Now I would like to know usually I would do something of this nature
Dim con As New SqlConnection(connectionString)
Dim cmd As New SqlCommand("usp_userinput", con) 'references connectionstring and calls store procedure
cmd.CommandType = Data.CommandType.StoredProcedure 'sets default to be storeprocedure
lblMessage.Text = String.Empty
With cmd.Parameters
If (Session("UserInitials")) IsNot Nothing Then
.AddWithValue("@UserInitials", Session("UserInitials").ToString())
End If
End With
That is just an example how i usually approach calling the stored procedure in vb. However for this particular form I am going to have 50 or 60 textboxes which each one would require a session state variable.Seems a little tedious to have to create a session state variable for each textbox on the form.
View 1 Replies
Jun 21, 2010
I'm creating my Data Access Layer and I want to return my object but not all the fields so this is the code i'm using
CODE:
I then call this method in the Business Logic Layer
CODE:
lastly I try to call in in my user interface and bind it to a DataGridView
CODE:
But I keep getting this error: Unable to cast object of type 'System.Data.Linq.DataQuery`1[VB$AnonymousType_0`3[System.String,System.String,System.String]]' to type 'System.Collections.Generic.IEnumerable`1[PP_DAL.DCProposal]'.
View 2 Replies
Jul 7, 2011
The problem is I am able to extract the data by giving cell reference like: TextBox1.Text = objWorksheet.Cells(5, 2).value
But I want to select a row as per input given by user and want to extract data from that row.
The input given by user is in text format, in my case name of employee. And I have to extract address of that name.
[code]...
View 1 Replies
