can a form display current table field names?

[Guest]

Hello,

I need to create a form that will display the current field names resulting
from a make-table querythat can change from audit to audit. This way the user
is always aware of the "current" field names in their dataset.

Currently, a form displays the structure from a linked (text formt) table
that I have to manually export every time the make-table query changes and
I'd like this to be generated from a macro or from code.

Any Ideas?

I thank you,
John_Lehmus
Maine, USA

 

[Allen Browne]

This article illustrates how you can list the field names, types, and
descriptions for a table:
http://allenbrowne.com/func-06.html

 

[Guest]

Hi,

Thanks Allen Browne, your code works great. Now, is there a way to easily
display this information to the user?

Cordially,
John_Lehmus
Maine, USA

~

 

[Allen Browne]

Sure: You could you could just concatenate them into a string, and show them
in a MsgBox().

Alternatively, write them to a table. Use OpenRecordset, AddNew, and Update.
From there you can show them in a list box.

Of course, if you just just wanted to show them to a user, you could set
these properties for your list box:
Row Source Type Field List
Row Source {name of your table here}

 

[Guest]

Hi Allen,

I'll try the list box example as that make be the quickest way, for me anyway.

Thank Again,
John

~~~