Picture links in Forms

  • Thread starter Thread starter Frank
  • Start date Start date
F

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.
 
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
Click to expand...





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.
 
-----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
Click to expand...
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
Click to expand...
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.


.
Click to expand...
 
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
Click to expand...
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
Click to expand...





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.


.
Click to expand...
Click to expand...
 
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.


Sandra said:
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
Click to expand...
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.


.
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...
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.


.
Click to expand...
 
Back
Top