Search results

And it WORKS! Thanks you everyone. Hopefully i'l be able to help some people out at a later date what I have a better grasp of what's going on.

I just wanted to hop on and thank everyone for there help. Its still choking up for whatever reason after creating the 1st txt file before copying the records into it but i'm sure its something dumb that I either accidentally changed on my end or don't realize I have to change. Thanks Pat and...

Right now it looks like my problem has something to do with strPath = strPath & Format(iFolderCount, "0000") and the Open strPath & "\" & RTrim(rst!productcode) & ".txt" For Output As #1 . After removing the str = path & Format it ran but bumped up against the file limit. But when I put it...

I was pulling the 0 error before but I figure it was coming up with that to tell me their were no errors. I'm running it right now from the Microsoft Visual Basic for Applications editor from Access just by using the run tab. I'm currently trying to set up a button in Access because i've read...

I've been trying to get it to work but It isn't accepting the Sub MakeDir to make the directory. - Nevermind I had something dumb that was messing it up. But it is still giving a 424 error at the OpenstrPath... This is what i'm putting in i'm still confused about what is going on. Sub...

This seems to be giving me a 424 error on the Open strPath line, it looks like my starPath is set correctly but It is still giving me the error?

Ignore my last post, i've gotten it to run by running Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("Select * From YourTable") For counter = 1 To 1500 While Not rst.EOF And Not rst.BOF Close #1 Open "C:\SomeDir2\" & RTrim(rst!Title) & ".txt" For Output As #1 Print #1...

Thanks for your help Pat. I'm struggling getting the counter to work within the loop. From what i've been able to gather it should be a For counter = start To end Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("Select * From YourTable") While Not rst.EOF And Not rst.BOF Close...

I found this thread when looking to do something similar to the original poster, but I am having trouble running the script that WayneRyan posted. It seems that I am getting 2 specific problems that should be fairly simple to figure out but I have not been able to. The first is that in my...