Search results

Figured it out I finally realized what I had done wrong, well perhaps not wrong, but the piece I was forgetting. In the beginning portion of the For-Next loop I was running: Set ObjTStream = FileSystem.OpenTextFile("D:\Work\TopLevelFolder\" & file.Name, 1) Normally, I run the...

Are you attempting to do this in a form? If so, you can always check a field for information then run your queries, and move to the next record. Do while [ID FIELD] > 0 or Do While Not me.[DATE FIELD] <> "" '''run queries '''You may also want to place some validation of the date field here...

Well, I actually am one of the sys admins as well, and I checked the permissions on the folder. I have full control on the folder and any subfolders within, as do anyone that would be running this sub. I even went as far as adding the everyone group and giving them full control to the folder...

Hello, I am attempting to k*ll a file after I have moved it from one folder into a subdirectory of that folder. Dim FileSystem, folder, objFile Set FileSystem = CreateObject("Scripting.FileSystemObject") Set folder = FileSystem.GetFolder("D:\Work\TopLevelFolder") Set...