Visual Basic :: DataGrid And Storing Data In Access

Storing Data Into Access Using VB
hI GUYS,

Normally i use this command to store data into database

adodc.Recordset.AddNew

It basically adds all the records into one particular table..

I was just wondering how do i add data into multiple tables

For and example, lets say i have 3 fields (Name, age and Gender)

I want Name and age to go into Personal table
I want Name and Gender to go into Personal1 table

How do i do that...i know how to write the sql command

For example

insert into Personal('Name','Age');

But how do i do using Visual Basic...The connection statements and all...

Is there any tutorial or anyone who can guide me through this

thankx in advance for any help

Storing Data To Access Problem
Hi!

I have the following part of code

Code:
ElseIf MsgBox("Are you sure you want to add " &
txtOrdQuantity.Text & " " & txtProdName.Text & " "
& " to " & txtCustLastName.Text & " " & txtCustFirstName.Text & " orders?", vbOKCancel) = vbOK Then
txtOrdDate.Text = Date
data_Orders.Recordset.MoveLast
data_Orders.Recordset.MoveNext
data_Orders.Recordset.AddNew
data_Orders.Recordset.Fields("Customer_ID") = txtCustID.Text
data_Orders.Recordset.Fields("Product_ID") = txtProdID.Text
data_Orders.Recordset.Fields("Product_Name") = txtProdName.Text
data_Orders.Recordset.Fields("Product_Price") = txtProdPrice.Text
data_Orders.Recordset.Fields("Order_Quantity") = txtOrdQuantity.Text
data_Orders.Recordset.Fields("Order_Date") = txtOrdDate.Text
Call FlexGridUpdate
End If
but the data are not saved in the database. The FlexGridUpdate is a function where i reload the flexgrid to read the whole table again with the new data but after I press "save", it reloads and adds an empty row. I'm using the same philosophy in other parts of my project and it is working fine, I can't see what's wrong with this one! Maybe i'm tired and can't see the glitch...

I have to mention that in the database, there are not blank lines and if I close and reload the form, the empty line is gone. So the problem is that the data from the textboxes are not saved in the database fields. Is it possible to be database problem? for example, wrong relationships or something? I can add data to the database manualy and my program can read them! But it can't add new records :

here's an example from another form in the same project with the same philosophy that's working fine

Code:
data_Customers.Recordset.Fields("First_Name") = txtCustFirstName.Text
data_Customers.Recordset.Fields("Last_Name") = txtCustLastName.Text
data_Customers.Recordset.Fields("addStreet") = txtCustaddStreet.Text
data_Customers.Recordset.Fields("addNumber") = txtCustaddNumber.Text
data_Customers.Recordset.Fields("addTown") = txtCustaddTown.Text
data_Customers.Recordset.Fields("addCity") = txtCustaddCity.Text
data_Customers.Recordset.Fields("PhoneNum") = txtCustPhone.Text
data_Customers.Recordset.Fields("MobileNum") = txtCustMobile.Text

Image Data Storing And Access
How can i store an image data in sql database throu vb6 project. And how can i get the same image in my datagrid.

Kindly help me to get source code

Regards

Abhijeet

Storing Data Of Word Document To Access
hello friends,

I have word document file that contains chemistry eqations and diagrams, now i want to store these information to access database
by doing programming in vb.

Give me the response as soon as possible.

Storing Data Into Variables From An Access Database
I need to know how to store infromation from an access database in to variables, in my program.
-there is 5 records and 12 fields in the database.
-i want to choose one record and load all the fields into variables

Storing And Retriving Images From Access Databse Through VB Data Report Or Crystal Report
hi friends
    i have a problem that i have a database of some 8000 students in which there is a field called "photo" which stores the photograph. it is stored as BLOB field. now i want to retrive it in my report. i'm getting very much difficulties in it. can i have a help from master minds to resove the same. it will be very much helpful to me.
    my e-mail id: nnpatwa@yahoo.com
  ur suggestions r welcome. anybody can mail me. hoping for the best.

Concurrent Data Access Through A Datagrid
Hi

I try to modify a table content through a MS Datagrid in a VB Prog. The grid is "connected" to my database through an ADODC control. Several users have to fill the table in the same time.

The soft works perfectly with one user : the problem occurs when at least two users are updating the same row : I have a message stating that the record had changed, so its update is no more possible. This message also prevent me from doin' anything else on my datagrid and I must close the form to stop it.

