Results 1 to 5 of 5
  1. 01-06-2012, 08:37 AM #1
    pmortlock
    pmortlock is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    2

    Noob Finding Query


    I have DoCmd.OpenQuery "qryPrevDayNumDateMT" in the code behind a button, how do I see the query definition?
    Reply With Quote Reply With Quote
  2. 01-06-2012, 08:45 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Open the query and change the view to "SQL View"
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 01-06-2012, 08:47 AM #3
    pmortlock
    pmortlock is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    2
    Access 2010 I am using how do I do Open the query?
    Reply With Quote Reply With Quote
  4. 01-06-2012, 08:58 AM #4
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    I have never used A2010 but take a look at the link below for details:
    http://office.microsoft.com/en-us/ac...157.aspx#BMsel
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  5. 01-06-2012, 09:04 AM #5
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    You can open the query in design mode from code with this line:
    DoCmd.OpenQuery ("qryPrevDayNumDateMT"), acViewDesign
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Noob query
    By custhasno in forum Access
    Replies: 6
    Last Post: 10-12-2011, 11:29 AM
  2. Noob problem: query and multiple tables
    By PaulCW in forum Queries
    Replies: 6
    Last Post: 09-23-2011, 12:46 PM
  3. (Noob) Need help with a query please
    By kmccallsdsu in forum Queries
    Replies: 6
    Last Post: 03-22-2011, 12:49 AM
  4. Finding Median in Query
    By randolphoralph in forum Queries
    Replies: 1
    Last Post: 02-19-2010, 11:18 AM
  5. Noob Query Help Needed
    By fenster89411 in forum Queries
    Replies: 0
    Last Post: 01-11-2009, 09:47 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums