Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2008
    Posts
    9

    Unanswered: printing datasheet

    I want to print the datasheets (Field Name, Data Type, Descriptions) in the Design View and even tried to copy and print to word pad, with no success.
    I can get the detailed sheets Tools->Analyze->D0cumenter, but they do not include the Descriptions from the datasheets.

    My purpose is to compare all the entries amongst the tables for fidelity.

    Maybe there is another way to do it?

    JP

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why would the descriptions be important?

    And why do you want to do this? ... I don't know what you mean by comparing for fidelity.

    Suffice to say, I don't know of an easy way to do it. You could print-screen and then paste in Word, but that's only screen-shotting.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2008
    Posts
    9
    The 'Descriptions' are important for understanding the content of the field. When there are multiple users, as in the case of a multi-project Action Item Data Base we are setting up, everyone must know what the intent of the field is, specifically when acronyms are used.

    Printing data sheets for stakeholder reviews and agreement on field content was the goal.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    aaaaaaaaaaaah sounds like an EAV, and an EAV in Access







    incoming........................!
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Extensive Access Violation? ^^

    Sometimes I want to print the design sheet of a table too, but it just can't be done afaik.

    I'd also like to be able to copy that sheet to excel or something to continue documentation.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Tools -> Analyze -> Documenter. Select the tables that you want to document, then click "Options...". This allows you to customise how much information is extracted. To pick up the field descriptions, you need to select the third option in the "Include for fields" group - "Names, Data Types, Sizes and Properties". Click "OK" to accept changes and again to fire off the anayluzer (it can take a while). At the end of the process, you have a report that will show (along with all the other properties for fields) the description line.

    To get the descriptions, you have to get everything else as well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •