Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    3

    Unanswered: DoCmd.RunSQL Question

    Hello,
    Is it possible to use DoCmd.RunSQL that references the name of an existing query instead of the SQL syntax itself? If so, could you provide an example?

    Any help would be greatly appreciated!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    For an existing , saved query you'd use

    DoCmd.OpenQuery "YourQueryName", acNormal, acEdit
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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