Pictures in Forms associated with specific ID's

[Jason Lopez]

While I know there is a program out there for this, I want to learn to do
this with Access. I have a group of scouts that I want to maintain some
records (so I can learn Access a little better) in the database. I have all
of them loaded into one table by basic information. What I would like to do
is place their information on a form that has not only their current rank
displayed, but also their patrol and position. That would be part of the
basic information in that one table. But, I am wondering how I would get
that to display so that as I cycle through each boy, I don't have the same
graphic displayed.

I saw a tutorial once on how to do something like this. But I can't seem to
stumble upon it again.

Jason Lopez

 

[jahoobob via AccessMonster.com]

About what graphic are you speaking? If you want a graphic of say their rank
(picture of their pocket patch) you could cerate a table of ranks with an OLE
field to put a picture of the badge. Link this to the basic information
table via the rank in a query and base your form on this query.
Note: You should have an numerical index for the rank table that is stored in
the basic info table as your link.
Hope this answers your question. If not, provide a little more info and get
back.

 

[Jason Lopez]

The way I have it set up is to have one main table with the basic scout
information. A second table will have the patrols; third, the ranks;
fourth, positions. When the form is created, I am hoping to have the ID for
the respective patrol, rank, and position, recorded in the main table as a
number (ID number for respective patrol, rank and position). Users will
select using the name, but ID number will be recorded instead.

Then, once that selection is made, I am wanting to have an automatic update
through the "After Update" event to display the appropriate graphic for
rank, position and patrol. But, how do I set up tables or associations so
that the images are displayed correctly?

As I mentioned before I found something once that showed how to set up
something like this. But I cannot seem to find it again.

Jason Lopez

 

[jahoobob via AccessMonster.com]

In each of the three table create an OLE field for the graphic. The stored
ID as you have described is the way to go. When you want to display the
scouts info in a form or report use a query of all four tables (main, patrol,
rank, position) with relationships from the main patrolID to the patrolID in
the patrol table, etc.

The way I have it set up is to have one main table with the basic scout
information. A second table will have the patrols; third, the ranks;
fourth, positions. When the form is created, I am hoping to have the ID for
the respective patrol, rank, and position, recorded in the main table as a
number (ID number for respective patrol, rank and position). Users will
select using the name, but ID number will be recorded instead.

Then, once that selection is made, I am wanting to have an automatic update
through the "After Update" event to display the appropriate graphic for
rank, position and patrol. But, how do I set up tables or associations so
that the images are displayed correctly?

As I mentioned before I found something once that showed how to set up
something like this. But I cannot seem to find it again.

Jason Lopez

About what graphic are you speaking? If you want a graphic of say their
rank

[quoted text clipped - 26 lines]