Solved

Access 97 report, how to insert a image based on a field name...

Posted on 2006-07-12
9
178 Views
Last Modified: 2010-07-27
I have a field called REFRENCE

so in a report I would like to create a frame, but dont know which kind ole object ??? then then in the properties of that frame i would like it to load as follows

="D:\PICTURES\[REFRENCE]PIC.JPG"

so if refrence is baby

then the path to the pic file would be

d:\pictures\babypic.jpg

and the picture should load..

also in a report is it possible to have a page header, detail, and page footer on the right side of a pictrure i.e. the picture is to the left of some text..

tks.
0
Comment
Question by:Ricky11
  • 5
  • 4
9 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17088707
U could use the IMAGE control

then in code u do ctrlname.Picture  = "D:\PICTURES\[REFRENCE]PIC.JPG"
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17088737
Do u want to set the path dynamically or in design?

0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17088871
sorry my mistake, almost there

create a image control on your report - it may ask u to select one. Dont worry, just select one then clear the image in report design - look in property Picture

Now in code, u can do this - where ctrlname is the name of your image control

    ctrlname.Properties("Picture") = "D:\PICTURES\" & Me.Reference & "PIC.jpg"

Assuming Reference is a field on your report

If not, change Me.Reference to whatever u want it to be


Regards to your 2nd question, yes, u can position your image control and insert your text accordingly, how u see fit
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:Ricky11
ID: 17106869
i am using acc 97

i inserted a picture then removed the pic from properties change the name of the picture frame to PICTURE, then in the on open event on the report i put your code

firstly i get ctrlname not defined???

then i changed it to this.

PICTURE = "D:\PICTURES\" & Me.Reference & "PIC.jpg"

then it cannot find me.reference when surely the same reference is used in the report query and is also being displayed elsewhere in the report.

then i did this

instead of pulling the reference from the query inside the report i did :
pic = [Forms]![products2].[Text54]
PICTURE = "D:\PICTURES\" & pic & "PIC.jpg"

this works,, but the picture firstly displayed in the center of the report and not even inside the image frame at all.

i tried it again and then it said i am unable to assign a property or image to the picture frame for some reasons..

0
 

Author Comment

by:Ricky11
ID: 17106887
wooops..

okay silly me i forgot ctrlname is the name of the frame!! okay it does work now but it still cannot find me.reference...

so i have changed it to & pic & which pulls the data from another open form

 
0
 

Author Comment

by:Ricky11
ID: 17106932
re image control i cannot position it so that the page header and detail are on the right side of the image contorl, they always appear underneath it.

tks.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17107516
sorry

me.reference

supposed to refer to your refid field, the one holding the value u want

0
 

Author Comment

by:Ricky11
ID: 17231997
wanted to follow up with you... i asked a simialr question you will see.

but i put the code in the on page event in a report. however when i print the report it prints the wrong image on each page for each record..

how do i put it in a on current, their is no on current on the report??? in acc 97

tks
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 17239420
I think

Private Sub Report_Page()

is what u might be after
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question