Edited 6 Years Ago
by PM312: call back
Enumerate field names in a recordset
Function getfieldnames(mytable As String)
Dim fld As Field
Dim dbf As Database
Dim rs As Recordset
Dim sql As String
Set dbf = CurrentDb()
Set rs = dbf.OpenRecordset(mytable, dbOpenDynaset, dbSeeChanges)
sql = ""
For Each fld In rs.Fields
sql = sql & fld.Name & ","
getfieldnames = Left(sql, Len(sql) - 1)
i tried below code and its working as i wanted
recordset.Fields(1).Name retrives the field name
I am working creating a fully encapsulated, homogeneous singly linked data structure. The Listing class and SinglyLinkedList class that are part of the whole application compile fine, but the problem ...
I have this block of code where l run through a table and display matched results in a listbox.
It works fine, but my question is how do l enable ...
I have developed a DBMS and I want to store the credentials for server, and user name securely so that the users don't have to enter the password ...