For documenting reasons I need to copy the table structure info
(fieldnames, -types, indexes) to for instance Word and Excel. When I open
the table in design mode and select one or all rows Access won't let me copy
it. Any hints or code that accomplish this?
Thanks,
john

Try this utility to create a report with the info you need. If you still
need it in Word, use the data in the table to Output to Word:

http://www.datastrat.com/Download/Fi...cription2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"john" <(E-Mail Removed)> wrote in message news:flns54$3ua$(E-Mail Removed)...
> For documenting reasons I need to copy the table structure info
> (fieldnames, -types, indexes) to for instance Word and Excel. When I open
> the table in design mode and select one or all rows Access won't let me
> copy it. Any hints or code that accomplish this?
> Thanks,
> john
>

Select Tools | Analyze | Documenter. Open Options to define requirements for
Tables, Fields and Indexes. Select the Tables desired. Click OK. Select Tools
| OfficeLinks | Publish it with MS Word.
--
********* http://panjas.org
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?


"john" wrote:

> For documenting reasons I need to copy the table structure info
> (fieldnames, -types, indexes) to for instance Word and Excel. When I open
> the table in design mode and select one or all rows Access won't let me copy
> it. Any hints or code that accomplish this?
> Thanks,
> john
>
>
>

Thanks! Exactly what I need since I can easily past the info from the table
to Excel and Word.
john

"Arvin Meyer [MVP]" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Try this utility to create a report with the info you need. If you still
> need it in Word, use the data in the table to Output to Word:
>
> http://www.datastrat.com/Download/Fi...cription2K.zip
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "john" <(E-Mail Removed)> wrote in message
> news:flns54$3ua$(E-Mail Removed)...
>> For documenting reasons I need to copy the table structure info
>> (fieldnames, -types, indexes) to for instance Word and Excel. When I open
>> the table in design mode and select one or all rows Access won't let me
>> copy it. Any hints or code that accomplish this?
>> Thanks,
>> john
>>
>
>

Thanks for the tip!

john

"S Panja" <(E-Mail Removed)> schreef in bericht
news:5C0273C1-F1AA-4444-A2AD-(E-Mail Removed)...
> Select Tools | Analyze | Documenter. Open Options to define requirements
> for
> Tables, Fields and Indexes. Select the Tables desired. Click OK. Select
> Tools
> | OfficeLinks | Publish it with MS Word.
> --
> ********* http://panjas.org
> If the message was helpful to you, click Yes next to Was this post helpful
> to you?
> If the post answers your question, click Yes next to Did this post answer
> the question?
>
>
> "john" wrote:
>
>> For documenting reasons I need to copy the table structure info
>> (fieldnames, -types, indexes) to for instance Word and Excel. When I open
>> the table in design mode and select one or all rows Access won't let me
>> copy
>> it. Any hints or code that accomplish this?
>> Thanks,
>> john
>>
>>
>>