Search within a Macro

Topic

New Reply

Howdy!

So I have an Access Database that has hundreds of EMailDatabaseObject macros. However when we need to change an email address, we have to go through every line and search for the customer (this takes a LONG time and gets frustrating)

Is there a way to search within the macros or at least organize the macros in alphabetical order?

Thanks!

Reply | Quote

Replies

It will take some investment up front but I’d suggest that you change the macros to pull the email address from a table vs hard coding them in the macro. That way when a new person takes over a job you just change the email address associated with that position to the new person’s email.

One thing I learned very early was that “it will never change” is among other lies like “the check’s in the mail”! Avoid hard coding anything that has any chance of changing or even anything that you think will never change but shows up many times in the code. That way when it does change it’s an easy fix, change one place and done!

HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thank you for your help!! We will most likely be switching to a new system in a couple of months, but was just wondering if there was a “quick fix” to save some headache until we switch. It doesn’t happen often when we need it changed, but its a pain when we do have to.

Thanks again! It’s good knowledge for any of my future adventures on Access

Reply | Quote

I use Rick Fisher’s “Find & Replace”, found at http://www.RickWorld.com. This is an absolutely indispensable tool for Access developers.

Reply | Quote