Search results for query: *

Wow...I actually have it working!!! There is one small issue that I'm seeing.. There are a few addresses that have 4 lines of addresses because of a business name. Currently, it is leaving that businessname on a separate row. Is there anyway to fix that? Thanks!

Excel

it will eventually be an access database.

I am scanning in addresses and trying to create a db with these addresses. Once i scan them and clean them up a little they are in the following format... John Doe 123 Main Street Cleveland, OH 12345 Jane Doe 234 Main Street Akron, OH 23456 Jen Doe 345 Main Cleveland, OH 23453 I have a list...

I need help setting up and ODBC link to run queries on a server. I'm not really sure all what ODBC is but I run several queries in access and it bogs down my computer. Well, I now have a server so I heard I can run the actual queries on the server. Any help is appreciated.

I tried the first approach and I can't get my punctuation correct. I need this in query form so a report won't work. I don't know how to do a total query. Any other suggestions. I don't know sql so i have to use the GUI version of access. Thanks!

I can't figure out how to do this. I have a query that produces the following results: A 1 234 A 2 34621 A 3 2356 A 4 4571 B 1 23556 B 2 2345 B 3 3466 B 4 2356 C...

Now i'm getting another runtime error saying that ActiveX component can't create the object. =(

Thanks for the help. I got the module in there and changed my field names and the table name to match yours. I'm getting a runtime error (invalid argument) and it highlighted this portion. Set rst = CurrentDb.OpenRecordset("SELECT [" & fName & "], [" & fPhone _ & "] FROM [" &...

Thanks ByteMyzer. Reading through this makes sense. However, I've never used code in access. Any tips?

I need to flag records that have the same name and phone number. For example, Suzy Smith 123-456-789 & Suzy Smith 123-456-789 would need to be flagged PM1. The next match, john doe 456-789-123 & john doe 456-789-123 would need to be PM2 and so on. Anybody know how to do this?

No, I don't need the data. If I could just remove that part before I import it that would be great, just not really sure how to do that. thanks!

I have a text file that has 2 fields with binary data. When I try to import the file, the records with nothing in those fields get all messed up..Any suggestions?

I have one table with a list of different values. I have another table that has a field that has values from the first table somewhere in the field.. Table 1 Street Drive Road Circle Cove Table 2 1234 A. Street 3556 B. Cove What I want to do is if a word in table 2 matches a word from table...

That's what I did..and I get the validation rule error.

I'm trying to Ltrim leading spaces in a text field. I have checked the table design and there are no validation rules, no keys, or anything else that could cause a problem and data type is set to text. However, when I try to do the update, I get the big long error saying that 0 records were...

The numbers do come after a text string..however, there is no particular pattern to go by.. ASV.134 ABc ASV35 93BCD I'm trying to parse these out and i know i'm going to have to use several steps..

Sure.. CARRERO ADA24-77

Unfortunately, the string always begins with a letter..Any other ideas?

How do you search for the first occurance of a number? I have very inconsistent data. However, it always begins with alphanumerics. I tried using something like InStr([# 1 Alphanumeric Address]![ADDRESS1], Like "*[0-9]*") but I can't seem to get my syntax correct. Any suggestions?