MSAccess Database with Basic Access Fields
The first time I touch both Access and Basic, but I am doing a favor for my sister. I need to get data from a table and some headers have a% character in them, but changing headers doesn't and an option. what will msaccess replace% with?
Allow right = rc! [Permissions% pozitia 1]
rc - recordset: P
+2
a source to share
1 answer
I don't have db access for testing at the moment,
but you can try displaying the field names: (code from here )
Public Sub GetTableObjects()
Dim db As Database
Dim tbl As TableDef
Dim Fld As Field
Set db = CurrentDb
For Each tbl In db.TableDefs
Debug.Print "Table: " & tbl.Name & " ***"
For Each Fld In tbl.Fields
Debug.Print Fld.Name
Next Fld
Next tbl
End Sub
+1
a source to share