Search results

9 tons of soil? Serious excercise! If I were close I'd offer to help. Thanks for the clue - will try it later - after the McVitie's (from our version of Tesco - Fresh and Easy!)

Thanks Beetle - tried that, and alas nothing changes. Debug tells me the file code fails because it can't locate the file, yet it has "found" it with the dir ... I'm befuddled .... want to try it at home later ...

Appreciate the help CJ! I looked at that earlier and had a similar thought, but when I run the code and track the varaibles in the locals window, all appears to be OK ... attached the snip of that FYI .... The code fails on the DoCmd line ..... I needa cup of tea and a chocolate biscuit...

Are there specific Data link properties I should be setting? :confused:

I'm beginnng to think that I'll have to define an import spec for the DoCmd. as the file is a Tab separated variable ... unfortunately, my Import Wizard on this machine has become corrupted, and I'll have to get the Propeller Boys to re-install Office from Texas or wherever they do it from ...

Thanks Sean,( and CJ!) however, I'd already seen thatand fixed it, but the original problem still exists. The files I am trying to read have the format filename.COR.txt - I added the .txt as a means of getting Access to import them ... :o The code to that point is finding all the variables...

SOmrthing is awry with the code below - it cannot find the file to import from even though it appears in the locals window as a variable etc ...... :confused: Appreciate your insight and assistance folks! Sub txtfileimport() Dim strPathFile As String, strFile As String, strPath As String Dim...

Thanks gents - will work on it in the am here, when you'll be home having afternoon tea and choccy biccies ... As usual, the brains around here cracked it .... :D

Hello Hello Hello ... So there I was Looping nicely through a table of variables until I go to the point where I wanted to call another subroutine and "use" the variables from that recordset in the table. The subroutine seems to want me to set the variables again - is that becasue the code has...

The Proof of Concept performed nicely - thanks to all for assistance/support/ideas .... Now to implement the complete solution .... :banghead:

That issue has reared its head here also - but they do insist on writing all manner of unecessary data, and using single tables. :o

Nigel - You've nailed it, Sir! That's exactly what I was trying to do. My thinking with the table was that there are a whole lot of permutations of files, locations and mnemonics to manage and by my simplistic way of operating, the table was a "neat" solution - however, I am not a...

Thanks BBE - it's the latter, values I want to apply to variables already defined. I want the code to execute based on the values of each record in a table. Typically the values are mnemonics that we use to create file names, file locations etc. They will reside in a table (myfilelocations)...

I am trying to modify some code that we use to move data files around our system, and we currently use Access for this purpose. It may not be the optimal way of doing it, but there's a great attachment to the software here, and I can't see it going away! ;) However, in order to make the code a...

Hi all! I'm in SoCal and excited to expand my knowledge of Access VBA with the assistance of all you generous types around here. Its a propos that this forum has its roots in the UK, as, many moons ago, I started off there, but through some quirk of employment and marriage ended up in Laguna...