Search results

I do understand what the end result is, I just dont understand all of the bits in it and what each line means. Thanks for the info!

Now I need to start learing what all this means and then next time I won't need so much assistance.

You Sir are the best! :D Thank you so much.

Your code works if I select more than one file, but still gets stuck if I only select a single file.

Yes still the same error and when I click debug, it highlights: "For Each varCtr In varInputFiles" I am still somewhat new to VBA

Still hanging on: "For Each varCtr In varInputFiles"

I just realized this only allows the import of more than one file. If I select a single file I receive the following error.... Run-time Error '13': Type mismatch For lngLoop = LBound(varInputFiles) To UBound(varInputFiles)

I was able to get it worked out. After reviewing it this morning, I realized I forgot a “)” :o Working code. Private Sub Import_Data_Click() Dim lngLoop As Long Dim strFilter As String Dim strTable1 As String Dim varInputFiles As Variant lngFlags = ahtOFN_FILEMUSTEXIST Or...

So I was able to find this code from here.. http://www.utteraccess.com/forum/Doug-Steele-s-djsTest-t1918803.html I am getting a compile error here: "If Len(Dir(varInputFiles(lngLoop)) > 0 Then" Private Sub Import_Click() Dim lngLoop As Long Dim strFilter As String Dim strTable1 As...

I am unable to visit that site while at work. Please excuse my ignorance but which part of the script only asks for 1 import?

Well, with the current code I am only able to select one file. I haven't been able to find the code I need to import more than one.

Hi all, I have been trying to get this code working for a few days and have not been able to solve it. :banghead: Currently I have a code that imports a single text file into a table without problems. I need to be able to selecte multiple text files and import them at once. Here is my...

You're my hero! :D That worked perfectly *I was able to get it working in the actual enviroment, its slow but it works.

That still didnt work. Lets make this simple. I've created a new database just to work this out. Table1 Tracking Number 123456789 741852963 789456123 963852741 987654321 888887457 Table2 Tracking Number 1111123456789 2811741258963 9411789456123 2311963258741 7111987654321 Here is the...

I'm not sure how any of that would help. :banghead: These are FedEx tracking numbers. We have no control over the length of the tracking numbers. I've built a system to reconcile web orders vs FedEx EDI data. Our 750 vendors input the FedEx tracking number into a backend ordering tracking...

The two fields I am attempting to compare are tracking numbers. One company may only report the last 17 out of 22 digits, and others may report all 22. I thought about trying to trim off the excess digits, however, there is no set amount that it may be over.

Hey everyone, I have an issue I have been working on for a day now and I cant seem to crack it. I am trying to use wildcards to compare two strings of numbers. One of the strings may have a few leading numbers. Example: Table 1: 92123456789 Table 2: 123456789 Sample code I'm using...

Excellent! Ill see if I can somehow adapt that to work the way I need it to. Would I take that code and create a module? (sorry I am still pretty new to VBA)

That was a bit over my head... lol Still researching....

Hey guys, I have been trying to find a solution to this for about an hour and haven't been able to come up with much. :banghead: Task: Compare two fields that should have the same number in each. Return results that are off by a digit or two. Example: Tracking # - Tracking # 2 123459789 -...