Images in Access 2002

R

rap43

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?
 
K

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]
 
R

rap43

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

Ken Snell (MVP) said:
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>


rap43 said:
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?
Click to expand...
Click to expand...
 
K

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>




rap43 said:
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

Ken Snell (MVP) said:
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>


rap43 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
R

rap43

Thanks Again


Ken Snell (MVP) said:
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>




rap43 said:
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

Ken Snell (MVP) said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Top