Attach/upload/link files to a form

[Grasavong]

I'd like to create an upload button in an access form that allows the user to
upload a file, but I have a few questions:

1. Is this efficient? I'm assuming that if you upload multiple files on
Access, there wouldn't be a lot of space available.
2. The reason I would prefer an upload is that I don't want to use the
hyperlink option because hyperlinks can get broken either by a file being
accidently moved to another directory or folder or simply changing the file
name.
3. If uploading files onto an Access form -is- efficient and feasible, what
kind of code would I have to write? I'd like to use a click event procedure
and use a button called "Upload."

(These uploads would apply to extensions like pdf., xls, doc. etc, etc.)

Any help would be appreciated.

 

[Jeff Boyce]

I'm having trouble visualizing what you're trying to do ...

What do you mean by "upload a file onto an Access form"?

Do you mean the data in a file, or a picture file?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Grasavong]

Jeff,
I guess what I'm trying to accomplish is this:
I have a form where I want to upload a file of some sort. I'm not trying to
import data to a table or anything like that. Here's an example: Suppose
you're a business who has to upload a certificate into a customer's website,
and you click on the 'upload' button and browse where your certificate is and
attach it.

I created a form for our Sales department to use to enter in customer
information and I want to have a place where they can upload or attach prints.

But, I'm not sure attaching files into Access is very efficient because it
would make the file too big and I don't want to do hyperlinks because the
links get broken too easily.
I hope I clarified it better, it does sound confusing.
Thank you,
Gwen Rasavong

 

[Jeff Boyce]

I guess I still don't get it ...

If there's a certificate, why would you only wish to "upload it to a form"
.... and what do you mean by that?

Do you mean you wish to use a form as a "container" to (temporarily) display
the certificate, but not save it?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.