To be fair to the muppet who put it together, they might not even know it's been done. A wizzard used to create a Macro could have silently set this up under the surface.
You seriously need to re-engineer this thing. I expect you don't have the budget for a contractor to look at it (*waves*), but if you want to hook up sometime I'd be happy to spend an hour or so walking you through how to do this so it works properly. You could maybe pop down to my office one evening and I'll show you what I've done here. Or I can just e-mail you a load of code that you can drop in to do it for you. I use standard functions to work with SQL server in Access, which should be fairly portable.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
no subject
You seriously need to re-engineer this thing. I expect you don't have the budget for a contractor to look at it (*waves*), but if you want to hook up sometime I'd be happy to spend an hour or so walking you through how to do this so it works properly. You could maybe pop down to my office one evening and I'll show you what I've done here. Or I can just e-mail you a load of code that you can drop in to do it for you. I use standard functions to work with SQL server in Access, which should be fairly portable.