I thought that my ADODC parameters was wrong, so I tried several combinations : adOpenStatic - adLockOptimistic, adOpenDynamic - adLockPessimistic ...

With these different combinations I had two results : with adLockPessimistic the first problem is avoided, but my datagrid doesn't record any change
and with the adLockOptimistic I face the first problem message.

This is the first time I develop a multi-user soft with ADO and I don't know how to solve these problems.

Can anyone help me ? it would be great thanks

Data Access Error In Datagrid
I have a datagrid so that if you click on a row or column it puts the data into other controls in the program. The only problem is, if theres no data in the grid, i get a data access error. What kind of if statement can i put before it gets the data to check and see if there is any data there?

The iF statement would go before this:

Code:
dgRecordView.Col = 0
txtModCompName.Text = dgRecordView.Text
dgRecordView.Col = 1
txtModProjName.Text = dgRecordView.Text
dgRecordView.Col = 2
txtModStartDate.Text = dgRecordView.Text
dgRecordView.Col = 3
txtModFinishDate.Text = dgRecordView.Text
dgRecordView.Col = 4
txtModComplete.Text = dgRecordView.Text
dgRecordView.Col = 5
txtModComments.Text = dgRecordView.Text

Thanks for all the help as always =)

Problem On Retrieving Data From Access To Datagrid
Hai everyone, I am doing a project on Attendance Monitoring. I have two tables one master table called student and another table called att to store students daily attendance. I have four comboboxes in my form, by selecting the city,area,centre and batch the respective students satisfying this condition has to be displayed in the grid apart from that i have to display another column to mark attendance. I am using datagrid and mark P for present and A for absent. When i finished marking the whole data has to be stored in att table with the current date. The next day again the same class may be selected with the next date and has to be stored again. The problem is i am not able to store each person attendance. Please help me in this regard.

The att table contains fields like
Code:
Student_ID,Date,Attendance
The student table contains fields like
Code:
Student_ID,City,Area,Centre,Batch,Name etc
The code that i have written is like this

Code:
Public ac As New ADODB.Connection
Public ar As New ADODB.RecordSet

Private Sub Command1_Click()

Set ar = ac.Execute("select student.Student_ID,att.Attendance from student,att where City = '" & Combo1.Text _
& "' AND Area = '" & Combo2.Text & "' AND Centre = '" & Combo3.Text & "' AND Batch = " & Combo4.Text & "")
Dim count As Integer
count = ar.RecordCount
MsgBox count
Set DataGrid1.DataSource = ar

End Sub

Private Sub Form_Load()

ac.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:v-tablesStudent.mdb;Persist Security Info=False"
ac.CursorLocation = adUseClient

Combo1.AddItem ("CHENNAI")
Combo1.AddItem ("BANGALORE")
Combo2.AddItem ("GILL NAGAR")
Combo2.AddItem ("CHOOLAIMEDU")
Combo2.AddItem ("EGMORE")
Combo2.AddItem ("SOWCARPET")
Combo2.AddItem ("KOTTIVAKKAM")
Combo2.AddItem ("KILPAUK")
Combo2.AddItem ("MOGAPAIR")
Combo3.AddItem ("RANGA NURSERY")
Combo3.AddItem ("V-KIDS")
Combo4.AddItem ("1")
Combo4.AddItem ("2")

End Sub

Writing Data In A Datagrid Back Out To Access In VB6
Hello everyone.

I have a small database with less than 1000 records composed of 6 fields. I am able to display the entire database (with scrolling) in a datagrid in VB6. I am also able to modify any of the fields within the datagrid. My question is:

Is there a way to write the entire Datagrid back into the Access Database as a whole?

Any help with this would be greatly appreciated.

Puting Data Into A DataBase (VB6, ADO, ACCESS, DataGrid)
Old in basic/vb but new to this part of database with VB6.

Have created an ACESS Database with several tabels.

Have a VB6 project with several forms.
ACESS, ADO, Jet 4.0 and DataGrid.

If I make a textbox and connect it to the database and say
DataBase.Recordset.AddNew
then I can add text into that textbox and this goes into that database.
So far no problem.

But now I want a value I have in a string, TextString, to be put into the database. In fact I have several such strings I want to be put into various Fields in the new Data.

But I am not able to.

Have tryed to put this text into the TextBox. But this does not get transfered into the database. Strange to me as if I type "manually" it does.
Maybee some settings or ---
So how can I send a textstring direct to a field in the database?

