How do I trap number of rows appended?

[mlcottingham]

I know the system has the number, since it displays it in the text box after the OpenQuery statement runs, but I cannot figure out how to grab it:

This 2 query loop runs fine manually or if I define it to run for a fixed number of iterations. However, I'd really like to just run until no more rows are appended.

Do
    DoCmd.OpenQuery "TP30d -- Append first refs"
    DoCmd.OpenQuery "TP30e -- Update combinations"
Loop Until APPENDED_ROWS = 0

Thoughts?

Thanks in advance, ML Cottingham, Princeton NJ

[Stewart Ross]

Hi, and welcome to Bytes.

Which query are you referring to when you mention the value displayed in the text box after the OpenQuery statement runs? There are two in your loop, and it would help us to know whether it is one of these you are referring to or what.

If you could expand on what you are doing with the two queries we could probably come up with a solution that would better fit your needs - please advise.

The number of records in a query is an internal property which is not directly accessible. It can be obtained indirectly by using the Dcount function as follows:

reccount = DCount("*", "[name of your query]")

-Stewart