User to choose logo

[Karen]

I have many reports that are all used by 3 different segments. Each segment
has a different logo that will need to be inserted into the report header.
Is it possible to have the user select which logo they want to add?

 

[bhipwell via AccessMonster.com]

Create a table to store your three logos and assign them a number. For
example:

Column 1 = Unique ID
Column 2 = Identifier (such as "1", "2" and "3")
Column 3 = Insert your logo via hyperlink edit (you can insert the bitmap
through the edit hyperlink function of this field, once updated, you can
delete the logo from where ever you had the logo stored on your computer)

On your form, create a drop down box with the three logo options that will
update a hidden field using the after update event:

AfterUpdate
Me.HiddenField = Me.DropDownBox

On your report, set the field to display the logo to the hidden field on your
form.

B

 

[Karen]

When I select the logo from the form drop down, I get an error that says that
it can't open the file and lists the hyperlink and sends me to my code tp
Debig
Me.Picture = Me.Brand

Not sure what I am doing wrong. Let me know what additional info I can
provide.

 

[bhipwell via AccessMonster.com]

Cannot open file usually means that data doesn't exist for that field.
Access is looking for it but it is a null value, thus the "Can't open file"
error. Also, try to bitmap images instead of jpg.

 

[Karen]

As it turns out, this database will be housed on multiple desktops (not
shared on a server). I will have to embed the objects instead of hyperlink.

I have the hidden field on the form showing the ID number. For the report,
how do I get the logo to show and not the ID number.
Thanks for your help

 

[bhipwell via AccessMonster.com]

You need to use a bound object frame versus a field. (help has good
information on this)

 

[Karen]

Thanks - I added the bound object frame but I am having difficulty getting
the picture to show on the report. I am not sure the correct code to use to
get the selection from the form. The form has the drop down listing the names
of the logos and the hidden field shows the corresponding ID.