Images

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have an access page that shows employees' information. All employees’
information is ok, except their pictures are disappeared in the page.

I have checked the NORTHWIND database and known that you use the CONTROL
named Image: Image 4.

I used MORE CONTROLS feature located in the TOOLBOX bar, but I don't know
which one is right.

Please help me.

Thanks
Chi Huynh
 
Make copies of the pictures you want to link to your records (on C Drive /
hard disk) and save them as
ThumbnailPicture1,
ThumbnailPicture2,
ThumbnailPicture3,
etc , (or use the ID of the record in the table)

If you have a picture processing programme such as Photoshop or Photopaint
then use that to resample and convert. If you don’t have one of these
programmes:

1 Click start
2 Click My Pictures (if that’s where they are)
3 Right click the picture and select “Open Withâ€
4 Select Windows Office Picture Manager
5 After the picture is open click the Picture Menu then select Resize
6 Resize your picture to the correct size
NOTE. You will need to know the pixel size of your OLE box (ie.
57pixels =
2cm) To get this go back to the D Base and open the
properties box.
7 SaveAS a copy of the original (DON’T JUST SAVE or you will ruin the
original picture)

Create an OLE field in the table (use this OLE field on your form if you
wish to display the picture on a form with a particular record)

To link your pictur thumbnail with the OLE
8 Open the Table that will hold the data /picture (not the form)
9 navigate to the OLE field on the correct record and Right Click
10 Select Insert Object
11 Select Create From File and then Bitmap and then check the Link option
12 Browse to your picture and select it
13 Click OK
14 “Package†will appear in the field
15 View your image on the form

Hope this helps and points you in the right direction
 
Hi Wayne-I-M,

Thanks for your help. It works!!!. All pictures are appeared in the form,
but not in the access PAGE. I tried to create the PAGE by using DESIGN VIEW
option. However, when I dropped the photo field in the design, I received the
message " You tried to drop an OLE or binary column onto your data access
page. There is no HTML control which binds correctly to this column type". I
also tried to use Wizard to create a page. The page also didn't have the
pictures.

Please help!
 
Wayne,

The access page that I created in my dadabase. All employee's information
are appeared in the page, but not their pictures. Would you mind checking
the NorthWind sample database at EMPLOYEE page ?

I have no ideas how they can make the pictures appeared in the Employee page
at The NorthWind Sample database. I have checked the EMPLOYEE S table and
know that the photo filed has the data type is TEXT.

Please help.

Thanks
Chi
 
Oh --- Now I understand. I take that you are using a Data Access Page
(HTML). No problems.

When you create a form (or report) you can place an OLE object on the form
(or report) you can’t do this with a Data Access Page (Microsoft please note
– not good).

Anyway

The text you can see is just that. It is a text box. This is what you use
on Data Access Pages instead of OLE boxes.

It’s not too hard to do.


1st you have to go back to your table and create a “TEXT†field.

Then type in the path of the image that you want to use for the record. It
could be a person’s picture and of a product.

Next

Open you Data Access Page in design view and open the tool box then click
the Image Icon.

Somewhere on the design page just “click†where you want to put your picture
(don’t worry you can change it later)

Click “Insert Picture†box type the path of one of the pictures you will use
once the Data Access Page is finished (it does not matter which one – you are
simply creating the path) It will look something like the text you can see
on your page at the moment

The text you can see will be something like
File:///c:My Pictures|Picture 1.jpeg

Or If you are on a sever based network it will be something like
file:///\\TheCompanyServerName\ThePictureFileName\Picture2.jpg

Then click OK

You have to do this to embed the Image Control in your Data Access Page

Next (right) click the Image control box and click “Data†and in the
“Control Source area†of the properties box click the field where the path is
stored (that’s what you made in step 1 above).

Look at the form and you will see that each form has a different picture
 
Back
Top