Search results

Thanks for this, I took note and amended my code as per last post. Still one last issue if you have any ideas on it (see previous post), thanks

Nearly there, One last problem if anyone can help....?!? I have got it half working as per the following code. If the response to the Folderexists function is false then it creates the directory and then copies all of the files as required. However, if the response to Folderexists function is...

Thanks so much, with your input and a few other changes I have got it working to a fashion with the following code: While (Not .EOF) Dim fsObject As Object Set fsObject = CreateObject("Scripting.FileSystemObject") fsObject.CopyFile rs!DatasheetPath...

Hi, thanks for that, I've changed that around and that has solved that, next question: I then want to cycle through the records and use the file location URL in the DatasheetPath field to copy the file to a new location. I wrote the following: Code Tags Added by UG Please use Code Tags when...

Thanks for the suggestion. I did that and got the following in the immediate window: Code Tags Added by UG Please use Code Tags when posting VBA Code https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ [CODE] SELECT

Hi all, I am a new member to the forum having recently signed up. I've used the forum as a useful resource recently and keen to get involved! Initially I wonder if anyone can help. I have a cmd button on a form called "Orders". When pressed I want it to run an SQL query to create a record set...