Picture links in Forms

[Frank]

I need some help please! I have a database that is
tracking football scores for this seasons games. The
report I created contains the teams who are playing and
the scores that each has accomplished. On the form there
is a drop box with each teams name and I manually enter
the scores. When I select the team desired, I would like
the team logo to appear for that team. How do I link the
Team name to a picture of the team's logo so that the logo
automatically appears.

 

[Rick B]

A similar question was just asked and answered in the "getting started"
group...

See Sandra's response below.

Rick B



----------------------------------------------------------------------------
------------
You don't! You should avoid storing the image in the mdb file - this leads
to bloating. A better way is to store the path of the image and then use
code to display the image on the form. Check here for a more detailed
explanation of the problem and links to sample solutions:

http://www.granite.ab.ca/access/imagehandling.htm


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

How do you store images in an access database. e.g JPeg of a person

I need some help please! I have a database that is
tracking football scores for this seasons games. The
report I created contains the teams who are playing and
the scores that each has accomplished. On the form there
is a drop box with each teams name and I manually enter
the scores. When I select the team desired, I would like
the team logo to appear for that team. How do I link the
Team name to a picture of the team's logo so that the logo
automatically appears.

 

[Frank]

-----Original Message-----
A similar question was just asked and answered in the "getting started"
group...

See Sandra's response below.

Rick B

Where is the getting started group. Do you mean general

Questions, new users. I ran a search for Sandra and found
nothing. Can you list the Subject line and date.

Thanks,

Frank

---------------------------------------------------------- ------------------
------------
You don't! You should avoid storing the image in the mdb file - this leads
to bloating. A better way is to store the path of the image and then use
code to display the image on the form. Check here for a more detailed
explanation of the problem and links to sample solutions:

http://www.granite.ab.ca/access/imagehandling.htm


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

How do you store images in an access database. e.g

JPeg of a person





I need some help please! I have a database that is
tracking football scores for this seasons games. The
report I created contains the teams who are playing and
the scores that each has accomplished. On the form there
is a drop box with each teams name and I manually enter
the scores. When I select the team desired, I would like
the team logo to appear for that team. How do I link the
Team name to a picture of the team's logo so that the logo
automatically appears.


.

 

[Sandra Daigle]

The subject was "Storing Images" posted by Chris, posted today (8/16/2004).
Here's the answer I gave him:

You should avoid storing the image in the mdb file - this leads
to bloating. A better way is to store the path of the image and then use
code to display the image on the form. Check here for a more detailed
explanation of the problem and links to sample solutions:

http://www.granite.ab.ca/access/imagehandling.htm



--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

-----Original Message-----
A similar question was just asked and answered in the "getting started"
group...

See Sandra's response below.

Rick B

Where is the getting started group. Do you mean general

Questions, new users. I ran a search for Sandra and found
nothing. Can you list the Subject line and date.

Thanks,

Frank

----------------------------------------------------------
------------------
------------
You don't! You should avoid storing the image in the mdb file -
this leads to bloating. A better way is to store the path of the
image and then use code to display the image on the form. Check here
for a more detailed explanation of the problem and links to sample
solutions:

http://www.granite.ab.ca/access/imagehandling.htm


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

How do you store images in an access database. e.g JPeg of a person

I need some help please! I have a database that is
tracking football scores for this seasons games. The
report I created contains the teams who are playing and
the scores that each has accomplished. On the form there
is a drop box with each teams name and I manually enter
the scores. When I select the team desired, I would like
the team logo to appear for that team. How do I link the
Team name to a picture of the team's logo so that the logo
automatically appears.


.

 

[Sandra Daigle]

Just realized that Rick pasted a copy my answer to his post. Sorry about
that!

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

The subject was "Storing Images" posted by Chris, posted today
(8/16/2004). Here's the answer I gave him:

You should avoid storing the image in the mdb file - this leads
to bloating. A better way is to store the path of the image and then
use code to display the image on the form. Check here for a more
detailed explanation of the problem and links to sample solutions:

http://www.granite.ab.ca/access/imagehandling.htm

-----Original Message-----
A similar question was just asked and answered in the "getting started"
group...

See Sandra's response below.

Rick B

Where is the getting started group. Do you mean general

Questions, new users. I ran a search for Sandra and found
nothing. Can you list the Subject line and date.

Thanks,

Frank

----------------------------------------------------------
------------------
------------
You don't! You should avoid storing the image in the mdb file -
this leads to bloating. A better way is to store the path of the
image and then use code to display the image on the form. Check here
for a more detailed explanation of the problem and links to sample
solutions:

http://www.granite.ab.ca/access/imagehandling.htm


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Chris wrote:
How do you store images in an access database. e.g JPeg of a
person





I need some help please! I have a database that is
tracking football scores for this seasons games. The
report I created contains the teams who are playing and
the scores that each has accomplished. On the form there
is a drop box with each teams name and I manually enter
the scores. When I select the team desired, I would like
the team logo to appear for that team. How do I link the
Team name to a picture of the team's logo so that the logo
automatically appears.


.

 

[Frank]

Okay,

Under How to display an image from a folder in a form or
in a report in Access 2000 site -
http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/q2
10/1/00.asp&NoWebContent=1

I was able to create a table with all my images without
putting them in the db. Now what I need to understand is
how to link the table images to the selection I have
created on the form. I believe this can be done using a
combo box is this correct?

-----Original Message-----
A similar question was just asked and answered in the "getting started"
group...

See Sandra's response below.

Rick B



---------------------------------------------------------- ------------------
------------
You don't! You should avoid storing the image in the mdb file - this leads
to bloating. A better way is to store the path of the image and then use
code to display the image on the form. Check here for a more detailed
explanation of the problem and links to sample solutions:

http://www.granite.ab.ca/access/imagehandling.htm


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

How do you store images in an access database. e.g

JPeg of a person





I need some help please! I have a database that is
tracking football scores for this seasons games. The
report I created contains the teams who are playing and
the scores that each has accomplished. On the form there
is a drop box with each teams name and I manually enter
the scores. When I select the team desired, I would like
the team logo to appear for that team. How do I link the
Team name to a picture of the team's logo so that the logo
automatically appears.


.