@Gkirkup
Other than doing a Find in the vba project for the term you're searching for (which might identify code where someone used VBA to execute an INSERT, UPDATE or recordset-based change:
If you have any particular desire to learn VBA or to further practice what you already know, this exact scenario is one where I've found it very rewarding to write some code that searches for things, you may or may not be interested but if you do it you learn some very useful things. Some ideas are:
- loop through the Querydefs collection, examine their .Sql property to find specific text
- loop through the
AllForms collection, each form's controls, and examine their .Controlsource property
I wish I could post the code I last used, but it was at my 2nd to last job and I did not save or take it with me. Also, once you build something like that, it's very handy to reuse for migration or project scoping purposes when you come across a db you're less familiar with. It's a lot easier than you might think and really hones your knowledge by doing it yourself.
