I'm in the middle of my most ambitious vba projects to date, and want to make sure I'm following any best practices that I can gather up. My main question is where to place some of my code. For instance, I have one form that will require a lot of code (for me anyways) to calculate some analytics for the form. At this point, I think it's unlikely I'll need this code anywhere else in the application, but who knows......So, should I place this code in a Module, or just keep it in the form itself?
Also, I'm looking for a good book on Access VBA, if anyone has one they can recommend. I'd prefer it deal with Access 2010, but am open to all suggestions.
Thanks,
Gary
Also, I'm looking for a good book on Access VBA, if anyone has one they can recommend. I'd prefer it deal with Access 2010, but am open to all suggestions.
Thanks,
Gary