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?
 
mark2150Commented:
It's not going to work. The field name is being interpritted as a string and *NOT* as a field reference.

Set db = Workspaces(0).OpenDatabase(datadir)
For Each Table In db.TableDefs
    work = Table.Name
    If UCase(Left(work, 4)) <> "MSYS" Then Combo1.AddItem Table.Name
Next Table
'
Data1.Caption = datadir
Data1.DatabaseName = datadir           'set link to database
Combo1.ListIndex = 0
Set Data1.Recordset = db.OpenRecordset(Combo1.Text) ' Defaults to Table object.

For Each td In db.TableDefs
For Each fd In td.Fields
        Printer.Print fd.Name
Next fd
next td

0
 
batdanCommented:
You may want to delete this question.  It has been posted twice!
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.