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.

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" <Grasavong@discussions.microsoft.com> wrote in message 
news:5E0BA5E5-6D16-4834-B982-42FE83C5AA43@microsoft.com...
> 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,
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" wrote:

> 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" <Grasavong@discussions.microsoft.com> wrote in message 
> news:5E0BA5E5-6D16-4834-B982-42FE83C5AA43@microsoft.com...
> > 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. 
> 
> 
> .
> 

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.

"Grasavong" <Grasavong@discussions.microsoft.com> wrote in message 
news:8AE08A82-8428-44CB-B400-1B805CD09206@microsoft.com...
> 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" wrote:
>
>> 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" <Grasavong@discussions.microsoft.com> wrote in message
>> news:5E0BA5E5-6D16-4834-B982-42FE83C5AA43@microsoft.com...
>> > 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.
>>
>>
>> .
>>