Prev: Access 2010 misbehaving
Next: Oracle PL/SQ L , Toronto, ON, Canada
From: Thomas Andersson on 11 Aug 2010 16:04
Hi!

I'm making a for for logging awards for players and I want it to show the
award images as I select the award. I use two tables (the log and the award
one) and wonder how to link this up.

Table 1 is Log, primary is a running count
foreign key linked to Awards is the Awardname
Awardname have a lookup function checking table 2 for available awards.

Table 2 is Award, primary is Awardname
it contains image and image2 columns (embedded ole)

On my form (for entering new data in table 1) when I select an award from
the lookup list I want the 2 stores images (in table 2) to load and show
next to the data I'm entering.

How can this be done? Bound OLE object? but how to link?
Did I miss any needed info?


From: Salad on 11 Aug 2010 17:17
Thomas Andersson wrote:

> Hi!
>
> I'm making a for for logging awards for players and I want it to show the
> award images as I select the award. I use two tables (the log and the award
> one) and wonder how to link this up.
>
> Table 1 is Log, primary is a running count
> foreign key linked to Awards is the Awardname
> Awardname have a lookup function checking table 2 for available awards.
>
> Table 2 is Award, primary is Awardname
> it contains image and image2 columns (embedded ole)
>
> On my form (for entering new data in table 1) when I select an award from
> the lookup list I want the 2 stores images (in table 2) to load and show
> next to the data I'm entering.
>
> How can this be done? Bound OLE object? but how to link?
> Did I miss any needed info?
>
>
This may or may not be of use. In a table there is a field type of
Hyperlink. It can contain 3 parts; display text, address, subaddress.
Typically the first 2. The parts are separated by the #. Entering
Me.HFld = "Award 1#C:\Test\Award1.Hpg"
will show Award1 in the text box and clicking open the picture.

See also FollowHyperLink and HyperlinkPart in help for more.
HyperlinkPart will permit you to separate the sections out.

If you drop an image object on the form and open up the property sheet
for it you will see 2 properties in the Format tab; Picture and
PictureType. Picture is the path (gotten from hyperlinkpart) and
Pictype is Linked so you don't bloat).

http://support.microsoft.com/kb/210100

You could have 2
From: Thomas Andersson on 12 Aug 2010 14:39
Salad wrote:

>> I'm making a for for logging awards for players and I want it to
>> show the award images as I select the award. I use two tables (the
>> log and the award one) and wonder how to link this up.
>>
>> Table 1 is Log, primary is a running count
>> foreign key linked to Awards is the Awardname
>> Awardname have a lookup function checking table 2 for available
>> awards. Table 2 is Award, primary is Awardname
>> it contains image and image2 columns (embedded ole)
>>
>> On my form (for entering new data in table 1) when I select an award
>> from the lookup list I want the 2 stores images (in table 2) to load
>> and show next to the data I'm entering.
>>
>> How can this be done? Bound OLE object? but how to link?
>> Did I miss any needed info?
>>
> This may or may not be of use. In a table there is a field type of
> Hyperlink. It can contain 3 parts; display text, address, subaddress.
> Typically the first 2. The parts are separated by the #. Entering
> Me.HFld = "Award 1#C:\Test\Award1.Hpg"
> will show Award1 in the text box and clicking open the picture.
>
> See also FollowHyperLink and HyperlinkPart in help for more.
> HyperlinkPart will permit you to separate the sections out.
>
> If you drop an image object on the form and open up the property sheet
> for it you will see 2 properties in the Format tab; Picture and
> PictureType. Picture is the path (gotten from hyperlinkpart) and
> Pictype is Linked so you don't bloat).

Hmm, not quite getting that but doesn't sound like what I want. If you just
forget about the info happens to be a picture it might get clearer.
When selecting something in the lookup list when entering data for table 1 I
want a related bit (non editable, just for show) of info from the linked
table 2 to show on the form.
Clearer?
The info I want to show just happens to be 2 imbedded images in Table 2.


From: Salad on 12 Aug 2010 15:54
Thomas Andersson wrote:

> Salad wrote:
>
>
>>>I'm making a for for logging awards for players and I want it to
>>>show the award images as I select the award. I use two tables (the
>>>log and the award one) and wonder how to link this up.
>>>
>>>Table 1 is Log, primary is a running count
>>>foreign key linked to Awards is the Awardname
>>>Awardname have a lookup function checking table 2 for available
>>>awards. Table 2 is Award, primary is Awardname
>>>it contains image and image2 columns (embedded ole)
>>>
>>>On my form (for entering new data in table 1) when I select an award
>>>from the lookup list I want the 2 stores images (in table 2) to load
>>>and show next to the data I'm entering.
>>>
>>>How can this be done? Bound OLE object? but how to link?
>>>Did I miss any needed info?
>>>
>>
>>This may or may not be of use. In a table there is a field type of
>>Hyperlink. It can contain 3 parts; display text, address, subaddress.
>>Typically the first 2. The parts are separated by the #. Entering
>>Me.HFld = "Award 1#C:\Test\Award1.Hpg"
>>will show Award1 in the text box and clicking open the picture.
>>
>>See also FollowHyperLink and HyperlinkPart in help for more.
>>HyperlinkPart will permit you to separate the sections out.
>>
>>If you drop an image object on the form and open up the property sheet
>>for it you will see 2 properties in the Format tab; Picture and
>>PictureType. Picture is the path (gotten from hyperlinkpart) and
>>Pictype is Linked so you don't bloat).
>
>
> Hmm, not quite getting that but doesn't sound like what I want. If you just
> forget about the info happens to be a picture it might get clearer.
> When selecting something in the lookup list when entering data for table 1 I
> want a related bit (non editable, just for show) of info from the linked
> table 2 to show on the form.
> Clearer?
> The info I want to show just happens to be 2 imbedded images in Table 2.
>
>
Don't know what to suggest. I know I'd go hyperlink.
 | 
Pages: 1
Prev: Access 2010 misbehaving
Next: Oracle PL/SQ L , Toronto, ON, Canada