Help on GoToRecord reaching the last record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that people ask a lot of times about this, but I realy don't know how
to do it. I'm not that good with access. I'm trying to create an automated
update condition but I need that the macro stop when it reach the last
record. Can someone help me on this...
 
Hi Victor,
Put the update in a Do Loop that runs till EOF
EG:-
Recordset.MoveFirst
Do Until Recordset.EOF
'code to update your data
Recordset.MoveNext
Loop

:-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat a macro using an expression 9
pasting problem 0
Windows 10 "This site can't be reached" Error 5
GoToRecord Command 1
Help with GoToRecord,Next command in Macro 5
Action Failed 2
SetTempVar issue 0
How to automatically stop a macro 1

Back
Top