hamofgobelgope

2 ms·

1. 1.▲
   by hamofgobelgope 13y ago

   I know people bag on VBA, but I'm a big advocate of effectively utilizing Excels tools along side using VBA to customize where necessary. This solves the problem in your first comment (users can define their own statistical limits and
2. 2.▲
   by hamofgobelgope 13y ago

   I honestly would never recommend Access as a user frontend. It's amazing how quickly Access userforms become convoluted and confusing. The only "FE" development I've done with Access is simple database maintenance tools usually only used by
3. 3.▲
   by hamofgobelgope 13y ago

   I've been able to make some pretty cool things with Access as the backend, and Excel as the frontend. Add a little VBA/SQL and you're looking like a rockstar. Access and Excel provide a versatile infrastructure to quickly prototype differen