G
Guest
in order to export in a format acceptable by QuickBooks I need to plug values
in txtBoxs of Form into specific fields in a fixed 5 record QBExport table
made exclusively for this purpose:
1 Header1a Header1b Header1c Header1d
2 Header2a Header2b Header2c Header2d
3 Header3a txtBox1 (blank) txtBox2
4 Header4a (blank) (blank) Field3
5 Header5a
Hopefully these columns will line up when y'all view it......All the
"header" values are fixed data already manually put into the table to meet
the requirements of QuickBooks. The txtBox values are the values needed to
be inserted into this table. (I threw the blank fields in there too just for
completeness as there are blank fields in the table which is ok...)
Haven't alot of experience with Recordset insert...am reading but not quite
got the handle on this syntax...is Access2002 ....would welcome a sample of
what vb code to put onClick event of button in this form that will insert the
txtBox values into table...much thanks
in txtBoxs of Form into specific fields in a fixed 5 record QBExport table
made exclusively for this purpose:
1 Header1a Header1b Header1c Header1d
2 Header2a Header2b Header2c Header2d
3 Header3a txtBox1 (blank) txtBox2
4 Header4a (blank) (blank) Field3
5 Header5a
Hopefully these columns will line up when y'all view it......All the
"header" values are fixed data already manually put into the table to meet
the requirements of QuickBooks. The txtBox values are the values needed to
be inserted into this table. (I threw the blank fields in there too just for
completeness as there are blank fields in the table which is ok...)
Haven't alot of experience with Recordset insert...am reading but not quite
got the handle on this syntax...is Access2002 ....would welcome a sample of
what vb code to put onClick event of button in this form that will insert the
txtBox values into table...much thanks