UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Produce A Report Of Table/field Properties, Access 2016    
 
   
huber57
post Jan 9 2017, 02:30 PM
Post#1



Posts: 90
Joined: 15-February 08
From: Columbus, Ohio


I am building a database (as a beta version) before handing everything over to IT to build a more professional/robust version. I would like to create a a report (to put into a requirements document) of all of the field attributes for the tables in my database.

I have looked high and low and cannot find anything that would allow me to do this. Is there a silver bullet I am missing to help with this?

Thanks in advance for any/all help.
Go to the top of the page
 
DanielPineault
post Jan 9 2017, 02:38 PM
Post#2


UtterAccess VIP
Posts: 5,154
Joined: 30-June 11



What about the Database Documenter (Database Tools -> Database Documenter (Analyze group))?

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
huber57
post Jan 9 2017, 02:58 PM
Post#3



Posts: 90
Joined: 15-February 08
From: Columbus, Ohio


Daniel,

That is pretty embarrassing. Not sure how I did not know that exists! It is great. I have zipped past that feature countless times on my way to the Relationships button.

Thanks much!
Go to the top of the page
 
DanielPineault
post Jan 9 2017, 03:15 PM
Post#4


UtterAccess VIP
Posts: 5,154
Joined: 30-June 11



Nothing to be embarrassed about. Access is very vast and it is impossible to know it all! I've been doing this for a long time and in certain aspects I remain ignorant compared to others, and vice-versa. Just glad it suited your need. It's always a good day to find a simple solution!

thumbup.gif

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th September 2017 - 08:23 AM