Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FieldNames via Recordset

Status
Not open for further replies.
matrixknow

matrixknow

IS-IT--Management
May 3, 2007
78
Hola,

My workbook gets his result from the recordset (from the query)
I need my columntitles. The names of my queryheadings are changeable (it is a crosstab which show the months and these are not fixed in this case). Can I retrieve the column heads along my recordset ? Below is not working.

Code: 
xlWorkSheet.Cells(iRow, iCol) = rst.Fields(iFld).NAME
 
Sort by date Sort by votes
sorry, I think this is the correct way to get the names of the fields. I did some test. I fix the bug.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bobbyer
  • Locked
  • Question
Ms Access VBA Automatic Relinking Frontend to 2 Backend via form
Replies
13
Views
543
bobbyer
bobbyer
xweyer
  • Locked
  • Question
Problem Using Variable as Field Name with DAO Recordset 1
Replies
5
Views
338
Andrzejek
Andrzejek
dasalight
  • Locked
  • Question
DAO Recordset Entries in Table Do Not Stay Saved
Replies
1
Views
113
dhookom
dhookom
03Explorer
  • Locked
  • Question
DAO Recordset giving Read-only Error '3027'
Replies
5
Views
279
03Explorer
03Explorer
cneill
  • Locked
  • Question
Multiple Emails via MS Access to BCC Recipients 1
Replies
5
Views
212
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top