Secondary Email Address Table with Search Button

So here's the story: I've got a database I built over 20 years ago (yes, it's hard to believe I've been doing this for 20 years) and it's very complex and working great. However, I need to be able to track multiple email addresses and phone numbers in it. I get emails or Paypal payments from unknown email addresses that belong to my customers, but I don't recognize them.

It would be a major redesign to change the whole database, so I'm going to add a secondary email address table and then update my search buttons to look in there if the primary email isn't found.

Gold Members

I don't normally include database downloads for my Fast Tips videos, but Gold Members can download this finished database. Another reason to join today!

•  Database Download - Gold

Recommended Course

• Access Search Seminar: https://599cd.com/SearchSeminar

Links

• Multiple Phone Numbers: https://599cd.com/MultiPhone
• Single-Field Search Button: https://599cd.com/SearchButton
• Intro to VBA: https://599cd.com/IntroVBA
• If Then: https://599cd.com/IfThen
• DLookup: https://599cd.com/DLookup
• NZ Function: https://599cd.com/nz
• Double Double Quotes: https://599cd.com/DoubleDouble
• AutoNumbers Good or Bad?: https://599cd.com/GoodOrBad
• What is Null?: https://599cd.com/IsNull

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, multiple email addresses, search button, search for email, email not found, How to Add Multiple Email addresses for customers, searching multiple emails