Bound Image Frame Question

  • Thread starter Thread starter Chris Stebbins
  • Start date Start date
C

Chris Stebbins

Greetings,

I got a (hopefully) simple problem that you may help me
with. It involves embedding images in an Access form.
Here is how it plays out:

* I have a form pointing to a table with over 300
records. This table has a field ('photoname') containing
the path and filename of a jpeg image.

* We have a directory full of jpeg images in the same path
and filename as stated in 'photoname' (over 300).

* I wish to create an image Frame in the form that
references the 'photoname' field and shows the
corresponding jpeg image as that record is viewed.

In the form, any added record allows the user to select
the image window and browse and Link to the corresponding
jpeg image.

I have created a 'Bound Object Frame', yet the image
referenced in the 'photoname' field never shows up. I
know this is probably simple, but all attempts I've
previously made not panned out. Many thanks in advance
for your help.

Chris
 
Use a >linked< (OLE Type Allowed) - Bound Object frame. The file name in your database will link the image into the frame
 
Based on your instructions, I created a Bound Object Frame
in the form, using the 'photoname' field as the Control
Source. I then selected 'Linked' as the OLE Type
Allowed. As a result, the image--as stated in
the 'photoname' field--will still not show itself.

What format does the 'photoname' field need to be? When I
choose 'OLE Object' as the field Data Type, the path
disappears and becomes 'Long binary data'. This does not
work, please help!

Chris
-----Original Message-----
Use a >linked< (OLE Type Allowed) - Bound Object frame.
Click to expand...
The file name in your database will link the image into
the frame.
 
Hi Chris,

i like to suggest using Image control to show the JPEG image. These are the guidelines:

- Add an Image Control to your form. It will ask you to insert picture. Dont worry we'll delete it later on. So, select a valid image. Click OK to close the dialog box.
- Goto the Image control properties called Picture on tab Format. Delete whatever text in it. Answer Yes, if you were asked 'do you want to remove picture'. You can also set other properties llike border, etc.

Now add this line of code to your Form Current Event:

Me.YourImageControlName.Picture = Nz(Me.PhotoName, "")

and, probably to your Form AfterUpdate Event too.

Hope this helps.


----- (e-mail address removed) wrote: -----

Based on your instructions, I created a Bound Object Frame
in the form, using the 'photoname' field as the Control
Source. I then selected 'Linked' as the OLE Type
Allowed. As a result, the image--as stated in
the 'photoname' field--will still not show itself.

What format does the 'photoname' field need to be? When I
choose 'OLE Object' as the field Data Type, the path
disappears and becomes 'Long binary data'. This does not
work, please help!

Chris
-----Original Message-----
Use a >linked< (OLE Type Allowed) - Bound Object frame.
Click to expand...
The file name in your database will link the image into
the frame.
 
I followed your instruction and type below in Form Current field and it said Microsoft Access can't find the macro Me, what goes wrong? my Image Control named "ImageFrame" and the field stored the location of photo named "ImagePath".

Me.ImageFrame.Picture = Nz(Me.ImagePath, ""
 
Back
Top