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!

Pictures in reports? 1

Status
Not open for further replies.

boiker

Technical User
Oct 19, 2001
17
0
0
US
Each record in my database has the path of the photo listed in a column. how can i use that path so that an image will print out for every record based on each records unique image path.

 
I have a very similar question. I have a Part Number database and in a specific subdirectory, there is a JPG file of each part. The file name is identical to the part number with a .jpg extension of course. How can I get MS Access to view the JPG upon calling up the Part Number? Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine
 
Insert a Image control in your Report(ex: Name Image7)
In a Detail On Format insert:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim x As String
x = "Z:\FotoPers\M" & Trim([NameField]) & ".bmp"
Me!Image7.Picture = x
End Sub

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top