I have been using an Access Database with no problems, using a form (with a sub-form) to input all of the data. Recently the data on the sub-form is not saving to the tables/reports. I enter the data, save and close the form and re-open the record and it is not there. Previously I have been able to save all data using the form and have not altered the form.
View 3 RepliesI'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
View 6 RepliesI am using thprocedure "UpdateDatabaseBySQL"to save data in to my MS Access table using VS 2010. The problem is, sometimes when I retreive the values from the database, they are blank. But my save procedure worked well. If I pause the app for 10 seconds and query,everything works. So what I did was add System.Threading.
View 22 Repliesthis code worked in every form except this form which I named Reregistration the code is working and every thing but the only problem is that the new generated data is not saved in the actual table
Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click
If txtPassword1.Text = txtPassword2.Text Then
[Code].....
I want to save new data from access tables to sql tables without overwriting old data in sql. Data table format for access and sql is same. (using Visual Basic).
View 1 RepliesI am currently working on a vb project. What I am trying to do is reading a XML file and saving all the data in to the Access DB. Once this is done, I read the data from the access Db and display it in the required fields in VB form. Issue is, when i store the value in the access, a weird character is assigned before and after the data. The character is a square box with question mark in it. Also the same character displays on the VB form as well
[Code]...
am pretty new to VB and i am slowly teaching myself .I am working on a project at the moment which will write to an access database. I have created the database with contains about 40 fields. i Have a form which the user inputs the data into whose controls are bound to the corresponding fields in the database . I have been reading up on what a could but the more i read the more lost i am getting.
View 1 RepliesPrivate Sub Table1BindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Table1BindingNavigatorSaveItem.Click
Dim dg As DialogResult = MessageBox.Show("Would you like to continue saving your changes?", "Save Changes?", MessageBoxButtons.YesNo)
[Code]....
I have a Windows form I would like to save the Ovals I created while running the form for use and review later I have been trying the SaveFileDialog but have not figured how to get my data out to the file that is created. I have read about using datatable but there again I'm working with that but need to find how to load all my Oval parameters into the table so I can recreate the current look of the form.
View 4 Repliesorking with vb 2010 and ms access as data base, just newbie.im trying to save the loged out date and time to my access table by selecting from tblloghist wherein my column SystemUserID is equal to my textbox SysID(located at my form) then it will save the timelogedout by getting the value of lbltime from my form. the problem is the data type property of my column SystemUserId is in autonumber so i got error saying "Data type mismatch in criteria expression"
Dim con As New OleDbConnection
con.ConnectionString = "Provider=microsoft.jet.oledb.4.0; data source =..systemsdb.mdb"
Dim ds As New DataSet
[code].....
I have created a form, that calculates Hotels billing, with one box I can input Number of nights a customer stayed which is £32.50 a night per room and the other box £4.50 for breakfast, there is a deposit of £25.00 which gets deducted upon departure. I have created this form with success along with a clear button But here is the tricky part- I want to create a total button which will display a summary information about the bills paid on that day regardless of how long they have stayed and how many breakfasts consumed. this should include, the total number of bills paid, the total number of nights paid for, the number of breakfasts paid for, the total amount of all the bills added together including the deposit.
[Code]...
I have a form with a group of text/cbo boxes, and two listview controls. I would like to save these textboxes and listviews into a single xml doc with a schema like:
<MyDataFile>
<MyTextboxes>
<TxtBox1>Some Data</TxtBox1>
<TxtBox2>Some Data</TxtBox2>
[code]....
and i think I can figure out how to do the text boxes, but how to I write them all into a single <MyDataFile> document root xml file?
rewriting a class I use for saving Treeview data to a XML file for use of saving ListView data I can't really figure out the rewrite, I'm stucked, unfortunately Listviews seems to be a big problem for me in general.
Option Strict On
''' <summary>
''' The TreeViewDataAccess class allows the nodes within a TreeView to be
''' persisted to xml for later retrevial.
''' </summary>
[Code]....
I am working on developing a program that needs to keep the data of radiobuttons, textboxes, comboboxes, etc. and it needs to be able to save several files(one for each different user). I found a quick solution from a forum, but it will only save the data from a textbox, or a tabpage. The solution that i have came up with, is to use the data, put it into a textbox, to save,then when it opens the file, it will use the data and put it back into the controls. (EX.)
If
TextBox30.Text =
"Full"
Then
[code]....
This does work but it does reduce some flexibility, and takes alot more programming than what is needed. I am looking for a simple way to save the data, and retrieve it.
Alright I have a settings form and when the user checks checkbox. When they exit out of the form that whole form will save in the app.
View 3 RepliesI created a form with 4 textboxes, one date picker, time and combobox. Now the problem I have is that I want to save all the values in these boxes in a folder which depends on what is selected in the combobox.
Source:
vb.net
Private Sub ListBox1_SelectedIndexChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs)
End Sub
[Code]....
The idea is that if I select 3 in the combobox, the files has to be saved in the folder 3. This folder is located on a server located in the LAN.
I'm trying to insert data from an Access unbounds form to an Access Table using the follwoing code:
View 2 RepliesCurrently I am saving data from my applications by saving a text file via a stream reader as a string. I have come to a problem. In my current application, I have an array of the following structure:
[Code]...
Private Sub btnsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsave.Click
'If inc <> -1 Then
[Code]......
i got an error at the time of execution .
I'm trying to add data from a form to an access database. I'm using this
[Code].....
To create a data access form
View 3 RepliesI'm new but will most certainly be hanging around and maybe even answer some posts in other sections. I have the following issue: I have a vb.net web page that places data into an access database. If I leave one of the fieldS blank, (even though Access has a default value of '0' instead of null) when I click to view the results in another page, the page fails with an error.
"System.InvalidOperationException: The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value. etc etc" IF I put any figure in the blank field, even if it's 0, the page functions and works. Baffling. So, the data input page really needs to check, 'if nothing has been entered, automatically append the database with 0. Here's some of the page code: (Standard Record Insertion Wizard within DW cs3, plus Validation)
[Code]...
I am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim SearchPatient As String = txtNPatientID.Text
[Code].....
I'm reading data from a .mdb access database to a form in my app. However the text is sometimes becoming scrambled as shown belowDatabase:Quote:The resistance of a 2.5mmonductor of length 8m and resistivity p = 1.72
View 6 RepliesI need to control a device with a GPIB port. I have the commands that I need to use to do this; but I don't know which is the sintaxis in Visual Basic.
For example if I need to send a instruction like "START:0.01" to the external device which are the libraries that I have to include?, how should I write the programming line to do this?
The main tasks that I need to program are sending data, receiving data, and saving data
I am creating a small program which has a few texboxes which i want to saved in a access database.My problem is i have no clue what code belongs to such button.I have added the database to my datasources, and linked the fields from the database to the textboxes.But thats all i got so far,.Being searching around the net for a few days to figure this out, but no luck.in my access db i got the fields firstname, surename, address1, address2, postcode, phone, email.Each are linked to their matching textbox on the form.
View 2 Repliesi dont know how to show the data in the ms access through visual basic, this is the form, if the details that are entered are correct, the password must popup i want it to show in the visual basic and here is my query, i dont know if this is correct, if you enter the "Question, and Qans" correctly, the password must popup
Dim retrieve = Me.LoginTableAdapter1.ForgotPasswordString(TextBox5.Text, TextBox6.Text)
If retrieve Is Nothing Then
MsgBox("Please the Correct Statement")
[code]....
I have two tables in one to many relationship in an access 2003 database.I am using vb6 and visual studio 2008.I want a data entry form (in grid view) for child table. I want to display & add, Update, delete child records accordingly with parent.
i.e. What I require is One combo box displaying a parent field and corresponding child entries will be shown in grid view. Data entry form for parent table may be on separate form.Is there a full sample source code for above mentioned theme.
I have a program in which I want to have the user enter two percentages and display the data matching the criteria on a new form. The query would be:
Select *
From Corrosion
Where corrpct1 >= {column in database} OR
corrpct2 >= {column in database}
The way I currently have it written is to display only one row of data. I need to display any number of rows that meet this criteria. My current code is:
Private Sub btnDetails_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDetails.Click
Dim form As New frmDetails()
Me.Hide()
[code]....
1. How can I do my query to incorporate the user entered criteria (in the where statement)?
2. How can I display ALL of the data instead of just one line?
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.