Results 1 to 2 of 2
  1. #1
    sir_robert007 is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Sep 2013
    Posts
    1

    How can I get an SQL printout of a table in Access 2010


    What I want to do is have the SQL printout list all the fields in a table that I have already created. Also how would I enable SQL view? Im new to Access.


    Using Windows Vista and Access 2010.

  2. #2
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    I'll give the second answer first. In MS Access 2010, SQL view is reached by looking at the query in design view, then on the query tools/design tab of the ribbon, the far left group (results) controls the view format - drop down and select SQL.

    The first answer is a little more complicated. There's a documenter feature, which I find cumbersome, and there's some VBA code that will pull the information from a system table.

    Hmmm. Here's a discussion. I haven't reviewed their code, and it's not what I use, so no guarantees. http://www.access-programmers.co.uk/...ad.php?t=99194

    Here's a simple one that looks like it would work. http://www.tek-tips.com/faqs.cfm?fid=4310

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

Similar Threads

  1. import table to append to a table in Access 2010
    By Stephanie53 in forum Forms
    Replies: 2
    Last Post: 05-23-2013, 03:40 PM
  2. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  3. Replies: 1
    Last Post: 01-12-2012, 02:54 AM
  4. PrintOut Macro Action
    By EHittner in forum Access
    Replies: 1
    Last Post: 09-22-2011, 01:27 AM
  5. PrintOut action
    By svcghost in forum Programming
    Replies: 11
    Last Post: 10-05-2010, 05:13 PM

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