Access 2007 paste into form and create hyperlink

Posted on 2010-01-06
Medium Priority
Last Modified: 2013-11-28
I am trying to find a way to do the following:
I want a user to be able to either paste or drag and drop a document (pdf, jpg, doc, xls, etc)
from outside of Access to a textbox or similar control. On this event, Access should do the following:
-Create a new folder for the company name in the dbase parent folder if one does not exist.
-Create a new folder for the form number (unique value) if one does not exist.
-Copy the document from its location to the subfolder if it exists or after the subfolder is created.
-Ask the user what filename they want to assign to the copied document
-Save the doc as that filename
-create a hyperlink in the access form (again I see this as a textbox) with the name and a link to the saved document.

The user should be able to copy as many documents (within reason) into the form as they wish.
The names of the hyperlinks should appear in the textbox, seperated by commas, as in:
document1.doc, document2.pdf, document3.txt etc...
And finally, the user should be able to open these documents by clicking on the hyperlink.

Whew! I know how to accomplish the majority of the file manipulation via VBA but the Access functionality is new to me. I have included the entire idea for completeness and any help is greatly appreciated!
Question by:JP_TechGroup
  • 2
LVL 31

Expert Comment

ID: 26194923
This question is a complete project!
Don't expect any one to visit it. You have to do some homework and ask specific questions about issues you face during the process.
Each question should address one issue.
LVL 44

Accepted Solution

GRayL earned 2000 total points
ID: 26194957
Why not leave the document where it is. Create a table with the field DocHyperlinks (type Hyperlink),  bind the form to the table, right click on the hyperlink control on the form, and use the wizard to navigate to the document, and provide the name you want to see in the control on the form.  I sailed around the world, have a few thousand pictures in several directories - that is how I access them from my form.  Of course, I have another field describing the segment of the trip,so that I can scroll to the segment of interest,  see all the linked jpg's, double click on any one, and up pops the Windows Fax and Picture Viewer.  I don't have the trip data any where near the location of the mdb.

Author Closing Comment

ID: 31673619
Close enough. Thanks for reading the WHOLE post!
LVL 44

Expert Comment

ID: 26382739
Thanks, glad to help.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question