Results 1 to 2 of 2
  1. #1
    NISMOJim is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    273

    User selects pictures for report

    I am trying to insert pictures into a report based on which ones the user selects.

    When the options form is opened, the correct file is also opened showing the pictures that the user has to choose from. The form has several toggle buttons (1-20) that they will switch on to select which 4 pictures they want to appear on the report. Here is where my problem starts.



    In the "On Open" property of the report, I put in the following code, hoping that the image frame would know how to handle it;

    Private Sub Report_Open(Cancel As Integer)
    If Forms!IncPopup!Tog1 = -1 Then
    Me.Pic1 = "T:\PG Operations\Accident, Incident, Injury Reporting\Accident Folders\01.jpg"
    End If

    End Sub

    If this worked, I would have gone on to add IF statements for the other toggle buttons & jpg's.

    I tried this with images, bound object frames & unbound object frames to the report, but can't get any of them to work the way I want. If I use an Image, I get the following error;
    Run Time Error '438': Object doesn't support this property or method
    If I use a bound object frame, I get this error;
    Run Time Error '2147352567 (80020009)' You can't assign a value to this object.

    I'm not good with coding (obviously), and often wonder how I got this far in Access. Can anyone set this derailed train onto the right track to making this work?
    Last edited by NISMOJim; 10-28-2010 at 10:25 PM.

  2. #2
    NISMOJim is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    273
    Nevermind, I got it figured out. More questions to follow, I'm sure.

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

Similar Threads

  1. User Supplied Value at Report Run
    By Kimbertha in forum Reports
    Replies: 8
    Last Post: 10-07-2010, 11:29 AM
  2. printing imported pictures in a report
    By Jsrogol in forum Reports
    Replies: 1
    Last Post: 08-19-2010, 04:34 PM
  3. Replies: 3
    Last Post: 04-07-2010, 11:25 AM
  4. Repositioning pictures in the report
    By SimonJ in forum Reports
    Replies: 0
    Last Post: 09-28-2006, 03:51 PM
  5. Loading pictures from URL in a report
    By drborracho in forum Programming
    Replies: 5
    Last Post: 12-13-2005, 09:22 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