Have a nice day
Per

Storing A Datagrid Record To Textboxes.
I want to take a selected record from a Datagrid in VB6 and on command1_click load the highlighted record field by field into textboxes?

txtFName = datagrid1.??????

FName is the first column of the datagrid.

Am I even close???

Updating MS Access Table With ADO Data Control From A Datagrid
Hi,

I'm populating a datagrid with the data of a MS access table using ADO Data Control. If I change the datagrid values, its automatically updating the table contents. Is there any property of the ADO data control, so that only on setting that value, the data grid changes should be reflected in the DB & not otherwise.

regards,
narayan

Assign Data Fields From Access 2003 To A DataGrid In VB6
this question is from my Softwear engenering and Web Devlopment Teacher
________________________________________________________________________________________________________

Hello everyone
I am attempting to assign data fields from access 2003 to a dataGrid in VB6. I do not want to use the the properties wizard to assign the data, I want to do it using code. This is what I have, but the dataGrid displays blank. Col headings do display as specified. The record set is defined as such:

With rstCatPrimary
.ActiveConnection = conMMM
.CursorLocation = adUseClient
.Source = "select id, primaryCode, desc from CatPrimary"
.LockType = adLockOptimistic
.Open
End With

Set grdData.dataSource = rstCatPrimary.dataSource
With grdData
.
.
'Col Headers *******
.Columns(0).Caption = "Primary Key"
.Columns(1).Caption = "Primary Description"

'Col data assignments ****** (NEXT 2 LINES ARE THE PROBLEM)
.Columns(0).DataField = rstCatPrimary!primaryCode 'data fld = primaryCode
.Columns(1).DataField = rstCatPrimary!Desc 'data fld = desc
End With

The grid DOES populate if I use the properties wizard, so the dataset is solid

Thanks in advance

Vince

Storing A DataGrid Record To A Textbox -SOLVED-
I want to allow the user to select a row from the datagrid and copy the individual fields of the selected record to individual textboxes for verification on the next screen.

Code:
Set conUDA = New ADODB.Connection
Set rsCust = New ADODB.Recordset
conUDA.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Persist Security Info=False;Data Source=" & App.Path & "UDA.mdb; mode = read"

conUDA.Open

strSQL = "select * from CUSTOMERS where FNAME Like '" & strFname & "' and LNAME Like '" & strLname & "' and COMPANY Like '" & strCname & "' and PHONE Like '" & strPhone & "'"

With rsCust
    .CursorLocation = adUseClient
    .Open strSQL, conUDA, adOpenDynamic, adLockOptimistic, adCmdText
End With

If rsCust.RecordCount = 0 Then
    MsgBox "No items found"
Else
    Set DataGrid1.DataSource = rsCust
    DataGrid1.Refresh

End If

After selecting the row and clicking next I want to transfer the selected fields to textboxes (as said above)...I am trying something like:

frmSession.txtFName.Text = DataGrid1.?????

Am I even close?

Edited by - melvijp on 12/7/2003 9:23:15 AM

Tutorial On Populating A DataGrid With Data From A Microsoft Access Database
can someone plz tell me how to do this or give me a link to a tutorial

i have been searching the net and this forum for ages and aint been able to find a simple tutorial that explains how to simply add data from an access database to a datagrid on my VB 6 form

Using An SQL String To Call Data From Access Database Into VisualBasic DataGrid???..n
the Situtaion:.. I am using an access database that holds dates as strings. example( 06252004 ). I am trying to use an sql string to search everything that is selected from that database table, for dates specified as a start date and end date, which are specified by the user. The results should be placed on a datagrid.

All my sql attempts have failed.

Can anyone help me peice one together, in an SQL string format, that will work in VB and be accepted by access when vb passes it to it?

LOAD DATA IN A DATAGRID OR OTHER GRID VERY FAST (10763 Records) From A CD Access DB
What's the fastest form to load data in a DataGrid or other Grid ?

The System Read a DataBase from a CD the old System take only 2 seconds, my System is te New System But take 2 minutes
to load the registers in the Data Grid and is a Big Problem !!!

'Declarations
Public cnTesis As New Connection
Public cmTesis As New Command
Public recTesis As New Recordset

The Recordset is Open of this form :

cnTesis.ConnectionString = strCadenaConexion
cnTesis.CursorLocation = adUseClient
cnTesis.Open strCadenaConexion

