Organizing data so its easy to get.
My problem is retrieving data from a database.
I really don't know all the available otions to me.
So i created a Access database to just function as a storage device.
I know the are better ways to organize data so it is easily accessed..
Does anyone Know where I should start..
Here is samlpe code of me accessing access..
VB Code:
Public Sub GetElectricsCosts()
Dim rstElect As Recordset ' record set variable
Dim i As Integer
Set DbsVacublast = OpenDatabase(PATH) 'setting database object var
Set rstElect = DbsVacublast.OpenRecordset("ElectPanel")
rstElect.Index = "PrimaryKey"
rstElect.Seek "=", m_floorConfiguration
For i = 0 To 2
m_ElectCost(i) = rstElect(i + 1)
Next i
rstElect.Close
DbsVacublast.Close
End Sub