Loop in an access macro

Question

Can I do looping within an access macro?

arnel_gp · Answer

you can use an Update Query with Criteria of your selected records.

arnel_gp · Answer

can you do the same functionality using Query?

michael99chronister · Answer

arnel_gp&nbsp; &nbsp;I probably could for most things I have tried.&nbsp; I am still getting up to speed on Access programming with macros.&nbsp; My question is, if I want to change some fields in a lot of records, doesn't a query just return records found, or it can&nbsp;append records or delete records.&nbsp;&nbsp;But how do I get it&nbsp; to update a few fields in all the records selected?

george_hepworth · Answer

michael99chronister&nbsp;First, we have to be clear about Macros. Unlike Excel which uses the term "macro" interchangeably with "VBA", Access has two distinct programming languages, Access macros, and VBA Functions and Subs.&nbsp;Subs and Functions are much more useful and it's probably a good idea to move on to them as quickly as possible in the Access development environment. This is a good example of that.&nbsp;Looping a recordset is a standard thing to do in VBA. I can't think of a way to do it in a Macro, although there might be some obscure method I'm not aware of.&nbsp;So, the full answer is probably to just move on to VBA in Access and not spin your wheels with macros.

michael99chronister · Answer

I thought that might be the case. It has been a long time since I did intense programming (like when there was no VBA but Basic only). Getting up to speed is a problem. ANy suggestions on good documents on how to get up to speed on VBA and especially formats for coding. An example would be I remember the expression component "LIKE" but don't remember parameters, sequence etc.Thank you.

Forum Discussion

Loop in an access macro

7 Replies