recTesis.Source = "SELECT materia AS Materia_,cve_tesis As Tesis_,rubro As Rubro_,cve_epoca As Epoca,texto As Texto_,precedente As Precedente_,referencia AS Referencia_ from Tesis WHERE (" & strCadenaConsulta & ")"
Set recTesis.ActiveConnection = cnTesis

'This LINE TAKE 2 MINUTES In my Work this is a LOT
recTesis.Open

Other form to load the DataGrid is with de ADODB.Recordset and ADODB.Connection but the time of load is the same
in my code the part that take a lot of time is

recTesis.Open

There are a form to load a Datagrid or other king of Grid Faster ?
The older version used VB3 I can't Believe that the older aplication load the Datagrid in only 2 seconds and in the VB ver. 3 ADO didn't exist.

PLESE HELP ME !!!

Storing Data In And Recalling The Data From A Single Database Record
hi guys...
I am still working on the same system but on another part of it.

I need to know how I can have some numbers in text boxes or other controls, so that when the app is closed, the numbers get stored in a database record, or some other data sheet, and then get called back up wheb the program is reopened

I actually have access to some code that was writting for another part of this system, but I don't understand a lot of it

Anyway... I need to know how to have these numbers stored automatically when the app is clsed, and then recalled automatically next time the app is opened.

Thank you so much

Happieman

Storing In Access - Please Help?
Hey

i have never stored data from VB into an access database? Can anyone help?

Thanks

Joel

Storing Into ACCESS
Hello There

does anyone know how to transfer the content
of Word file to Access Table. if that is not possible can anyone suggest on how to collecet some info from users and then be stored in Access database. the info is collected from different places.

thanks in advance

Storing .jpg In Access
When .jpg is stored in an access database it is first rendered (turned into a .bmp/dib) and this rendering is stored with it - removing any storage advantage gained from converting the picture to .jpg - an important consideration given access's limit of 1Gb per mdb.

To overcome this, I renamed my .jpg files to .jpx files before inserting to the ole field. OK so far. Now I use a vb program to retrieve the records, data control and ole container. The image appears as an Icon in the ole container. Right clicking gives me the option to 'Edit Package'. I thus use the Object Packager to save my retrieved .jpx file to a file "picfile.jpg". I have an image control image1 on the form into which I load the picture with the following code behind the command button "image1.picture = LoadPicture("c:abcpicfile.jpg")

I have achieved what I want ie Store a photograph in Access in .jpg format without the storage overhead of also storing the rendered image and be able to retrieve that photo and display it. (I do not want to store the .jpg in a directory and a referencein the db)

What I really want is to do all this in code - any ideas?

Storing Data
I poseted this on a diffrent post however I think I was supposed to post it here. Here is what I posted:
Hi,
I am curently writing a program that will keep track of classes that people take. So far all I made was the GUI. You can look at it by going here [NO DIRECT LINKS TO EXES PLEASE] . I don't know how to store data. If you look at the program pretty much people will be able to add a class that they took, the date they took it, the course number and how many CEU's (aka points) the class is wotrh. I want to figure out a way to take the data from the text store it on the computer in a file or in the reg. and when the program is turned back on it is placed into the lavels on the form. I am still a newbie. I do not know how to use data grids. As of now I will be placing 20 labels for each section (i.e. class name, date taken etc.) And when it pulls the info it will see how many classes are taken and fill the appropiate amount of labels. The rest of the labels will be set to be hidden. I know a little bit on how to work with a .db file. The problem is that all the code needs to be in one exe. I need step by step directions. Can anyone help.
Thanks.

AND

Ok. I now realize why people wouldnt want to download an EXE. Here is a screen shot of the program. Http://www.emstalk.com/downloads/ceutracker.jpg.
Here is the form
Http://www.emstalk.com/downloads/MainForm.frm
There is no "real" code in it since I did not know how I would store and retrieve the data.
Here is the source code

Code:
Private Sub IDontWork()
MsgBox "I Don't work yet"
End Sub

Private Sub Command1_Click()
Call IDontWork
End Sub

Private Sub Command2_Click()
Call IDontWork
End Sub

Private Sub Command3_Click()
Call IDontWork
End Sub

Private Sub Form_Load()
CMonth.AddItem "01"
CMonth.AddItem "02"
CMonth.AddItem "03"
CMonth.AddItem "04"
CMonth.AddItem "05"
CMonth.AddItem "06"
CMonth.AddItem "07"
CMonth.AddItem "08"
CMonth.AddItem "09"
CMonth.AddItem "10"
CMonth.AddItem "11"
CMonth.AddItem "12"
CDay.AddItem "00"
CDay.AddItem "01"
CDay.AddItem "02"
CDay.AddItem "03"
CDay.AddItem "04"
CDay.AddItem "05"
CDay.AddItem "06"
CDay.AddItem "07"
CDay.AddItem "08"
CDay.AddItem "09"
CDay.AddItem "10"
CDay.AddItem "11"
CDay.AddItem "12"
CDay.AddItem "13"
CDay.AddItem "14"
CDay.AddItem "15"
CDay.AddItem "16"
CDay.AddItem "17"
CDay.AddItem "18"
CDay.AddItem "19"
CDay.AddItem "20"
CDay.AddItem "21"
CDay.AddItem "22"
CDay.AddItem "23"
CDay.AddItem "24"
CDay.AddItem "25"
CDay.AddItem "26"
CDay.AddItem "27"
CDay.AddItem "28"
CDay.AddItem "29"
CDay.AddItem "30"
CDay.AddItem "31"
CYear.AddItem "00"
CYear.AddItem "01"
CYear.AddItem "02"
CYear.AddItem "03"
CYear.AddItem "04"
CYear.AddItem "05"
CYear.AddItem "06"
CYear.AddItem "07"
CYear.AddItem "08"
CYear.AddItem "09"
CYear.AddItem "10"
CYear.AddItem "11"
CYear.AddItem "12"
CYear.AddItem "13"
CYear.AddItem "14"
CYear.AddItem "15"
CYear.AddItem "16"
CYear.AddItem "17"
CYear.AddItem "18"
CYear.AddItem "19"
CYear.AddItem "20"
CYear.AddItem "21"
CYear.AddItem "22"
CYear.AddItem "23"
CYear.AddItem "24"
CYear.AddItem "125"
End Sub

