Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Displaying the fields in a table
- Thread starter M8KWR
- Start date
Is this a table/relationship question?
On a form, you could create a listbox, set it's rowsource to the table you wish to display the fields for, then select "Field List" as rowsource type.
Else I think you'd need to programatically retrieve the field names, for something like this quick and dirty approach:
[tt]dim strFields as string
dim lngCount as long
dim rs as dao.recordset
set rs=currentdb.openrecordset("mytable")
for lngCount = 0 to rs.fields.count-1
strFields=rs.fields(lngCount).name & ", "
next lngCount
msgbox mid$(strFields,1,len(strFields)-2)[/tt]
Roy-Vidar
On a form, you could create a listbox, set it's rowsource to the table you wish to display the fields for, then select "Field List" as rowsource type.
Else I think you'd need to programatically retrieve the field names, for something like this quick and dirty approach:
[tt]dim strFields as string
dim lngCount as long
dim rs as dao.recordset
set rs=currentdb.openrecordset("mytable")
for lngCount = 0 to rs.fields.count-1
strFields=rs.fields(lngCount).name & ", "
next lngCount
msgbox mid$(strFields,1,len(strFields)-2)[/tt]
Roy-Vidar
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question