leo.clifton
08-09-2012, 01:03 PM
I've currently got a large personnel database stored in an excel spreadsheet. I use an extensive VB GUI to edit the data for individual records, create letters and emails to the individuals stored in the database and manage the recruitment process.
I'm in the process of transferring the data into access tables and need to know some basics of how to interact with the data stored in the table. As a starting point I need to know how pull a row of data into a virtual user defined type called cVol. For instance, when coding in excel I would write.
Cells(2,3).select
cVol.Forename = ActiveCell.value
I would then manipulate various elements of the cVol and then export it back into the spreadsheet. At present I have no knowledge of how best to manipulate elements of access tables or even read from them for the GUI so would appreciate some input here. I definitely want to stick with the GUI as it has some bespoke functions.
I'm in the process of transferring the data into access tables and need to know some basics of how to interact with the data stored in the table. As a starting point I need to know how pull a row of data into a virtual user defined type called cVol. For instance, when coding in excel I would write.
Cells(2,3).select
cVol.Forename = ActiveCell.value
I would then manipulate various elements of the cVol and then export it back into the spreadsheet. At present I have no knowledge of how best to manipulate elements of access tables or even read from them for the GUI so would appreciate some input here. I definitely want to stick with the GUI as it has some bespoke functions.