Storing Data
I never understood how to do this, but I now require it.
I need to be able to save several stats into a file and call them all up upon login. It is not over the internet (although in the future it'll probably have to be saved over a network). The stats include a username, password, and a set of 6 stats (administrative and program access powers) dependent on the first stat (I called it level).
I read the microsoft help file and now I'm not sure whether I am coming or going.

Help?

Storing Data In Exe
I've got a body of data that I want to use in a dll. The body of data is created by a small computer program which is an add-in to VB. I'm wondering what the best way to store this data is. I'd rather package the data into the dll than have it in a separate file that I would have to distribute in addition to the dll. I just think that's neater and more robust. Anyway I've thought of the following options:

1. Keeping each item of data as a string in a resource file. The problem is that I don't think you can add to a resource file with a VB add-in. So that doesn't seem viable.

2. Making a text file, and adding that as a custom resource to a text file. I don't like the fact that you have to extract the whole text file each time you want to examine it - I think this could be slow. Plus, I don't think I can look at the text file without running the dll.

3. Adding a form to the dll with a combo box which lists all the records. The form would never be shown, so this seems a bit of an odd thing to do. But it certainly works, and the add-in can handle it.

I'm coming down in favour of No. 3. Anyone have any thoughts? Is there a more professional way to handle this?

Thanks for your help.

Storing Data In An Exe
Hi' Firstly an apology for not knowing the proper section to post this in as my BV knowledge is minimal.

Here's my problem.

I have a small program that once executed reads a file on my hard drive and then stores the contents in a string variable. The program works fine but it really annoys me that there are two files when I would much prefer the data to be compiled in the exe instead of having to read it from a file.

To date the best I have managed is to put the data file into an OLE as a Package but I cannot find any way to transfer the contents of the OLE Package to a string variable.

Any help with this would be most appreciated.

Thanks in advance.

Storing Data
Hi,
I am curently writing a program that will keep track of classes that people take. So far all I made was the GUI. You can look at it by going here [NO DIRECT LINKS TO EXES PLEASE] . I don't know how to store data. If you look at the program pretty much people will be able to add a class that they took, the date they took it, the course number and how many CEU's (aka points) the class is wotrh. I want to figure out a way to take the data from the text store it on the computer in a file or in the reg. and when the program is turned back on it is placed into the lavels on the form. I am still a newbie. I do not know how to use data grids. As of now I will be placing 20 labels for each section (i.e. class name, date taken etc.) And when it pulls the info it will see how many classes are taken and fill the appropiate amount of labels. The rest of the labels will be set to be hidden. I know a little bit on how to work with a .db file. The problem is that all the code needs to be in one exe. I need step by step directions. Can anyone help.
Thanks.
Dovid
Dovid@Dovid.net

Storing Data
Id like to create a program that allows me to enter names into a list, then save it so i can close the program. but when i open it again i would like to load the list up again. i wouldnt mind having to hit a button to load or save as long as it works. ive got everythign figured out except how to save the list entries. and not save to a network or a database. i want to save to the computer only. ANY ONE WHO CAN HELP, PLEASE DO....

Storing Data
Can someone please tell me why my data from a form with InkEdit text box controls are being stored as Rich Text Format in the database. I would like to convert it to plain text.

I thank you all in advance for all your help.

Gil

Storing Data In VB
I work with Access a lot and I know that we can store data in tables. However, I am transitioning into VB and I do not know how VB stores the data.

Does VB have table like MS Access? if not, how if data stored if you do not want to connect to database or server?

Storing Data
What would be the best way to store around 8-10k of data ?

Dim ?

Storing Data Within VB
Hi All

First post here

Im am new to VB but familiar with VBA, what i want to know is is it possible to store data in something like an excel spreadsheet within VB?

I then need to access this from a useform ( a very basic database!!!).

I need to keep my data embedded within the program somehow so i need to be able to save my changes as well,

For my project I cannot have an external database and have to embed my data within the program, is that even possible in VB?

Thanks for taking the time to look

Gibbo

Storing Data
Hello!

I was wondering if this is the best way to store multiple properties of multiple items:

Code:
Private Type ItemData
strLargeImageURL As String
strMediumImageURL As String
strSmallImageURL As String
strArtist As String
strTitle As String
strASIN As String
End Type

Private udtItemData() As ItemData

If I want to access the title property of the sixth item, I would query udtItemData(5).strTitle.

Is the above method the most efficient?

Regards,
Sebastian

Storing Data
I've got data coming in through RS232 serial comms and MSComm deals with this. This data will be coming in every second for about 2 hours (it's a data logging device). What I need to do in my software is store this data in a table so that the user can scroll through the results. The reason for the table is so that the user can select and copy the data into Excel or an alternative to produce graphs. Being a beginner with VB I haven't a clue how to go about this. Apparently it's something to do with arrays??? I need to store the data, then increment to the next cell in the table and repeat till tests are complete. Any ideas anyone?

About Storing Data...
Hello,
i wish to konw how u use to store data in a field of db:
i'm refering in particular to CheckBox, i use to build a control array, in order to store in the table field the index of the one is checked, if none is checked then i save -1 or null.
Up to here i hope it is the standard way, if there's a better way tell me

Now my question is:
it happens that the checkboxes are not exclusive... so i can store in the same fieldsnull value, or -1an integer (the index i've checked)N integer (the indexes i've checked)What i've thought is to store the integers between bracket.
first i try to use a separetor like ; but when i go into the field lookin for 1 ... i find 1, 11,12,21... and so on....
using bracket if i look for (1) i'll find only 1!

What do u think about it? there are better way for doing the same?

Storing Data
I have an Access 2000 database that is populated from a Web Front end application. The database usually stores about 100 records and doesnt have alot of concurrent users. I have a field called Status that stores about 10 to 20 sentences of Status information that is entered once a week. Each time someone updates a Status field it copies the old status to History1 field and History1 is copied to History2 field and History2 field is copied to History3 field.

Everything works well but now I need to know how I would store the old data that is eliminated in the History3 field. I could put it in one big field called Archive but I think Access limit on a memo field is 65,000 characters?

Please provide suggestions how I should store this information because status is updated once a week and I will sometimes need to store up to 52 weeks of data. I assume it is not a good idea to create 52 fields to store each week of data in one table so I am hoping for someone to suggest the best way of doing this.

My current table fields:
project_id
status
history1
history2
history3

Storing Data
Hi, I'm using a Listview in my app and I need to store extra data for each Listview item, but it's too much data to put in the Listview as well. I think I need to use a class, but I'm not sure how to do it properly.

The extra data I need to store looks like this (maximum of 999 items):

