Macro in Visual Basic

To_Experts

I have a problem regarding macro which i described
below.Here i retrieve fieldname from array.
e.g.-> "SR_NO" is fieldname

coding:

Dim TempStoreNumber As Integer
Dim NumberOfArray As Integer
dim rsiled as recordset

For TempStoreNumber = 0 To NumberOfArray
 With rsiled
  X1 = "!" + TempArrayfieldname(TempStoreNumber)
  MSFlexGrid1.TextMatrix(1,TempStoreNumber) = " " & X1 & " "
 End With
Next
      
Points:

 1) I got x1 = "!SR_NO"  
 2) I got msflexgrid1.textmatrix(1,TempStoreNumber)="!SR_NO"            

Both are same.Actually in first point i got correct value(field name).
But in second point i want value of that value(means fieldname's value).

I want the value of "SR_NO" (Fieldname of a table) from table.
which i want to pass in msflexgrid which i mentioned below.

   msflexgrid1.textmatrix(1, TempStoreNumber) =


Please reply us with full coding.

with warm regards,
Bhavesh Patel
AurokripaAsked:
Who is Participating?
 
batdanCommented:
Instead of:

For TempStoreNumber = 0 To NumberOfArray
     With rsiled
      X1 = "!" + TempArrayfieldname(TempStoreNumber)
      MSFlexGrid1.TextMatrix(1,TempStoreNumber) = " " & X1 & " " 
     End With
Next

Hope this is OK.   Regards.

use:

For TempStoreNumber = 0 To NumberOfArray
 
           X1 = TempArrayfieldname(TempStoreNumber)
           MSFlexGrid1.TextMatrix(1,TempStoreNumber) =rsiled(X1).Value

Next
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.