Re: [MSAccessProfessionals] Create a Data Dictionary for your Access database

thank you, Bill! It's my pleasure to share what I write with other
developers, and to be comfortable posting a link  in this forum

kind regards,
crystal

On 8/26/2021 2:24 PM, Bill Mosca wrote:
> Thanks, Crystal! This is such a useful tool, especially when inheriting a database that needs a lot of work to make usable. It's nice to have every detail in an easy-to-read spreadsheet.
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> MS Access MVP 2006-2016
> My Nothing-to-do-with-Access blog
> https://wrmosca.wordpress.com
>
> -----Original Message-----
> From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
> Sent: Wednesday, August 25, 2021 8:16 PM
> To: MSAccessProfessionals@groups.io
> Subject: [MSAccessProfessionals] Create a Data Dictionary for your Access database
>
> hi everyone,
>
> Create a Data Dictionary for your Access database, and write the results to Excel
>
> video:
> Document Access Tables to Excel (10:16)
> https://youtu.be/r6LRurruI44
>
> code:
> VBA > Document > Tables to Excel
> http://msaccessgurus.com/VBA/Code/Document_Tables2Excel.htm
>
> Creates an Excel workbook with the documentation. The first sheet, ListOfTables, gives you the Table name, number of records, number of fields, and also an estimated record width for the standard data types.
>
> The DataDictionary sheet lists Table name, Field number, Field name, Data Type, Size (byte), Description, Format, Caption, Default Value, Expression, Input Mask, Validation Rule, Validation Text, Required, Unicode Compression, and Estimated Width.
>
> kind regards,
> crystal
>
> Remote Training and Programming
> connect to me - let me help your project be a great success
>
>
>
>
>
>
>
>
>
>
>
>


-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116038): https://groups.io/g/MSAccessProfessionals/message/116038
Mute This Topic: https://groups.io/mt/85153347/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/3568969/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-