471,311 Members | 1,912 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,311 software developers and data experts.

Hyperlink default folder

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.
Sep 15 '11 #1
5 12672
298 100+
"...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
Sep 15 '11 #2
8,826 Expert 8TB
I created a Demo for you that will:
  1. Open the Microsoft Office File Dialog to the Default Folder of:
    Expand|Select|Wrap|Line Numbers
    1. 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.
Attached Files
File Type: zip Copy Hyperlink.zip (14.5 KB, 814 views)
Sep 16 '11 #3
32,404 Expert Mod 16PB
1. Open the Microsoft Office File Dialog to the Default Folder of:
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.
Sep 26 '11 #4
8,826 Expert 8TB
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.
Sep 26 '11 #5
Zubair Mughal
3 2Bits
This is the Most Comprehensive Code, that define in Zip file. Excellent.
May 31 '21 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Randal Greene | last post: by
reply views Thread by Zippy | last post: by
reply views Thread by Zippy | last post: by
3 posts views Thread by =?Utf-8?B?TGllbGE=?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.