Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to modify a query

    How to modify a query

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Fredensborg, Denmark
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to modify a query

    Arage,
    If you want to use a value in a control on your form as a criteria in a stored query you very often don

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to modify a query

    yes I understand that Claus, but what I meant is that my text control could hold more than one entry to display. If I create a parameter like you mentioned above, it will only accept one value, not more than one like I am trying to achieve.

  4. #4
    Star Lounger
    Join Date
    Dec 2001
    Location
    Fredensborg, Denmark
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to modify a query

    Arage,
    Is this a continuation of your post on numerous entries in a textbox? I.e. is what you are asking really how to deal with that in a WHERE clause?

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to modify a query

    in a manner of speaking yes, Claus it is a continuation with the exception that the previous report was all about opening a report not a query. And the applyFilter method of the doCmd object will allow you to specify the WHERE conditon, whereas the openQuery method will not.

  6. #6
    Star Lounger
    Join Date
    Dec 2001
    Location
    Fredensborg, Denmark
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to modify a query

    If you have to do it in VBA I suggest you consider using DoCmd.RunSQL.
    Then you are free to compose your SQL stmt as you wish incl. the construction of the WHERE clause you need for your job.

Posting Permissions

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