Results 1 to 4 of 4
  1. #1
    retz121 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2012
    Location
    Alberta, Canada
    Posts
    3

    Can't update letterhead in the report using OLE link

    Hi There,

    I have a problem changing our letterhead in our reports using Access 2007.
    Even after "Changing the source" using the OLE link and doing "Update Now", still it didn't changed.
    When opening the source it's pointing to the correct network location.
    Can you please help how I can change it?

    Thanks,


    Retz

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    This is a permanent edit of static image, not a dynamic display of images with records?

    Might be easiest to delete the control and create new one in its place.
    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.

  3. #3
    retz121 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2012
    Location
    Alberta, Canada
    Posts
    3
    Not sure how I can proceed with that. I'm just changing the image on the page header of one of our Reports from the Report Design Tools after clicking the "Design View. " This image is the one I'm getting from the link (using OLE Link), where it points to the network location where the template is stored. Can you please guide me along which control you are referring to that I need to delete and create? Thanks.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    I don't use a lot of images in my db but they are all static.

    There are 3 types of controls possible for this.
    Unbound Object Frame
    Bound Object Frame
    Image

    The first two I have not used.

    I use Image control to display static and dynamic images.

    For static image display I set PictureType property to Embedded. The images are small and few so not causing file size issue. I suppose setting to Linked is advisable if you have opposite situation.

    For dynamic image use the ControlSource property which was introduced to this control with Access 2007. This property can reference an image in an attachment field or external file path string in a text field or can be a path string right in the property.
    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.

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

Similar Threads

  1. Link from one report to another
    By jsimard in forum Reports
    Replies: 2
    Last Post: 02-29-2012, 09:14 AM
  2. Printing Reports on Preprinted Letterhead
    By MuskokaMad in forum Reports
    Replies: 1
    Last Post: 04-01-2011, 05:07 PM
  3. Link a report to a record
    By prv in forum Reports
    Replies: 2
    Last Post: 12-14-2010, 12:45 PM
  4. Replies: 6
    Last Post: 09-30-2010, 11:12 AM
  5. Update query for ID #s to link records
    By fspswen in forum Queries
    Replies: 0
    Last Post: 11-20-2009, 01:52 PM

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