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
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
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