Jul 19 2022 08:23 AM
@arnel_gp I probably could for most things I have tried. I am still getting up to speed on Access programming with macros. 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 append records or delete records. But how do I get it to update a few fields in all the records selected?
Jul 19 2022 10:56 AM
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.
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.
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.
So, the full answer is probably to just move on to VBA in Access and not spin your wheels with macros.
Jul 19 2022 01:00 PM
Jul 19 2022 02:46 PM
Jul 19 2022 08:59 PM
Jul 20 2022 06:21 AM