Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Stop Macro With Repeat Expression
1 view
Skip to first unread message
Casey
Oct 17, 2003, 3:08:36 PM10/17/03
to
I have a macro that runs another macro. The macro that
is run opens up a form, and goes through the records,
record by record until it gets to the last record. I
then receive an end of recordset message, because the
macro gotorecord "next" action cannot happen. The
RunMacro action that I use to run the other macro has
a "Repeat Expression" box to place a factor, but what do
I put in it? I placed an
isnull([Forms].[form1].[RECID])
is run opens up a form, and goes through the records,
record by record until it gets to the last record. I
then receive an end of recordset message, because the
macro gotorecord "next" action cannot happen. The
RunMacro action that I use to run the other macro has
a "Repeat Expression" box to place a factor, but what do
I put in it? I placed an
isnull([Forms].[form1].[RECID])
expression in the "Repeat Expression" box thinking that
it would evaluate to null when the end of the recordset
was reached, and the macro would stop without any "end of
recordset" message, but it did not work. Does anyone
have a recommendation.
I appreciate any help.
Thank you,
Casey
Ken Snell
Oct 17, 2003, 5:22:20 PM10/17/03
to
Try this:
[Forms].[form1].Form.Recordset.EOF = True
--
Ken Snell
<MS ACCESS MVP>
"Casey" <anon...@discussions.microsoft.com> wrote in message
news:028f01c394e2$11050fd0$a301...@phx.gbl...
Casey
Oct 17, 2003, 7:40:05 PM10/17/03
to
Thank you Ken. I really appreciate the information. Have
a nice weekend.
a nice weekend.
Casey
>.
>
0 new messages