Search results

Thanks for all your help guys, I managed to solve the problem by doing the following: Application.Run(function) This forces the resolution of the function which you can then plug in later on in the code. Seems like a fairly obvious thing to do to be honest, can't see why i didn't spot it...

The Debug message box shows: INSERT INTO tblexample (fileName, filePath, fileExt, beforeFileName, afterFileName, dateImported) SELECT "FileName(strTemp)" , "\\shared\examplefolder\" , ".pdf" , "FileFirstUnderScore(strTemp)" , "FileSecondUnderScore(strTemp)" , "10/11/2007" where...

Thanks for your suggestion OlcayM, I don't think I explained the problem properly. What I am looking for is the correct syntax for the string SQL that allows the variable(which is a function name & arguments string) to be resolved before the SQL is executed. Or any other suggestions for...

Hi Everyone, Hours of frustration have led me to this point... I have various functions in VB which will parse strings into start middle and ends dependent on the string format. So 3 functions will return a_, b and _c if fed a_b_c. There is more than one string format so there are 3 more...