473,883 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Hyperlink default folder

1 New Member
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\FOffic e\Documents\My Scans\Scanned\* .png

The database is located in c:\Users\FOffic e\Documents\Far mDat

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 "paraScanKe y" 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 13136
298 Contributor
"...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\FOffi ce\Documents\My Scans\Scanned\" ... this would open up a file explorer window to the specified path
Sep 15 '11 #2
8,834 Recognized Expert Expert
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, 843 views)
Sep 16 '11 #3
32,584 Recognized Expert Moderator MVP
1. Open the Microsoft Office File Dialog to the Default Folder of:
C:\Users\FOffic e\Documents\Far mDat
Would that not be better set to "C:\Users\FOffi ce\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,834 Recognized Expert Expert
Would that not be better set to "C:\Users\FOffi ce\Documents\My Scans\Scanned\" ?
It wasn't a type but it was an Oversight!(LOL)
Thank you.
Sep 26 '11 #5
Zubair Mughal
3 New Member
This is the Most Comprehensive Code, that define in Zip file. Excellent.
May 31 '21 #6

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

Similar topics

by: Randal Greene | last post by:
We are using hyperlinks quite extensively in our Access XP application, and would like to control the working directory (default folder) used by the Insert Hyperlink dialog. Thanks in advance for any ideas...
by: Freddie | last post by:
I have a simple visual basic program that looks thru my outlook inbox. I start the program from a scheduled task, running on a server. It works perfectly when I'm logged in, but when I'm not the program shuts down when it is trying to get the default folder. Is there maybe a security, that I have to be logged in, so the program can access the inbox? Who can help me?
by: gavin | last post by:
Want to print to a file in MDI Format. Have set up a Microsoft Office Document Image Writer Printer. How can I change the Default Folder in Printing Preferences in the Advanced Tab Programmatically?
by: aa | last post by:
I have installed IIS on win XP pro However I cannot find a control panel like PWS on w2k to change default folder. How do I do that?
by: Zippy | last post by:
Hi. I have recently updated from A97 to A2003. In A97, when browsing to insert a hyperlink, it would open the folder location specified as the 'Default Database Folder'. In A2003, it doesn't do that. It looks in the 'current folder'. If I 'browse', I just get the root directory.
by: Zippy | last post by:
Hi. I have recently updated from A97 to A2003. In A97, when browsing to insert a hyperlink, it would open the folder location specified as the 'Default Database Folder'. In A2003, it doesn't do that. It looks in the 'current folder'. If I 'browse', I just get the root directory.
by: mpetter | last post by:
Hi guys ! How Can I Create a contact item(Outlook 2003) in specific folder under default folder? I have this situation: Set myolApp = CreateObject("Outlook.Application") Set myNameSpace = myolApp.GetNamespace("MAPI") Set myFolder = myNameSpace.GetDefaultFolder(olFolderContacts).Folders("Teste") I would like create a contact item under Teste. Anyone?
by: tdw | last post by:
I have a working hyperlink field in a table, and it's form. I also have a working File Picker Dialog: FileDialog(msoFileDialogFilePicker), being used to create the hyperlink. What I need to do, and can't figure out how, is to have the dialog pick a folder, not a file within it. I need the hyperlink to open the folder so the user can then select a file within it to open. Right now, when navigating in the file picker dialog, clicking on the...
by: HugoFromBOSS | last post by:
Hello, All Virtualhosts are routing to my default folder. Any Ideas? Thanks
by: =?Utf-8?B?TGllbGE=?= | last post by:
I have a user who stores her documents on a different drive and when she attempts to open documents it auto defaults to My Documents instead of her other drive. Is there a way to change the default for her?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.