Results 1 to 3 of 3
  1. #1
    lumoco is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    3

    Image display in reports from external file

    I have been doing a promotion catologue in Excel for years but I am now looking to move it to Access. My reason for doing so is been able to add pictures and filter it better for the different types of customers I have, e.g my hardware customers dont care about drinks and vice versa.



    I am new to access but i have been going through this site and google to try to do this for me to no success.

    I have attached a reduced version of my database and report.
    What I want is a picture and the details besde it and the promotion in a grid format not a line format. I need to try andget this done by the weekend.

    I would really appreciate any help that you could give me, as there seem to be alot of people out there having the same sort of problem with pictures and reports.

    Thanks in advance.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Attach this code to the onFormat Even of the Details Section of your Report. I think it will give you the result. You will be able to see the effect in the Print Preview option of the report. Try it out......


    Dim strPath As String
    strPath = Me.ImagePath & "\" & Me.ImageName
    Me.Image.Picture = strPath
    MsgBox strPath
    End Sub

  3. #3
    lumoco is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    3
    maximus, thanks for your help, I kept getting errors with "me" in the vb script.

    After playing with it and not getting anywhere I put the 2 columns together which gave me the full path of the image and in the data control source i let it equal the new column of data and it is displaying correctly.

    Again thanks but ill come back and see if i can use your way once i get time to debug it properly

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to select from MDB file through external tools
    By ryanlcs in forum Programming
    Replies: 1
    Last Post: 08-10-2011, 11:31 AM
  2. Exporting Attachments to an external file
    By springa in forum Import/Export Data
    Replies: 3
    Last Post: 07-17-2011, 05:33 AM
  3. Replies: 0
    Last Post: 12-03-2010, 02:17 PM
  4. Replies: 1
    Last Post: 09-27-2010, 10:10 AM
  5. Browse to external file while in a form
    By michaeljohnh in forum Import/Export Data
    Replies: 9
    Last Post: 09-22-2010, 09:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums