Data Dictionary Help

[rocketD]

Hi All,

I've been looking through the forums on how to get the field names and
descriptions out of Access and, I work for a corporation that won't
let me download anything, including the recommended add-in. So I'm
looking at this code from Allen Browne:

http://allenbrowne.com/func-06.html

The problem is, I don't know how to implement VBA code of this
nature. I'm limited to very, very simple lines of code. Can someone
tell me what I need to do with this code to customize it to my
database, and how to make the field descriptions show up?

Thanks,
Dara

 

[Golfinray]

I would start by going to tools/macro/visual basic editor and then getting in
to help.

 

[Gina Whipp]

Go to the Modules tab, open a new module and then copy/paste to the module,
save (do not use the name of the function as the name of the module). Then
follow press Ctrl+G and in the window that opens type:
?TableInfo(YourTableName)

and press enter.

 

[rocketD]

Go to the Modules tab, open a new module and then copy/paste to the module,
save (do not use the name of the function as the name of the module).  Then
follow press Ctrl+G and in the window that opens type:
?TableInfo(YourTableName)

and press enter.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors






- Show quoted text -

Worked Perfectly! I tried something similar originally but I think
that I have been putting a space after the ?, which wasn't working.
Thank you.

 

[Gina Whipp]

Glad to help!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Go to the Modules tab, open a new module and then copy/paste to the
module,
save (do not use the name of the function as the name of the module). Then
follow press Ctrl+G and in the window that opens type:
?TableInfo(YourTableName)

and press enter.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors






- Show quoted text -

Worked Perfectly! I tried something similar originally but I think
that I have been putting a space after the ?, which wasn't working.
Thank you.