I'm doing project using richtextbox and want to save the contents in Access. But my contents is a list and when I saved it, the list become one line, with a square to space it. Can it actually be done? I set the column with memo type. Here's my code for save it.
[Code]...
Basicaly as image shows this is how my richtext box displays the info.[code]...
View 2 RepliesI have encountered a problem at the end of my project. I basically have a really nice RichTextBox control which I have made with help from others, which supports images, text colors, text higlighting, text size, background colors, etc. My problem has come when I try to save the data from the file - it loses text color, formatting, images etc. Is there any format in which I can retain the formatting or should I make my own file type with all the data embeded in a HTML-ish sort of structure, eg:
[Code]...
I have a rich text box in one of my applications (WPF). Now I want to store the data of the rich text box along with its formatting (e.g. bold, colored etc.) into a database (SQL Server). Currently I am storing the whole XAML of the text box in a database field. however, I am not sure whether this is the right approach.
View 2 RepliesWhat is the code to save changes made in a project to a database (MS Access).I have a program which is a database controller for DVDs that I own, and I have all the text boxes etc there, but I have no idea how to save records to the database.
View 1 RepliesI need to make a program in visual basic that when the user presses submit on form2 it saves all the following info from the textboxes to table1 in the database.
UserID (on form1),
Reelno (on form2),
Weight (on form2)
And a dropdown menu on form 2 called type
I'm trying to save scorecard information from a visualbasic program to an access databasse. I have tried binding the text boxes but am unable to fill the text boxes with the appropriate information. So i have tried the following code:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim MySC As OleDbConnection
Dim Command As OleDbCommand
[code]....
The program runs completely and has no build errors, but I receive the following error when click on the save button.
Unrecognized database format 'F:\CINS137\BlueYahtz
Solution\BlueYahtzScore.accdb'.-Microsoft JET Database Engine
I'm building a tabbed text editor and I'm trying to access the richtextbox inside the tabpage.
Dim wordcount As String = ""
For Each RichTextBox In tabMain.TabPages(tabMain.SelectedIndex).Controls
wordcount = RichTextBox.text
Next
right now thats how I'm accessing the control inside the tabpage and it seems to work but it seems like there should be a different or easier way to do this. Anybody know of a better way to access the child controls?
I am looking for a way of selecting and modifying a specific line of text as it appears in a rich text box; is there a way of doing this? Visual Basic User.
View 14 RepliesDoes someone can help me out to a RichTextBox recording a name, surname, telephone number and address in the Access Database Table, where the name is repeated every 5-th line in the RichTextBox, the same name each of the 5-line phone every 5-th line, address each of the 5-line. my code is.
[Code]...
In my project the "teacher" must enter grades in the Grades database then save it and click the Semester Average button(btnSA)to display the grades in the database. Well I can't the the data to save. After I completely fill in the grades and click the save button in my tool strip I get the following error "OleDbException was unhandled: Command text was not set for the command object"
Public Class Form1
Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=GRADEBOOK.MDB"
[code]......
I have a VB2008 programme that accesses and stores data in a MS Access (XP) Database. I also live in the UK and am use to our funny old ways with dates (today is the 5th April 2010 so I want the Short Date as 05/04/2010 not 04/05/2010)
I am using the following code
Dim d1 As DateTime = DateTime.Now (#04/05/2010#)
Dim why As String = FormatDateTime(CDate(d1), DateFormat.ShortDate) which is 05/04/2020
UpdateRecord("latest", why, "backups", (index value in the table)
The last line runs an SQL query to update the table column latest to the date today but whatever I do to get the date as 05/04/2010 it is saved as 04/05/2010. I have tried setting the culture to "en-GB" at the start but this does not work. It does not matter if the latest column is in Date/Time or String format
I am not able to save an image from a form1's picbox.image into my access DataBase. How can i Save the image into access db and which datatype do i need to use for saving an image into accessdb.
View 1 RepliesI'm creating this small application that will control some equipments based on its bar code and the owner picture. everything is working fine, except the picture. is there a way to save image to access database using ADO Connections andor recordsets? I've head its possible to store the path and the retrieve.
.AddNew()
.Fields("Nome").Value = txtName.Text
.Fields("CAI").Value = txtCAI.Text
[Code].....
I am trying to save my data on datagrid to access and I got this error :| Object reference not set to an instance of an object. and is referring to this Me.myDA.Update(Me.myDataSet.Tables("Goods"))
Here's my code
Public Class frmGoods
Dim con As New OleDbConnection
Dim myDA As OleDbDataAdapter
Dim myDataSet As DataSet
CODE:.......................
i am getting this error and i cant spot the mistake: No value given for one or more required parameters.
my code:
Sub UpdateCustomer(ByVal HCNNO As Double, ByVal Forename As String, ByVal Surname As String, ByVal DOB As String, ByVal Gender As String, ByVal PasID As String, ByVal
[code].....
I think I have a simple problem but I have worked on it for many hours over the last few days without success. I am just trying to save a new record with VB 2008 to a very simple Access db with 4 fields in "Table1": "Part Number", "Description", "QNTY" and AutoID. The latest error that I have trapped is "Syntax error in INSERT INTO statement". Here's what I have:
[Code]...
How I am going to show the data from the database into richtextbox?
I can connect and load the database into the richtextbox to show. But the question is that the rich text box only show 1 record. But there 3 records in the table.
My database contain 1 table name "Staff". The field: "Staff ID, Staff Name, Staff Gender, Staff Position, Username and Password".
Is it possible to save RichTextBox.Text to an Access Database and retain all of the formatting like font size, color and style?
View 2 RepliesI 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 am happy that there is a forum like this with very supportive people.So on topic.I am a student creating an Inventory System software for my school using VB on VS 2008.I am having trouble saving items from a DataGridView to Access 2007.The codes I browsed here are quite different from what instructors teach us at our school.These are some of the codes we are using to save items from textboxes to Access 2007 database with a table named studenttable and database named student for your added information.
[Code]...
I 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 Repliesrs.Open("select * from CSOptions where OrderNumber = '" & cbstrCurrOrderNumber & "' and OrderLine = " & CBLI, strConn, 2, 2)
If rs.EOF Then
rs.AddNew()
End If
[code]....
I have tried it by the following code [code]there is no error in this code, but it didn't work well.so is there anyone who can help me in making it work?
View 1 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 tried this but does not work..
dsNewRow.Item("picture") = PIS.PictureBox3.Image
Private Sub PictureBox2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PictureBox2.Click
openimage.Filter = "All Files|*.*|Image Files (*)|*.bmp;*.gif;*.jpg;*.png"
[code]....
how can i save the path of the picture i've browsed. i'm using vb.net as my front-end and ms access as my back-end.
View 2 RepliesI 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 RepliesOkay what I have saves my stuff to the database. However, when I rebuild my application the previous data is gone. The data is loaded into datagridview using
[Code]...
i am making a project on VB.NET in which my text boxes have FONT property set to "TERAFONT-VARUN, 12pt " which is for GUJARATI language.Now i want to save the data of text box into my MS ACCESS data base. I also want to retrieve that data for other purpose.
View 2 Replies