Re: [MSAccessProfessionals] problem wit collecting file names

I ran a test with the file name:  Selecting. Tab Control Page's $.PNG using the code:

 

Private Sub Command31_Click()

    Dim strFilepath As String

    Dim var As Variant

    strFilepath = Me.txtFilePath & ""

    If strFilepath = "" Then GoTo exit_sub

    var = FileDateTime(strFilepath)

    MsgBox var, , "Var:"

exit_sub:

End Sub

 

The message box displayed the date time – no error.

See if it works for you.

 

M

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of onnoknol
Sent: Monday, June 22, 2020 10:59 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] problem wit collecting file names

 

Hi to be more precise: i get an error when I have a stored full path name with a special character, and i try to get the details with the function FileDateTime. (of course when I call this function, I have "requoted"  the fullpath so that the ~  I mentioned  earlier
are set back to normal)  So, I can narrow  the question to: why does FileDateTime not accept a filename with a special character in it? And wat is a workaround  for that?