I have developed a macro that loops through my database and updates all the records.
The problem is that only 50 records are displayed at a time, and then there is a page link
How do I make the macro go to page 2 [or 3 or whatever next page] after the macro has looped through all the records on that page?record1
Page 1 2 3 4 5
Also, right now I just have the loop set to 60 (to make sure I get all the records). This however throws an error when it tries to go to work on a non-existent record (51, 52, 53...). Is there a way to count how many elemnts are on the page and loop accordingly?