Results 1 to 4 of 4
  1. #1
    jassie is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    40

    setup and run query in access 2013

    I have a question about running a query in access 2013. There basically is a vb.net 2010 desktop application that I am working on. This application actually passes queries to the access 2013 database and obtains the results using a dataset. I am trying to determine what the results of the query is in access 2013.


    Thus would you tell me how to copy and paste a query into access 2013 and get it to run. I do not want to use the query desinger for this reason. I just want to copy and paste the query into access 2013. Thus can you tell me how to accomplish this goal?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    Open Access query builder and switch to SQL View.
    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
    jassie is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    40
    How should I find Access query builder? What do I click on?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    This is basic Access functionality. Unless 2013 is really different, click Create on the ribbon then Query Design. Once the builder is open switch to SQL View.
    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.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-13-2015, 02:14 PM
  2. Export From Access 2013 To Excel 2013
    By Esmatullaharifi in forum Programming
    Replies: 8
    Last Post: 04-17-2015, 09:40 PM
  3. Replies: 3
    Last Post: 08-27-2014, 07:05 AM
  4. Outlook 2013 + Access 2013 + HTML
    By Yann63 in forum Programming
    Replies: 2
    Last Post: 11-26-2013, 02:39 PM
  5. MS Access Form/Query Setup
    By Datatech in forum Database Design
    Replies: 5
    Last Post: 05-31-2012, 12:08 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