Upload file

  • Thread starter Thread starter Annemarie
  • Start date Start date
A

Annemarie

Is it possible to allow the user to upload a file while entering data
into a form? I am thinking of the format similar to how the internet
allows someone to upload...by browsing the computer etc. Is this
possible? or is there another format through which this can be
achieved?

Thanks,

Annemarie
 
Is it possible to allow the user to upload a file while entering data
into a form? I am thinking of the format similar to how the internet
allows someone to upload...by browsing the computer etc. Is this
possible? or is there another format through which this can be
achieved?
Click to expand...

You can browse the internet, launch excel, use word, and also continue to
enter data into a ms-access form.

You can also open a ftp site, and upload files. So, windows is
multi-tasking, and you can run other programs while using ms-access.

I don't see why you can't upload a file while continuing to use enter text
into word, or entering information into ms-access...

Without more details as to what kind of file you want to upload, and when,
where, how, and by who is to upload this file, I can't give you much more
details, but I don't see any reason why you can't upload some file (say a
pdf file) while continuing to enter data into a ms-access form.
 
Thanks Albert.

I was loooking for more of what type of interface a user would be able
to see in order to upload a file. Say if a user was working in a form
to enter data and had a PDF or word document they wanted to attach as
supplemental information, how could they attach that file? The
interface I am imagining is like the internet where if you want to
attach something you browse the comptuer for the file and click attach.
Does this make more sense?

I know you can put a OLE Object in a form. Would the best way to
tackle this problem be to add a event procedure for double click on
that field in the form? If so could you help with the code?

Thank you!

Annemarie
 
Ah, ok.

You are looking for a way to open the "file browse" dialog to select a
file....


Lots of examples on how to do this.

You can download my "shift key example" here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

The code used to "open" the file dialog browse window can be found here:

http://www.mvps.org/access/api/api0001.htm

My shiftkey uses the above sample code...

I know you can put a OLE Object in a form. Would the best way to
Click to expand...
tackle this problem be to add a event procedure for double click on
that field in the form? If so could you help with the code?


Right. As a suggestion, you really don't want to store the file in
ms-access, but a field that saves the path name to the file of your choice
on the hard disk makes a lot of sense. The above api code is thus a good use
for this.
 
Back
Top