Recent content by Escondido

When I click Run a popup appears saying Compile Error: Syntax error The following 2 lines are red *Dim colMap As New Collection *Select Case fileName After clicking the ok button on the popup Excel automatically adds an arrow and highlights the following line in all yellow. Function...

I have 2 worksheets and I am trying to combine both of them into one worksheet and fill in the extra fields. I found some code online (listed below) and for some reason I am seeing a syntax error when trying to run the macro. Excel automatically goes to the line showing "Function...

Your response really helped me structure my data. I appreciate the thorough response.

Much appreciated.

I was able to solve the problem. Appreciate the help, though.

One would think that considering the entity, but I'd love to know where you were able to get the most updated list for free. AIS pdf shows they charge depending on the database ribbs.usps.gov/addressing/documents/tech_guides/orderforms/AIS002.PDF

I appreciate your help, but I want to make sure I understand this correctly. mContacts is my old database and since it's the only table in it I can still use that. Will it matter if the current database has about 30 different queries in based off the master database or is it better to simply...

I scoured the Internet trying to find free databases, but most of them had some type of limitation or weren't updated in a few years. I'd love to find a reputable source, but for the time being I'm ok with paying bit of money. I found 2 sources for less than $30, so that's not too bad.

I've got a database of about 6 million contacts with the standard fields First Name Last Name Address Address2 City State Zip Code Phone1 Phone2 DOB Income Etc. However, hardly none of them have the County listed and I'm looking to purchase an Access Database containing every county in the...

That worked like a charm. Thanks.

I have a query setup as usual, including all the fields I want to see. My goal is to only see people with a specific birth month, birth birth year and state (see attached). The query for birth month and birth year works perfectly and shows everybody in the database, but anytime I add the 2 digit...

Issue 1- I have Address and Address2 setup in my database as fields. Address2 is specifically used for apartment numbers and the like. In one of my my spreadsheets there are about 33K cells listed in the Address2 column and Access was able to import all of them except for about 5179 cells. I've...