Question about Microsoft Office Standard for PC
Hi, I made the following recordset: Set rst = db.OpenRecordset(str_Query, dbOpenDynaset) This recordset will get me 30 fields. I want to retrieve them and put the result in an array. For example: Dim Col_Title(1 To 30) As String Col_Title(1) = rst![F1] Col_Title(2) = rst![F2] ........................ Col_Title(30) = rst![F30] Now, my qustion is, instead of writing 30 lines to retrive the 30 values from the recordset, how can I write a FOR loop and get the values in least lines of code. For example: For iCount = 1 To 30 iCount = 1 Col_Title(1) = rst![F + iCount] Please suggest me how to code: Col_Title(1) = rst![F + iCount]
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 15, 2011 | Computers & Internet
Oct 08, 2010 | Microsoft Visual Basic Enterprise Edition...
Jan 08, 2010 | Microsoft Visual Basic Enterprise Edition...
May 16, 2009 | Microsoft Windows Vista Ultimate Edition
Jan 13, 2009 | Computers & Internet
Dec 10, 2008 | Computers & Internet
Jul 20, 2008 | Microsoft Windows XP Professional
Jul 01, 2008 | Microsoft Office Access 2003 (077-02871)...
Jan 03, 2008 | Computers & Internet
Oct 09, 2007 | Microsoft Office Standard for PC
194 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: