very beginner question...

[memilanuk]

I'm trying to modify the Contacts.accdb template to suit my purposes - for the most part it does what I want/need. I'm having to hunt down a few places where apparently field names are referenced in some embedded macros, VBA modules, etc. and are giving me minor amounts of grief in the form of error messages.

So... when I open up the VBA IDE, I see a listing of classes, modules, etc. I'm used to an 'old fashioned' text editor like say, Notepad++ (or vim ) that I would use for say, HTML or CSS code. I have no idea how to find what I'm looking for when it appears I have to go through the combo boxes at the top of the editor pane to select any individual snippet of code, one at a time. Am I going at this the wrong way?

Thanks,

Monte

 

[Galaxiom]

All the procedures for a module are displayed together in the VBA editor.
The VBA Editor has a text search function. It is on the toolbar and looks like binoculars.

It can be set to Current Procedure, Current Module or Current Project. The last one will automatically open any modules and highlight the next place where it finds the string each time you press Find.

 

[boblarson]

If you downloaded the Contacts.accdb template from the Microsoft site, there is NO VBA CODE in it whatsoever. It is all macros (including the new embedded macros). If you want, you can convert your macros to VBA.

 

[memilanuk]

Hmmm... that would explain why I wasn't having much luck even searching as suggested. There is what looks like classes (with stubs for several of the forms) and modules (for mapping addresses online), though.

Thanks for the link... I'll try to read through some of that here in the near future.

Monte

 

[boblarson]

Hmmm... that would explain why I wasn't having much luck even searching as suggested. There is what looks like classes (with stubs for several of the forms) and modules (for mapping addresses online), though.

Thanks for the link... I'll try to read through some of that here in the near future.

Monte

I would be interested in seeing a screenshot of what you're seeing because the templates do not contain any code whatsoever (currently, it is a requirement from Microsoft that be the case) and they created it.

 

[memilanuk]

See the attached screen shot...

Thanks,

Monte