Form Prompt and Load Image

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SilverRayven1 - 25 Feb 2007 23:58 GMT

I have a form with a button and a bound object frame. I would like to make
it so that when the button is clicked it will prompt the user to find an
image file on the computer (database is for use on single workstations) and
load it into the object frame. I've written code in VB before, but never for
Access (always for Excel) and never prompted the user to find a file. Any
help appreciated.

Reply to this Message

Tom Wickerath - 26 Feb 2007 00:04 GMT

There is a ready-made sample available to you in the 2003 version of the
sample Northwind.mdb database. This is shown in the Employees form. The code
uses Application.FileDialog, which you may want to replace with the API
method of opening a file dialog, but for now see if you can adapt this sample
to your needs.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

> I have a form with a button and a bound object frame. I would like to make
> it so that when the button is clicked it will prompt the user to find an
> image file on the computer (database is for use on single workstations) and
> load it into the object frame. I've written code in VB before, but never for
> Access (always for Excel) and never prompted the user to find a file. Any
> help appreciated.

Reply to this Message