<div>
it will only need to display what filed &lt;names&gt; are there within each table...
</div>


it will only need to display what filed <names> are there within each table...

<div>
Awesome Guys!!<br />
<br />
Thank you for your help :)
</div>


Awesome Guys!!

Thank you for your help :)

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
I am looking for a VBA that will loop through all tables in a access database ad output a result report like this:<br />
<br />
Table1 <br />
FieldX<br />
Field Y<br />
Field Z<br />
<br />
Table2<br />
Field F<br />
Field G<br />
<br />
<br />
tHank you<br />
Rayne
</div>
</div>


Hello All,

I am looking for a VBA that will loop through all tables in a access database ad output a result report like this:

Table1 
FieldX
Field Y
Field Z

Table2
Field F
Field G


tHank you
Rayne

Access VBA

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.