Re: Pictures in Forms associated with specific ID's

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" <u12179@uwe> wrote in message
news:741702d58cdac@xxxxxx
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 wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200706/1



.

Relevant Pages

  • Re: Pictures in Forms associated with specific IDs
    ... When you want to display the ... rank, position) with relationships from the main patrolID to the patrolID in ... the patrol table, etc. ... Jason Lopez wrote: ...
    (microsoft.public.access.forms)
  • Re: CSI Miami Bald Cop?
    ... shaving his head, and moving to patrol? ... I was surprised when someone said it was a promotion. ... that going from detective to patrol would be ... He went up in rank and pay grade. ...
    (rec.arts.tv)
  • Re: Ranking Records in a Select Query
    ... When you actually display the ... records getting the position in the recordset / rank is easy. ... > 1) Displaying a ranking next to each entry (this is a top sellers ... >>> I'm running Access 2002. ...
    (microsoft.public.access.queries)
  • Re: HK - Honor
    ... it does still count in a few places - e.g. the highest ranked player ... will be auto-assigned battleground-leader when they join.) ... and can choose to have this rank displayed in front of your name. ... you can choose to display it. ...
    (alt.games.warcraft)
  • Re: Please Help... (Grouping and Ranking)
    ... but the problem is I want the rank is written automatically. ... Click on the 'star' to ... identify the sort direction, and clear the "Display" box, as they are already ...
    (microsoft.public.access.formscoding)