Recent content by AndyG

This works great but, in my table I also have file locations (Table is loaded with files from directories, ie c:\documents\pictures\1212.jpg) I would like to delete the file in the directory as well as the row in the table to get rid of duplicates. (ie same file in 2 different locations) I know...

Thanks all, very useful information in all of the thread. The code "shell aplication" works great! However I will speak to the users as some of their directory names and file names are out of control (i.e Collecties\Museum algemeen\Archief\Tentoonstellingen en...

i tried the following and it works but if the path is a "normal" lenght path i get 2 pop ups (pictures in my case) but when used against a "long" lenght path I get just the 1 popup, which is what I want. Any ideas why Dim strpath As String strpath = Text25 Shell "explorer.exe " & strpath...

I would like to use this solution but as I am not an expert and was not able to search and find a solution could you please post all the code I would need ? I am just using Private Sub View_Photo_Click() FollowHyperlink Me.Text25 End Sub What code do i need to replace this? I am using...

the above works from the c:\ but not from g:\ (google grive) it just messages the orginal file path?

Hi All, Have searched and not been able to find a solution but, - Is there code I can place in an update query to convert a column of long filenames to shortfile names? My users have many folders and tend to use over-descriptive file names which means there are cases where follow hyperlink...