Results 1 to 9 of 9
  1. #1
    accrep18 is offline Novice
    Windows 10 Access 2007
    Join Date
    Mar 2018
    Posts
    11

    Question different unbound object frame per record

    Hi, I've created a report thru the report wizard, in which I would like to insert an unbound object frame for each record - a different one for each record. These are plots, which are unique to each record.


    Attached is a screenshot where I currently have 2 records. But when I click to add an unbound object frame and go thru the setup dialogs, it creates this for both records. I can't delete or separate the two.

    How to create unique unbound object frames - 1 per record ?

    Thanks,
    apk


    Click image for larger version. 

Name:	screenshot.jpg 
Views:	16 
Size:	69.0 KB 
ID:	33180

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    How to create unique unbound object frames - 1 per record ?
    Sorry, can't be done. To have a different image/whatever the control needs to be bound - otherwise how would access know which object to show?

    I don't know about objects per se but for images stored on a disk for example, you can bind an image control to the path of the image - that path being stored in the record

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Following on from the comments by ajax:

    The screenshot below shows a report with an image control linked to the path of images in a folder
    This is used to show 'thumbnails' of each image
    Click image for larger version. 

Name:	ImageDisplayReport.PNG 
Views:	15 
Size:	293.0 KB 
ID:	33181

    The report is part of the example database in the attached zip file.
    If its any use to you, please feel free to use / adapt it
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    accrep18 is offline Novice
    Windows 10 Access 2007
    Join Date
    Mar 2018
    Posts
    11
    Thank you for the pointers.
    I'm looking to display an image of an Excel chart for each record (and ideally make it so that if the user clicks on it, it will actually open the Excel chart, which is a dedicated worksheet of a larger Excel file).

    Would I use a bounded object frame for this ?
    What would be the best way to achieve this on my Report ?




    Quote Originally Posted by ridders52 View Post
    Following on from the comments by ajax:

    The screenshot below shows a report with an image control linked to the path of images in a folder
    This is used to show 'thumbnails' of each image
    Click image for larger version. 

Name:	ImageDisplayReport.PNG 
Views:	15 
Size:	293.0 KB 
ID:	33181

    The report is part of the example database in the attached zip file.
    If its any use to you, please feel free to use / adapt it

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    If you examine the way my app report is designed, you have all the info you need to do this.
    You will just need to save an image of each chart in the same folder. It will work best if all images are similar in size.

    As I don't normally make my reports interactive, I'm not sure whether you will be able to click on an image to open the Excel file
    It might be better to do this on a form instead.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Image control does have Click event. Use FollowHyperlink in code to open file. However, report would have to be in ReportView, not PrintPreview.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by June7 View Post
    Image control does have Click event. Use FollowHyperlink in code to open file. However, report would have to be in ReportView, not PrintPreview.
    True but that's not why I was questioning whether it was possible
    This is the report design - just one image control which is repeated for each image in the folder in print preview

    Click image for larger version. 

Name:	ReportDesign.PNG 
Views:	10 
Size:	9.6 KB 
ID:	33199

    In Report view, the image thumbnails won't display & I'm doubtful about using code to open the file.
    It wasn't designed for that purpose
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    My images display in ReportView. They actually look better than PrintPreview. However, FollowHyperlink code is defaulting to browser to open jpg.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Very strange ....
    This is what I get if I open the report in Report view for both PNG & GIF files

    Click image for larger version. 

Name:	ReportView.PNG 
Views:	9 
Size:	9.8 KB 
ID:	33201

    However if I click where the image should be, it opens fine in the default app using code:

    Code:
    Application.FollowHyperlink Me.ImagePath
    NOTE:
    If I instead open in Print Preview, right click and change to Report View, I get an identical 'random' image for each thumbnail
    Swop to Print Preview & back to Report View - different identical image for each thumbnail

    I don't use JPG files with Access because the image quality is very poor due to their lossy format
    However just tried and I get the same result as above

    I'll stick to using this the way it was originally designed - print preview!
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Unbound Object Frame Shrinks Data When Edited
    By Squirrel1804 in forum Access
    Replies: 6
    Last Post: 11-05-2015, 05:53 PM
  2. Unbound Object Frame Not Updating
    By MrSpadMan in forum Reports
    Replies: 7
    Last Post: 02-06-2013, 06:30 PM
  3. Unbound Object Frame
    By wsm_al in forum Access
    Replies: 1
    Last Post: 12-02-2011, 05:40 PM
  4. Replies: 8
    Last Post: 05-26-2011, 07:44 AM
  5. Replies: 1
    Last Post: 08-05-2010, 12:11 PM

Tags for this Thread

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