Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    22

    Cool Unanswered: Printing multiple forms with linked images...How can I make the images work?

    I have a form with multiple linked images. In design view, the image frames have "none" specified for their image link. I've simply used VBA to replace that field with the specific record's image link which is stored as a text field in its table.

    What I want to do is be able to print out multiple records at the same time. What ends up happening is whatever record is open has the image frames linked to its specific images, therefore all records have that same exact image after printing.

    Any ideas? Can I somehow force an image frame to link to a specific text field from its record without VBA?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Don't print forms. Design a report to do it.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2008
    Posts
    22
    All of the images are stored as a file path in a text field in a table. Will I be able to print a report displaying unique linked images from each record?

    If so, with VBA or without? If with VBA, will I encounter the same problem that I have currently with VBA linked images / forms?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Will I be able to print a report displaying unique linked images from each record?
    I can't see why not... although I have never done this.

    If so, with VBA or without?
    With. Something has to set the image control to the path to the file... for each record.

    If with VBA, will I encounter the same problem that I have currently with VBA linked images / forms?
    No, because the report can run the code to set the image up once for each record (ie in the On Format event for the Detail section).
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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