In Excel, I can use code like 'tempstring = Application.GetOpenFilename("(xls),*.xls", , "Open File")' to browse for a filename in any folder and return it to Excel in variable 'tempstring'. I would like to do something similar in Access but cannot find the commands to access the Open-file window. The only articles I have seem, require the folder path to be hard coded.
I am trying to create a hyperlink to the file and store it in a table, along with other data.
Any ideas. Please keep it simple as I am no expert
I am trying to create a hyperlink to the file and store it in a table, along with other data.
Any ideas. Please keep it simple as I am no expert