Results 1 to 6 of 6

Thread: Help requird

  1. #1
    Join Date
    May 2003
    Posts
    7

    Unanswered: Help requird

    I have a field in the table which store the path of an image file. I want the access report to show the picture whose path only is stored in a table. how do i do this???

  2. #2
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Re: Help requird

    Originally posted by bdheepa
    I have a field in the table which store the path of an image file. I want the access report to show the picture whose path only is stored in a table. how do i do this???
    i've found 1 way of doing this but it only allows 1 picture per page (though sitting up columns might help with this), and the picture is displayed as the report background, put this code behind the report

    add the following code to the report
    Private Sub Report_Activate()
    Me.Picture = <field with the filename in it>
    End Sub

    Private Sub Report_Page()
    Me.Picture = <field with the filename in it>
    End Sub


    then make sure the detail forces new page before it's self
    Last edited by m.timoney; 05-09-03 at 13:35.
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  3. #3
    Join Date
    May 2003
    Posts
    7
    This is a report to print the identity cards of the employees (like labels), so i need to print the photo of corresponding to every record. how can i do this???

  4. #4
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    the only way i've found to do that witha report is to inclued the images as ole objects in the table but i'll see if i can find another method
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  5. #5
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    no unless some else has any ideas i'm afraid i can't help, i've tried every thing i can think of even down to mail merging into word
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  6. #6
    Join Date
    May 2003
    Posts
    7
    Thanx a lot for ur efforts, if i use forms instead of reports, is there any way i can print the 10 records in a sheet as labels(i mean like identity card).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •