I’m helping my daughter with a database which she has inherited. It’s not particularly well written and uses copious macros. These are in groups, something I’ve never come across before – but then I’ve nearly always used VBA rather than macros. Because some of these groups have many macros (so it’s a pain to find a particular macro), I thought about using the convert macro to VBA function. It works fine, converting the first macro to VBA, but ignores the rest. Is there an easy way to convert a group to VBA? Or failing that is there an easy way to navigate to particular macros.
As an indication of how good this database is, the main table has 143 fields, many of which could be in separate tables. It’s proving a nightmare to see how the data in many of the fields are generated.
Office 365, so Office 2016. It’s an accdb dataset, converted from an mdb
Eliminate spare time: start programming PowerShell
