Hyperlink in forms Question

[johnnyBQue]

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...

[johnnyBQue]

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...

[johnnyBQue]

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.

[johnnyBQue]

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.

[johnnyBQue]

lmao....my data base is now 5.6Kb.....sweet.....