Upload File Interface?

[DanielWalters6]

Hi,

Using Access 03. - I am a semi-beginner.
I have a table of Suppliers, one of the fields is "Logo" Data type OLE Object.

In table view, I have added a few Suppliers to the database, and have added
their logo into the "logo" field by right-clicking > Insert Object > From
File > Found File, clicked on okay.

I then used Wizard to create a form, which displays all the fields of table,
and clearly shows logo.

However, I want my end users to be able to add more suppliers to this table,
using this form...

How would they upload an image to the database using this form? Preferably a
button, which opens a dialog box to navigate to file, rather than using a
right-click then "Insert Object" then "From File"

As I would like a simple solution.

Thank you for any help you can provide

 

[Daniel]

Youcan use the following code from the Access MVPS website to call the
standard Windows File Open/Save dialog box to allow your users to go a select
the image to add/upload.

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

Never forget, never embed pics in the db. Only save the path to the image,
not the image itself. Some more info on this can be found by searching this
forum, googling or at

http://www.mvps.org/access/forms/frm0030.htm

For an example of its use take a look at

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album