Inserting Pictures into Forms (1 Viewer)

Naia · Nov 16, 2007

I want to insert pictures into forms. I don't want to use links, the image must appear on the form. I created an OLE but when I insert the picture it appears very small with the file name underneath it. The icon box was not selected during the insertion procedure. I am using bitmap files, I would prefer to use jpegs, however, when I insert this file type the generic icon image appears.

I am using Access 2003.

If OLEs are not the best method for inserting pictures, could you please point me to a better method. Preferably with instructions on how to execute.

Thanks, N

GAB · Nov 16, 2007

go to insert on the tool menu and click on picture from there you can browse to the folder where your picture resides. Click on the picture and in will insert it into your form. In the properties box you can choose to have it linked or Embedded. Choose Embedded then you have several sizing options under size mode that will allow you to size the picture the way you want it. This will work with jpgs.

Gary

Naia · Nov 17, 2007

Not Quite

I don't think I was specific enough with my question.

I want to insert a different picture into each form screen. Kind of like a field entry area. The attached picture is what I am seeing.

rosito · Nov 19, 2007

this is a way, not the best, maybe....
ADD images in ur table (in Design view-> in Date type click "OLE object")

BarryMK · Nov 19, 2007

Search the forum for posts by oldsoftboss on pictures and graphics

Simon_MT · Nov 19, 2007

Just remember OLE stands for Objects as Large as Elephants. We use over 15,000 images and ink referentially. Our jpeg images depending on the image's density range from about 15KB to just over 100KB and these in turn end about 20 times the size as an OLE bitmap file.

Secondly, storing the images in the database on the data seek, Access has to hurdle over all this images to get to any data it requires.

Simon

drshahriyar · Jan 6, 2008

i am having the same problem as you are. in one of my computer i was able to fix the problem but i don't know how. it is something to do with a filter or .dll file. i was opening the file with my acdsee software when it wrote or updated something. after that everything was ok. all of my other computers have the same problem.

drshahriyar · Jan 19, 2008

try using dbpix software to insert pictures in your database. it also saves space

Mike375 · Jan 19, 2008

Would the Employees form in the sample Northwind data base give you what is required?

Simon_MT · Jan 22, 2008

Whilst the employee form in Northwind database may give you what you require, historically the MS method has been pants. OLE Objects as Large as Elephants by converting images into bitmaps!!!

We use about 16,000 images and I would always recommend dbpix.

Simon

Inserting Pictures into Forms (1 Viewer)

Naia

Registered User.

GAB

Registered User.

Naia

Registered User.

Attachments

rosito

Registered User.

BarryMK

4 strings are enough

Simon_MT

Registered User.

drshahriyar

Registered User.

drshahriyar

Registered User.

Mike375

Guest

Simon_MT

Registered User.

Similar threads

Users who are viewing this thread