Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Insert a picture in a form

Hi,

I have a table with +/- 2000 products. I have also in a seperate folder a picture of all these products. In a form with a subform i have several filters to detect one or more product.
Hereafter i can select one product to update in a new form. I would like to have the picture in this form. How do i do that?

Tx
0
sonmic
Asked:
sonmic
1 Solution
 
slightwv (䄆 Netminder) Commented:
This was cross posted in an Oracle Zone.  Is it Oracle related?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:


You might want to consider this or at least be aware of if you are dealing with images in an Access database ... and I can totally vouch for this program.  
http://www.ammara.com/dbpix/access.html

It does *all* the work for you. Examples show how to add a simple 'control' panel to Load, Save, Zoom In/Out, Size To Fit and much more.  AND ... virtually eliminates BLOAT associated with storing images in an Access MDB. I have 3 clients who sell commercial run-time products that use DBPix.

Note. I have no connection with DBPix ... except I have used it many times ...

mx
0
 
sonmicAuthor Commented:
Sorry, I made a mistake. It is MS Access related.

Can i manage pictures in access without an external application?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You can look at these free apps:


http://www.lebans.com/loadjpeggif.htm

And more image related apps on this page:

http://www.lebans.com/Form.htm

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
There are also examples here (as well as other excellent techniques/examples)

http://www.databasedevelopment.co.uk/examples.htm

Scroll down to

Storing Picture data (Download PictureData.zip)
An example of loading and storing image data using Access internal PictureData format. Another way to avoid bloat and allow east image re-use.

mx

0
 
smartcheaterCommented:
In access form Goto to the "Code Builder"
Draw a picture box on form supposing the name picture1
and select the event of form "Current" event. This event occur every time when move from current record (previous or next).

use that code for picture loading:
picture1.picture=LoadPicture("Picture Path Here")

' For example 

picture1.picture=LoadPicture("c:\windows\webs\wallpaper.azul.jpg")

Open in new window


0
 
sonmicAuthor Commented:
It has given me an idee.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now