Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    28

    Question Unanswered: Editing of SQL in query

    Hi,

    Can the SQL of query be edited using coding?
    Please help!

    Thanks & Regards,
    oks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Use the QueryDef Object. It has a property called SQL

  3. #3
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    28

    Exclamation

    Is there any examples that I can get from anywhere!
    I'm lost, have no idea how to code it!

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    PHP Code:
     Dim qdf As QueryDef

      Set qdf 
    CurrentDb.QueryDefs("yourQureyName")
      
    msgbox(qdf.Sql
    This will list the sql statement of your query....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •