Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Include picture with variable path into a report

Status
Not open for further replies.

wsuess

Programmer
Aug 13, 2002
9
0
0
DE
hi,
my problem ist, that i want to include a Jpeg into a report, but the path of Jpeg has to be variable, because the report is an Invitation with a picture of the location.

May I use an OLE-object or not? what a kind of rules i have to obey if i want to use object like this?

 
Hi

I have done this with an Image control and code like this:

Set Db = CurrentDb()
Set Rs = Db.OpenRecordset("SELECT strHeaderLogo, strQualityLogo FROM tblSystemSettings;")
If Rs.RecordCount > 0 Then
imgQualityLogo.Picture = Rs!strQualityLogo
imgHeaderLogo.Picture = Rs!strHeaderLogo
Else

in the on open event of the report

Regards

Ken Reay
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top