Search results

I am having some problems. Right now I have a code that combines files using FSO but for some reason it has been adding an empty line to the end of files and if the file has an empty line it combines that empty line. The programs that run off these files cannot read this empty line correctly...

Hi, I have a table I am using that someone else created but I made a form which passes a Hyperlink to a text box. The pass is fine but once it gets there it just generates random characters instead of the name of the hyperlink from the table. Any ideas on how to fix this? I have tried making...

I have a logic issue. I need to have a code that I run through a list of files, and rename them to the specified folder. Only problem is, if the folder exists I prompt a box asking if the would like to change the folder date. This happens with EVERY file if it belongs in the same folder...

If there anyway in access loop through a table of client numbers, and if the client number appears in either the subject line or the body of a message, move that file to a specific folder on your hard drive? I have never seen any code like this to work through access so any help would be...

I am having some problems. I have a table with certain file name criteria to match in file name but it isnt working correctly. I am using InSTR but I feel like I should be using a different command. Any help would be greatly appreciated. If InStr(1, rs![FName], rs1![BuClient]) And InStr(1...

I am trying to figure out how to pull data from query results in VBA but i have been unsuccessful so far. I have a form where I enter a client number and date and it pulls a report and saves it automatically. The only problem is the save path includes [Client#] & " " & [ClientName]. The only...

I am trying to create this module or form that imports a specific text file in multiple folders into a table in access 2002. I want to use a date range say from 2/1/10 to 3/3/10 but I cant figure out how to make it skip the missing weekend folders. Below is what I have so far which is only using...

Is their anyway to bypass the transferspreadsheet command if the file path does not exist?

Ok, I have this file that came through that is, I think you would call it free fixed width format. It has fixed width fields but if a field is missing it shifts it over to the left. But all the fields have characters at the front to identify them for example AC120. If anybody has any ideas on...

I have some queries importing files from the previous day where instead of the date being in the file name it is in the folder before it. For example C:\Programs\090903\FileName.txt. I have tried to pull it like this..."C:\Programs\"Format(Date()-1,"yymmdd")"\FileName.txt... still to no avail...

Hey all, I found this workdays module on a site and I am very new to all this VBA stuff but I just need to edit a few things on it to get it to work correctly and any pointers would be greatly appreciated. It is counting the dates between two different days. I need it to produce a specific...