run time error 5 on Name Function

Albilly

Registered User.
Local time
Yesterday, 20:58
Joined
Nov 25, 2015
Messages
31
Hi to all,
I am usinh the mane function to move a file from 1 folder to another one but now I am getting the error 5 invalid procedure call or argument , wsa working before but no anymore

does anyone had this problem before ?
this is how my code is
Code:
                                strName = DLookup("RepertoireAccess", "LIST_ODBC_STRING", "LABEL = '" & Me.ODBC_AFTER & "'") & Dir(strName)
                                Debug.Print strName
 
                                'replace path and add date extension
                                strNewName = strNewName & Left(Dir(strName), Len(Dir(strName)) - 6) & "_" & strDate & ".accde"
                                Debug.Print strNewName
 
                                'move old file
                                Name strName As strNewName

and this is what I get for the file name:
R:\ED\DEV\Entrepot_6.01.accde
R:\ED\DEV\Fichiers Backup\Entrepot_6.01_2016-03-23_15:37.accde

Is there a lenght limit ? the only change I added was adding the time after the date

Thanks
 
Found the solution, does not like the : in the file name

Thanks
 

Users who are viewing this thread

Back
Top Bottom