Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006
    Posts
    111

    Unanswered: Iterate an Query Result

    Hello!

    How can I access the result of a query and iterate through its values in the code handler to a form's button for example? Thanks.

    your noobiness,
    g11DB

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I will tell you.... if you tell me why you want to iterate the results
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2006
    Posts
    111
    Hey you again :-)

    I will use it to iterate to:
    * the function that generates the parameters to an SQL pass-through query
    * call different instances of a report

    Thanks PF,
    g11DB

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    That's a good answer - often iterating is uneccesary but not here

    Have a look here:
    http://www.timesheetsmts.com/adotutorial.htm
    This is a nice run through almost exactly what you want to do. Come back if you have any problems (or to let us know you sorted it)
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jul 2006
    Posts
    111
    Hi PF,

    thank you for being generous with your time and helping me out.
    i had a look at the code at the bottom of the link and it seems it is exactly what i am looking for. i will try it out tomorrow, it is quite late already. :-)

    cheers,
    g11DB

Posting Permissions

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