Recent content by DQuick

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...