Hyperlink field for a file folder

Question

I have hyperlink fields that allow me to put a link to a file with some coding. Is there a way to have it select a folder, instead of a file. We want to keep all of the files for a client in one folder with their name on it. What i would like is a field that I can click on and then save a hyperlink to that particular folder for that record. I know how to get it done for a file, but not a folder.

Answer 1

You might like to take a look at BrowseDemo.zip in my Dropbox public databases folder at:

https://www.dropbox.com/scl/fo/0scigd3r48hx5xrev2jrf/AB0-GMdTgMAO5O1cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0

This little demo file illustrates how a folder or file can be selected by means of the FileDialog property of the Application object.  The path to the folder and, where applicable, the file name are stored as text in columns in a table, not as hyperlinks.  The paths are displayed in controls in a subform, formatted to appear and act as hyperlinks.  To open a file or folder the Windows API ShellExecute function is called in a basShellExecute module.  In the case of an appropriate file, the file can also be printed directly.