Count the Number of Columns in Table?

jrram
jrram used Ask the Experts™
on
Is there a way using Access VBA to count the number of columns in a table?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
CurrentDb.TableDefs("MyTable").Fields.Count

Steve

Author

Commented:
Thank Ya.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial