Results 1 to 5 of 5
  1. #1
    johnnyBQue is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    33

    Hyperlink in forms Question

    Hey guys & gals...



    Question...I have 3 attachment boxes in my table that appears in a form.

    each attachment box contains specific files (not specific as in extension such as PDF, JPEG, etc.) but specific as in Company Documents, Certifications, Resumes.

    The issue is there's a lot of document and I see my database growing (fast)...
    My question finally is....
    Can I use a Hyperlink to open a folder within a specific directory where multiple file are located so i can open the specific file need there RATHER than attaching them in the attachment box individually?.?.....If not any suggestion as to how this can be done (no SQL) unless that route is very simple and basic coding.

    My thinking would be to place the file path to the documents in the table and hyper link that column in the table, but not knowing exactly how Hyperlinks work I don't think it would actually work...otherwise it they wouldn't make it that easy...lol

    thanks guys...

  2. #2
    johnnyBQue is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    33
    Okay may have a temp fix....if I zip/rar the files there only a fraction of the size as if you add the individual together unzipped...the zip/rar file attaches with no issues and it opens with no issues...the user has to make an extra click to "unzip" but that's no big deal....My database is a gig and half (1.63gb) the way it is now (all files attached individually) I'm going to zip everything and re-attach to see the difference is database size...would still like to know about the Hyperlink option tho...

  3. #3
    johnnyBQue is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    33
    well the 1.6gb was when I had about have the data I needed to input entered...I went back and zipped all the file and then attached them and entered ALL the data and the database is at 1.94gb......so not much room for expansion....I need to look in to my options here any suggestion would be welcomed.

  4. #4
    johnnyBQue is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    33
    Well I can wipe the dum-as name off my fore head ....experimented with the Hyperlink and found that I could hyperlink a file path and when click it goes straight to the file so instead of having attachment field I'm going to make Hyperlink boxes and put the path to the folder that contain the files I need to access and let that be that ...I'll post back how much it reduces the 1.94gb.

  5. #5
    johnnyBQue is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    33
    lmao....my data base is now 5.6Kb.....sweet.....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Forms Question
    By cbende2 in forum Access
    Replies: 3
    Last Post: 06-27-2014, 11:03 AM
  2. Very Newb question on hyperlink
    By skim464 in forum Access
    Replies: 1
    Last Post: 04-01-2014, 09:20 AM
  3. Replies: 4
    Last Post: 01-05-2013, 11:07 AM
  4. Hyperlink Question
    By bmschaeffer in forum Reports
    Replies: 1
    Last Post: 10-20-2011, 03:33 PM
  5. Replies: 4
    Last Post: 01-31-2011, 03:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums