Hyperlink default folder

[topperfox]

I am an Access 2010 newby.

I have a database that keeps track of all farm documentation such as scanned receipts, logs, inspections, etc. All of these scans are in the folder: C:\Users\FOffice\Documents\My Scans\Scanned\*.png

The database is located in c:\Users\FOffice\Documents\FarmDat

It is a real pain to have to select the path for every single record to the same folder when I add the hyperlink.

I have a parameter "paraScanKey" that has the name of the scan but not the path. What I really would like is for Access to add the hyperlink so that there is no human error.

[pod]

"...when I add the hyperlink."

Are you working with a form?
... using VBA code?

Have you tried making use of the default value in your table?
ex: Default Value : "C:\Users\FOffice\Documents\My Scans\Scanned\" ... this would open up a file explorer window to the specified path

[ADezii]

I created a Demo for you that will:

1. Open the Microsoft Office File Dialog to the Default Folder of:
   

   C:\Users\FOffice\Documents\FarmDat

2. Filter the Dialog only to display *.png Files.
3. Once you Select a *.png File, it is automatically copied to a Text Box Bound to a Hyperlink Data Type Field.
4. What this essentially does is to Copy the Hyperlink directly to the underlying Hyperlink Field in a Table.
5. Download the Attachment to see what is happening first hand.

[NeoPa]

ADezii:
1. Open the Microsoft Office File Dialog to the Default Folder of:
C:\Users\FOffice\Documents\FarmDat

Would that not be better set to "C:\Users\FOffice\Documents\My Scans\Scanned\"?

Unfortunately, most of us don't have the time to investigate attachments, so I wasn't able to tell if this was a typo. I'm only going by what's in the post (which is true for most users of course) so remember that's where the answer mainly needs to be.

[ADezii]

Would that not be better set to "C:\Users\FOffice\Documents\My Scans\Scanned\"?

It wasn't a type but it was an Oversight!(LOL)
Thank you.

[Zubair Mughal]

This is the Most Comprehensive Code, that define in Zip file. Excellent.