Search results

So elated with a solution that I didn't even see it there right in front of me! thanks again... S.

One last question, Paul. Do I have to mark this thread as solved - if so, how?

Only wish I could transfer some beers your way, mate! thanks again.

Paul, You're a superstar! It was the (1) that I needed! I changed the SelectedItems to ..Item as I amended the code from AllowMultiSelect true to false, so thought items might be a letter too many as was trying different ways to use that method. thanks so much for your help, you've made my...

Got that one checked too ;) The error is received on the Debug.Print line. If I remove that line, the same message received on the import line DoCmd.TransferText...

hi Paul, I've just tried the code and received Run time error '438': object doesn't support this property or method. I've got Microsoft office 12.0 Access database engine Object library checked. Any ideas as to why i'm getting this mismatch?

Thanks, Paul. I'll give that a try now. What I'm trying to do is somewhat stated above. I'm trying to import text files into a DB on a regular basis but the names and folder locations change, so I thought it would be easier for the user to select the file to import. As you can see, there are...

Hi, I'm only new to programming in access, but why is it that you don't just write the code in excel on the workbook and then call the macro to be run from access? Apologies if this is over simplified :) Dim XL As Object Set XL = CreateObject("Excel.Application") XL.Workbooks.Open...

Hi all, I'm new to the forum and relatively new to access programming. I've got a real headache with opening file dialog to import a text file. What I'm trying to achieve is to write code to import several text files where the suffix of the filename changes daily due to run dates/times...