Hi, Shawn,

Thanks for getting back to me!!!!

I'm using MSGrid, the one that comes with VB6 I'm using DAO and
Access '97 and the table is already defined, with 2 of 18 fields
(WMTR & TestLog - #'s identifying the specimens being measured) with
data already supplied.

There are 6 cbo's and 12 textboxes on the first form besides the
labels identifying the customer. The 6 cbo's each contains a list of
10 measurement instruments (laser, caliper, profilometer, etc). Six
of the 12 textboxes contain the serial numbers of those measuring
devices.

The number of columns, after the first one, in the grid is
determined by the number of textboxes (a control array) (the other 6)
used (typed in) on the first form. The column headings, typed into
the textboxes could be "Width", "Height", "Length", etc.

The data in the first column is from an array, which is
populated by a field (TestLog) in Access. The user will enter the
measurements in a cell of a columns decided by the textboxes.

I'm almost done. I just need to get the data from the cells and
the textboxes and cbo into the specific records.

Ex of the database: WMTR | TestLog | ColumnName1 | Measurement1 |
Instrument1 | SerialNumber1 -to- ColumnName6 | Measurement6 |
Instrument6 | SerialNumber6.

I have everything working, except when the program exits
(suppose to) and I go and check the appropriate database and there is
nothing there except the WMTR and TestLog. I get no error message.

The grid is working fine. I can enter the measurements into
each cell and the appropriate column headings, from the textboxes,
are there.

I haven't attempted getting the measurement into the database.
I have no idea how to get the measurement data from the cell to the
appropriate fields in the database. The other fields get there data
from the textboxes and cbo. They don't even show up.

Any suggestions would be greatly appreciated.

Thanks in advance,

Bob





--- In vbra@y..., "Shawn K. Hall" <vb@r...> wrote:
> Hi Bob,
>
> > ... how to save the data grid to a table I
> > created in MSAccess.
>
> What kind of grid?
> ADO or DAO?
> What version of Access?
> Do you have a defined table layout in Access already?
> How is the current data getting into the grid?
> What have you done already?
>
> When asking questions please provide as much detail as possible in
> order to help those who may answer provide accurate and complete
> answers. :)
>
> Regards,
>
> Shawn K. Hall
> http://ReliableAnswers.com