Code:
f9fs987sf983hjb4hjb534jhb43b.local
sd7f6sd7dfg7f5g76dfg576g57g6.local
e54efwefw86yh3h43u5ih34uih4.local
9w76e76w7986ewe78w6ew7e76w.local
31jkn44890fjn546hj6g.local
sfsf765ewrk453io54389u7568945.local

Each Listview item has a 'key': ListView.ListItems.Add , "Key1", Item Text

Somehow I need to store the data and link it to the Listview Item key. I also need to 'tag' the extra data with "free" or "busy" or "done".

StoreData "Key1", "f9fs987sf983hjb4hjb534jhb43b.local", "free"
StoreData "Key1", "sd7f6sd7dfg7f5g76dfg576g57g6.local", "free"
StoreData "Key1", "e54efwefw86yh3h43u5ih34uih4.local", "free"
etc

Later I need to be able to loop through it and based on the 'tag' do something with the data.

I've done some very basic storing in classes like the code below, but I'm not sure how to do this.

vb Code:
Private StoreData(1 To 999) As String Public Sub AddItem(sData As String, lIndex As Long) StoreData(lIndex) = sDataEnd Sub Public Function GetItem(lIndex As Long) As String GetItem = StoreData(lIndex)End Function

Storing Data?
Well, for the second time today, I've had to resort to coming here for help.
I'm creating an archive program with the options to add new information.

So far there are three factors: The User - The Type - And The Username/Password.
The Users are stored in a combo-box. The Type is stored in a list box, and the Username and password are stored in two seperate text boxes.

What I need is a way to add information that will fill these forms.. and have it actually save.

I used the naive approach. I thought maybe if I coded it to AddItem to the listbox/combobox that it would save. But even as a VB noobie I should have known better.

Should I go with a database? Or text files? Keep in mind that I'm pretty new, and will certainly need some code and detailed explanation.

Thanks guys!

Storing Data
This might be a stupid question, but I must ask. Is there a way to store small amounts of data for later use w/o the use of an external file (ex. txt, bin, mdb)?

Also if I had to use an external file (mdb), what is the best practice for storing on the users PC. I would like to have it as transparent as possible.

Thanks in Advance, this forum rocks!

Storing Data, In Mdb?
Hi all,

I am new to programming w/ Visual Basic and have a few probably noob questions. I am creating a program that will store restaurant names in a file. Then later randomly pick one. What would be my best be for storing this data? I would prefer storing the data in a mdb then access it with queries and DAO, because I am familiar with this. The only thing that worries me is, what if my users don’t have access installed, will this affect them? I also heard of using the ‘Scripting Runtime’ File system objects.

Thanks in Advance

Storing Data
hi, if i have a form and i want to save setting ie. a user click on the check box to make the background blue, how can this be saved so next time they are back it's blue again and not the default black for example

Best Way For Storing Data
Whats the best way for storing data to the disk?

I don't really want to use the "put" method as most of my fields (about 10,000) are about 2 chars long, then I need one of about 20...so theres a wide range.
I'd rather store some raw text and code it etc myself.

I was using the richtextbox control, is this the best method? Its a rather sizeable ocx...

Storing Data
Hi
Im developing a application that will acquire data from a equipment at each 2 seconds belong 10 minutes. I need to plot a grafic (line shape), print a report from values and save a file in disk with these values.

I was thinking in use a database like access, but store a lot of data in a short period like this is not cool.

Someone can help me with a sugestion? What is the best solution to this case?

thanks
Daniel

Storing Data Somewhere
I need to Storing Data Somewhere, on a program i am creating.
The data i need to store is a username and the persons Ip address, that is placed in two text boxs. One text boxs is called Dname and the other one is called ClientIP.
These two pieces of data need to be keep together or linked in some way. So the data can be recalled.

I was thinking something on the line of

- A database
- A Text doc
- Maybe a Multline Text box.

I need some input

Thanks.

Storing Data
I am writing a program in VB, it is sort of a log book for truck drivers. There is different information that needs to be stored. When the driver is about to embark on his journey, he fills in info for the START of his journey, then while on the road, everytime he stops for a PITSTOP, he has to write down his info, location etc., then when the journey ends he has to write his END information. I have gotten the START and END, storing of info finished. When i need help on is the PITSTOP, how do i keep track of the pitstops, there can be only 1 pitstop and there can me many pitstops, how do i keep track of them all, in the order entered. For start and end i put a check in a checkbox in my DB, how would i do that for the PITSTOP.

Any ideas are greatly appreciated.