Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23

Has anyone worked with hypelinks vs actual images as Attachments in Access dB to create PDFs?

  1. #16
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    44,968
    If images are not in Attachment field they are not in a separate table, they are in a folder. Only the image path\name is stored in a text field.

    The images are retrieved from folder by using an Image control on form or report. Image control has image path in ControlSource. As already described in previous posts.

    What is the '3rd way'?
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  2. #17
    zkrucz is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    36
    I think we are talking about the same thing ("3rd way"). I am referring to the 3rd option described in the link https://www.cimaware.com/expert-zone...crosoft-access.
    So, I think I finally get it. Instead of a Query in which I can refer/clock on an Attachment field, I will need to create forms to make my review using the method described herein, correct?




    Handling Images with Microsoft Access


    By Jamie CzernikArticles about Microsoft Access
    What is the best way to store image files in MS Access?"
    This has to be one of the most frequently asked questions in relation to Access. In actual fact, there are three main techniques available to handle image files in tables with MS Access and these are:

    1. 1. Store the image in an OLE field and use a bound object frame to display the image.
    2. 2. Store the path to the image in a text field, using an image control to display the image.
    3. 3. Store the image as a binary large object bitmap (BLOB) in an OLE field, extract the image when required and use an image control to display the image.


  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    44,968
    Yes, form or report. Even if you used Attachment field, could build form or report with Image control bound to Attachment field, not interact with query. Whether Attachment or text field, the images must be a type that Access can display with that control - no PDFs.

    That list doesn't mention saving images in Attachment field and using Image control to display or opening in another program as you were doing with query. So I guess there are 4 ways - or is that 5? Seems Jamie was avoiding Attachment field in his list of 'main' techniques.

    I've never used OLE fields and controls. All attempts always resulted in frustration.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  4. #19
    zkrucz is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    36
    Great, thank you and now I can discuss with our programmer to move this project forward.

  5. #20
    Gicu is offline Expert
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    513
    Using the OLE object method will also bloat your db ( I did use it successfully but with SQL server and Oracle back ends). Use a form to display the picture for your validation and from there open the report (or export it straight to PDF)
    Cheers,
    Vlad

  6. #21
    zkrucz is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    36
    OK, but to be sure, I review say a hundred records at at a shot (daily). What I like about the query approach is that i can easily move from record to record and make corrections in the DB, if needed. Is it safe to assume that I can do the same using a dedicated form? Once I complete that task, I produce weekly PDFs which include hundreds (say 500) individual records under one PDF label. Will I be able to create something similar using you approach?

  7. #22
    Gicu is offline Expert
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    513
    Yes, you should have a continuous form to review and the report would be similar to the one you already have.
    Vlad

  8. #23
    zkrucz is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    36
    OK, now I can truly say that this is closed and you have put my mind at ease. Thank you.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-13-2018, 11:16 AM
  2. Replies: 1
    Last Post: 07-09-2017, 10:14 PM
  3. Replies: 1
    Last Post: 06-19-2013, 06:41 AM
  4. Replies: 1
    Last Post: 12-17-2012, 07:29 PM
  5. Create PDFs from a report
    By twosides in forum Programming
    Replies: 42
    Last Post: 03-04-2010, 05:48 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
  •  
Tech Forums: Microsoft Office Forums