Search results

I'm not to sure, I would like another opinion on this as I'm not sure if it would return an error... I'm not in the office at the moment so can't input it to try...

Evening folks... I am hoping someone can help with the below... I have a form which has 2 text boxes on it one is for imputing a company name and one is for putting in a purchase order number. I want to be able to do the following but not sure of the coding: If the company name text box is...

Hi Folks, I'm after a piece of code which works as described below. I have a save button on a form I have a append query ready to run. When the save button is clicked, I want the code to see if a checkbox is true or not and if its true I want the append query to run if its not then I want the...

Ok I did the first option and it gave me back the correct paths in the message boxes but still isn't copying the folder from the source to destination it isn't giving me anything to suggest which of the 2 is giving the error.... I have seen on one thread somewhere something at the end which...

Forgive my novice ability how and where would I check this??

Thanks for that... that bit worked a treat... I have altered the code slightly as I had some issues after this missing a space issue but now I have an issue with the part at the bottom please see code below: [LEFT]Sub CopyFolder() Dim fso As Scripting.FileSystemObject...

sorry forgot to say the debug says it is happening on the Setfso = New Scripting.FileSystemObject line of the code

I keep having an error occurring when I use this module and I cant work out why, I have made reference to the Microsoft scripting runtime etc can anyone help please Function CopyFolder() Dim fso As Scripting.FileSystemObject Dim sSourceDir As String, sDestinationDir As String...

ok i must be doing something wrong copied and changed the bits needed but I get an error of Compile error invalid use of Me Keyword, on the sSourceDir havent got past this so not sure if the sDestinationDir works either here is the code as i have it at the moment in the module Sub...

Same error occurs

I have this code in a module but it comes up with a compile error invalid outside procedure error at the bold red line...can anyone help?? Dim fso As Scripting.FileSystemObject Dim sSourceDir As String, sDestinationDir As String Setfso = New Scripting.FileSystemObject...

Ghudson I would like to use this code but how would I get the ssourcedirectory to come from a field on my form??

Sorry ISP decided they didnt want to fix my fault before the weekend had no internet... please see below the entire code I have on the page, the part im having problems with is the coping of the entire folder and it returns a Path not found and the debug points me towards the bold red line...

I have some code where by I want to move a folder from one location to another but the strings/paths are both on the form... I have sfoldersource = me.quote_files_directory_ref But it keeps throwing back an Error... Where am I going wrong??

I have tried all sorts of different code but none seem to work, can anyone assist by writing the code on the quick and I can modify to suit field names etc

This is an addition to an existing code which creates a folder and passes information onto an email... All I wanted to do was copy a folder of files and sub folders to the one which is created... I didn't want to confuse matters with the rest of the code, I'm currently not at my desk and cannot...

Hi Guys, I have a piece of code but I need to modify it can anyone assist Dim FSO As Object Dim FromPath As String Dim ToPath As String FromPath = Me.Quote_File_Directory_Ref ToPath = Me.Files_Directory Im sure its the As Strings I need to change but not sure what to, but if anyone can see...

Afternoon folks, I have researched in depth how to do this but not got the results I want... The aim... I have a form which has a field called quote directory, this contains the path of the quote documents and sub folders, I also have a field called project directory. When a quote is...

I can appreciate database normalisation is a good way to work when building a database, however this is a database that was already built, and currently live and working doing other things not just sales, and this is a modification to that, in the short term that is needed quickly, once I get...

Folks, I'm looking for a simple piece of code that does the following... If the checkbox on the master form is true then on a subform a checkbox is also true, and the same if it's false... Any ideas