Macro's are horid. There is nothing a Macro can do that VB can't do infinitely better and easier!
I started out as a Macro programmer, but as soon as I got my head round a teeny bit of VB I threw them away and never looked back. It looks scary at first, but is actualy way easier once you realise what it does as you don't have to jump through as many hoops as you do with Macros.
I'd be very intressed to see how you are back-ending it to SQL server without using VB though. Most likely it's using linked tables, which could well be slaughtering your server performance. Could be on pass through queries though, which isn't as bad, but not as usable either.
More than happy to advise on Access and/or SQL server, I've been doing it so long it's almost a hobby now. to be fair though my SQL is pretty rusty as until about a month ago it'd been two years since I last worked on one. I also do occational freelance Access dev if you want some more involved work doing.
no subject
I started out as a Macro programmer, but as soon as I got my head round a teeny bit of VB I threw them away and never looked back. It looks scary at first, but is actualy way easier once you realise what it does as you don't have to jump through as many hoops as you do with Macros.
I'd be very intressed to see how you are back-ending it to SQL server without using VB though. Most likely it's using linked tables, which could well be slaughtering your server performance. Could be on pass through queries though, which isn't as bad, but not as usable either.
More than happy to advise on Access and/or SQL server, I've been doing it so long it's almost a hobby now. to be fair though my SQL is pretty rusty as until about a month ago it'd been two years since I last worked on one. I also do occational freelance Access dev if you want some more involved work doing.