Results 1 to 2 of 2
  1. #1
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463

    Printing OLE Image Files Stored in SQL


    I have been using an Activex control called Access Imagine to scan in single pages into an Access 2007 database and it works fairly well. I then use this same control in a report to print. My issue is when I scan a document in, it seems to only save it as 2/3 its original size although if I import a jpeg image, that seems to come full size. But then when I try to print any image out using the same Activex control in a report, it only prints the 2/3 size instead of the full 8.5x11. I have tried everything I can think of with the options and properties, tried to stretch the control, etc. and nothing seems to work. I do have a request on their website for help but have not heard back

    So question are has anyone worked with the Access Imagine Activex scanning control and have had similar issues? Or is there another way to print the image instead of using that control. I have tried using a bound or image control from Access but cannot get that to work. Is there any way to Shell out maybe to print a full size copy of the image? Again the images are stored as OLE in a SQL 2016 database, they are not image files saved on a network drive. I tried searching on this site but did not see anything.

    Thanks

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Have you tried to download the files locally --https://usefulgyaan.wordpress.com/20...server-tables/-- (I usually use Application.CurrentProjectPath to get the front-end's folder) and print them from there.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 10
    Last Post: 01-09-2014, 03:00 AM
  2. Where are attached files stored?
    By Delta223 in forum Access
    Replies: 3
    Last Post: 01-11-2011, 10:32 AM
  3. Pass image parameter to stored procedure
    By Kencao in forum Programming
    Replies: 3
    Last Post: 04-28-2010, 11:51 PM
  4. Replies: 6
    Last Post: 04-18-2010, 03:41 AM
  5. Print files stored in an OLE field
    By Brad Harris in forum Programming
    Replies: 1
    Last Post: 12-28-2009, 07:33 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