Results 1 to 5 of 5
  1. #1
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231

    Print the table field description with the field name & size

    Is there a way to print the table field description with the field name & size?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Google: access vba table properties

    Review: http://www.java2s.com/Code/VBA-Excel...properties.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    I get the code, but where does it go and how do I run it?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Can put it in a button Click event. If you don't want a form, put the code in a general module and run it from the VBA editor menu. Click Run icon.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    Thanks for the help.

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

Similar Threads

  1. Access table linked to excel - field size problem
    By tzmyo in forum Import/Export Data
    Replies: 1
    Last Post: 10-02-2013, 01:03 AM
  2. Replies: 1
    Last Post: 04-26-2013, 09:53 AM
  3. Replies: 2
    Last Post: 03-20-2013, 04:25 PM
  4. Accessing the DESCRIPTION field of an Access field
    By FelicianoRa@coned.com in forum Programming
    Replies: 1
    Last Post: 01-14-2013, 03:28 PM
  5. Setting Field Size in a New Table
    By vinfurnier in forum Access
    Replies: 2
    Last Post: 11-15-2011, 10:37 AM

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