Listing the Fields in a table

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Listing the Fields in a table

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

June 27th, 2003, 01:14 PM

John Anthony John Anthony is offline

John Anthony is offline

Authorized User

Join Date: Jun 2003

Posts: 24

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Listing the Fields in a table

Does anyone know how to loop through a table and get a list of all the field names in that table?

John

__________________
John

Old

July 4th, 2003, 08:42 AM

U.N.C.L.E. U.N.C.L.E. is offline

U.N.C.L.E. is offline

Friend of Wrox

Join Date: Jul 2003

Posts: 112

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Try:

for each F in rs.Fields
debug.print F.Name, "=", F.Value
next

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Listing 8-10 and Listing 8-16.	Asp.Net	BOOK: Professional ASP.NET 2.0 and Special Edition; ISBN: 978-0-7645-7610-2; ISBN: 978-0-470-04178-9	1	February 6th, 2008 01:11 PM
Overwriting fields in a table	caterpillar	SQL Server 2000	3	July 24th, 2006 09:00 AM
Fields in a dynamic table?	Roshu	Javascript How-To	12	January 10th, 2005 09:04 AM
Update Table fields	karajian	Access VBA	2	December 7th, 2004 03:48 PM
Updating table fields	ppenn	Access VBA	2	September 20th, 2003 06:09 PM