I have a table where I use a field that is a hyperlink to hold a file name. The user gets an open dialog box to pick the file to use. That works fine. Then I want to strip the path and the file extension off to store in another field. It kind of works. It strips the path, but does not work...
I have a table with a hyperlink field that is a relative pathname to a PDF file that I want to display in the form. The database is on the desktop and the path is relative to the desktop. How can I display it? Any help would be appreciated
My name is Gary Burt and I am teaching myself Access. I am building a database of my recipes. I am learning a lot about Access and getting to respect it a lot.