Dynamic LOGO for Report

[Dipo]

Hello, is there a way of making logo on report dynamic such that user only need to upload/modify logo at data entry level?

 

[CJ_London]

Yes - but not enough info to provide a targeted response.

1. Store your logos in a suitable folder
2. In an appropriate table have a field to store the path and file name for the logo populated by user choice
3. for the report use an image control and set the controlsource to the name of the field

 

[Dipo]

Yes - but not enough info to provide a targeted response.

1. Store your logos in a suitable folder
2. In an appropriate table have a field to store the path and file name for the logo populated by user choice
3. for the report use an image control and set the controlsource to the name of the field

What kind of field type is most suitable? OLE or Attachment?

 

[theDBguy]

What kind of field type is most suitable? OLE or Attachment?

Hi. Based on CJ's response, I would say a Text field.

 

[Dipo]

OK tnx

 

[theDBguy]

OK tnx

Please don't hesitate to ask follow up questions, if something is not clear.

CJ said: "... have a field to store the path and file name for the logo..."

I am saying that field has to be a Short Text data type field.

 

[Dipo]

Please don't hesitate to ask follow up questions, if something is not clear.

CJ said: "... have a field to store the path and file name for the logo..."

I am saying that field has to be a Short Text data type field.

This will require that subsequent logo upload must be defined as per name and file type. Is it possible to make it less rigid such that you just need to pick and drop new logo and auto update on the report?

 

[CJ_London]

This will require that subsequent logo upload must be defined as per name and file type

which you do in the table per post #2

make it less rigid such that you just need to pick and drop new logo and auto update on the report?

not too sure what this means but if a user can change logo for one report to the next, use a combo box on the table mentioned above

 

[Dipo]

Thanks, you perfectly understood my task.