Images in Access 2002

[Guest]

I like to display an image in a form for Identification (IDs) .
I have a table with the ImageID field and PictureFilename Field.
I also have a table with subjectID, firstnameID and lastnameID and the table
have relationship.
Can I create a form that will display a image (jpg), I though I ‘d have form
with a subform to display the image? The image will be in the same folder as
the database. How can this be done if it can?

 

[Ken Snell \(MVP\)]

Put an image control on the form (can be the main form) that has the
PictureFilename field in the form's RecordSource query. Set its Picture
property to
=CurrentPath & "\" & [PictureFilename]

 

[Guest]

Thanks Ken for your help but I'm lost as to what is the image contorl to use,
I've tried a few different thing object frame ane some activex controls.

Thanks again Ralph

Put an image control on the form (can be the main form) that has the
PictureFilename field in the form's RecordSource query. Set its Picture
property to
=CurrentPath & "\" & [PictureFilename]

--

Ken Snell
<MS ACCESS MVP>

I like to display an image in a form for Identification (IDs) .
I have a table with the ImageID field and PictureFilename Field.
I also have a table with subjectID, firstnameID and lastnameID and the
table
have relationship.
Can I create a form that will display a image (jpg), I though I 'd have
form
with a subform to display the image? The image will be in the same folder
as
the database. How can this be done if it can?

 

[Ken Snell \(MVP\)]

The control that you want is the Image control, which is available from the
Toolbox toolbar. The icon for this control on the Toolbox is a mountain with
a sun above the mountain's peak.
--

Ken Snell
<MS ACCESS MVP>

Thanks Ken for your help but I'm lost as to what is the image contorl to
use,
I've tried a few different thing object frame ane some activex controls.

Thanks again Ralph

Put an image control on the form (can be the main form) that has the
PictureFilename field in the form's RecordSource query. Set its Picture
property to
=CurrentPath & "\" & [PictureFilename]

--

Ken Snell
<MS ACCESS MVP>

I like to display an image in a form for Identification (IDs) .
I have a table with the ImageID field and PictureFilename Field.
I also have a table with subjectID, firstnameID and lastnameID and the
table
have relationship.
Can I create a form that will display a image (jpg), I though I 'd have
form
with a subform to display the image? The image will be in the same
folder
as
the database. How can this be done if it can?

 

[Guest]

Thanks Again

The control that you want is the Image control, which is available from the
Toolbox toolbar. The icon for this control on the Toolbox is a mountain with
a sun above the mountain's peak.
--

Ken Snell
<MS ACCESS MVP>

Thanks Ken for your help but I'm lost as to what is the image contorl to
use,
I've tried a few different thing object frame ane some activex controls.

Thanks again Ralph

Put an image control on the form (can be the main form) that has the
PictureFilename field in the form's RecordSource query. Set its Picture
property to
=CurrentPath & "\" & [PictureFilename]

--

Ken Snell
<MS ACCESS MVP>


I like to display an image in a form for Identification (IDs) .
I have a table with the ImageID field and PictureFilename Field.
I also have a table with subjectID, firstnameID and lastnameID and the
table
have relationship.
Can I create a form that will display a image (jpg), I though I 'd have
form
with a subform to display the image? The image will be in the same
folder
as
the database. How can this be done if it can?