Access MVP (2010-2015)
To open a file regardless of the File Extension you can use…
The below is run from a Command Button on a Form the has a Control listing all the files in said directory.
Windows XP…
Dim strFileName As String strFileName = Dir("C:\Documents and Settings\Regina Whipp\My Documents\YourFolcer\" & Me.FieldOnYourFormThatHasFileName & "*") Application.FollowHyperlink ("C:\Documents and Settings\Regina […]
