Help on GoToRecord reaching the last record

V

Victor Torres

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...
 
G

Geoffs

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

:)
 

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

Adding data to MS Access from csv file 0
Need Help with Macro Security 1
Start a mail merge upon opening the document 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Documents from shared model are created with design mode on 1

Top