Recent content by JDeezy

Yeah, thats my problem too. I know some File System Object stuff but not enought to dim a line specific line and delete is based on its values. All I know is that DOS prompt combined the files correctly and I need to somehow code that in VBA. Without a Batch. Unless somehow I can send values to...

Thanks paul but thats not exactly what i meant. You can use copy *.txt [FileName] to combined files through the dos prompt as well. but thats not my problem. i have about 1,000 text files a day that I have to use around 100-300 combines for. I was looking for a more automated way with maybe a...

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

Haha, already beat you to that one. That is why there is a txt5 there because i forgot to change the code. But I tried that but it exports differently then whats in the text box so that is what really confused me.

Nope no change. I think it might be a problem with the loop but in the table I have if it has criteria 9556 and SSN in the file name to name it O-[Fname] and if it is just 9556 in the file name N-[Fname] but it always names it with the N reguardless. I got it to work but its slow, I only...

Sorry I should have been more specific. I didn’t really know how to ask the question (I was a little brain fried yesterday, Work has me redoing all of their coding) Anyways! So I have 2 tables basically, 1 with file paths and file names of files in a specific drive, and 1 with client numbers...

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

Wow. Nevermind I figured it out. I mean its kind of a work around but i really thought outside the box. I just set a text box as my recordset and then called the txtBox from the query. Which works out even better because now the text box shows exactly what report is running. I do appreciate...

Opps sorry the fields in the query are [Master #] and [Master Name] would be the client number and client name. Sorry about that.

Basically I have a report that pulls from the query but what I had before was the txtBox in the query criteria so whatever client number you enter pulls the corresponding report. Now that I got rid of the txtBox I dont have a way to put the corresponding client number for that report in the...

Here is the code I have as of now. Private Sub cmdYesandDiv_Click() 'Yes and Div Dim blret As Boolean Dim Filter As String Dim strDate As String Dim stdispname As String Dim stdocname As String Dim stsumname As String Dim stdivname As String Dim rs As DAO.Recordset Dim db As DAO.Database Set...

Ok, I figured out how to loop it using a recordset but since I did and got rid of my text box. I now have to place that record set as a query criteria but for some reason its not working. But the loop actually works perfectly. Any suggestions?