Results 1 to 2 of 2
  1. #1
    Julie417 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    4

    Access 2010 Database Documenter

    New Access user here (hi everyone!)...... I've been looking at the Access2010 Database Documenter reports. There is so much info that I think could be useful in helping me design my database, but I am very confused as to where this information is coming from. For example, here are some of the things that come up in a report:

    Tables
    AggregateType: -1
    AllowZeroLength: False
    AppendOnly: False
    Attributes: Variable Length
    CollatingOrder: General
    ColumnHidden: False
    ColumnOrder: Default
    ColumnWidth: Default
    DataUpdatable: False
    DisplayControl: Text Box
    GUID: {guid {7DBD11BF-86AF-43EE-AF91-86BF2BE59492}}
    IMEMode: 0
    IMESentenceMode: 0
    OrdinalPosition: 3
    Required: False
    SourceField: First Name
    SourceTable: Employees
    TextAlign: General
    UnicodeCompression: True
    WSSFieldID: FirstName

    Indexes
    Clustered: False


    DistinctCount: 1
    Foreign: False
    IgnoreNulls: False
    Name: Company
    Primary: False
    Required: False
    Unique: False
    Fields:
    CompanyAscending



    I think I would put my table in design view, and open the property sheet, but the names on the report aren't always what I'm seeing in the design view. There are a few things in there I recognize, but most of it ...... WHAT IS THIS TALKING ABOUT???? WHERE IS THIS STUFF???? I'm quite confused over this and for as much information there is on Access, I can find very, very little on this tool. I've found a few articles mentioning what the Database Documenter, but absolutely nothing regarding these fields on the report.

    HELP!!!!!

    Julie

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    what you have listed are properties. you have them labeled incorrectly. this list is a list of properties for a field object:


    Tables
    AggregateType: -1
    AllowZeroLength: False
    AppendOnly: False
    Attributes: Variable Length
    CollatingOrder: General
    ColumnHidden: False
    ColumnOrder: Default
    ColumnWidth: Default
    DataUpdatable: False
    DisplayControl: Text Box
    GUID: {guid {7DBD11BF-86AF-43EE-AF91-86BF2BE59492}}
    IMEMode: 0
    IMESentenceMode: 0
    OrdinalPosition: 3
    Required: False
    SourceField: First Name
    SourceTable: Employees
    TextAlign: General
    UnicodeCompression: True
    WSSFieldID: FirstName


    some of what the report produces, you will not see through the GUI. And the reason you don't is because you don't need that knowledge to produce a working application with this program.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 02-22-2013, 04:57 PM
  2. Replies: 4
    Last Post: 06-15-2011, 03:55 AM
  3. Saving Access 2010 database to Access 2007
    By Bajaz001 in forum Access
    Replies: 2
    Last Post: 04-11-2011, 12:59 PM
  4. Distributing Access 2010 database.
    By Robeen in forum Access
    Replies: 4
    Last Post: 04-07-2011, 02:02 AM
  5. Hide database window in Access 2010
    By Kevin Johnston in forum Access
    Replies: 5
    Last Post: 09-23-2010, 09:44 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums