Results 1 to 7 of 7
  1. #1
    max_the_axe is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2014
    Posts
    5

    PDF to JPG conversion

    I'm hoping someone out there can help me with this one. I have thousands of PDFs of which I want to present a number as thumbnails on a form and allow the users to select any one and have the full PDF displayed.

    The only way in which I can see this working is to have the thumbnail as a JPG image and set the On Click property to display the relevant PDF. This part is quite simple, the problem I have is converting the existing PDFs to JPGs.



    Does anyone know of any way of converting PDFs to JPGs using VBA code? I have scoured the internet with little or no success and any help would be greatly appreciated.

    Thanks

  2. #2
    max_the_axe is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2014
    Posts
    5
    I guess an even better solution to this problem would be a way of displaying PDFs in an Access form. If anyone knows of a way to do this I would be grateful for advice.

  3. #3
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi Max,

    I'm not sure the data type 'Attachment' is already available in Access 2007, but if so: you could try to use this. In a form you can browse through the different attachment in this field and while doing so. The attachment control on a form can show a PDF.

  4. #4
    max_the_axe is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2014
    Posts
    5
    Thanks but I mistakenly put my Access version as 2007, in fact it is 2003 and the data type 'Attachment' is not available. Thanks for getting back to me. It just seems very odd that Access can't seem to cope with PDFs.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Whether or not Adobe would allow it, MS has not coded a control specifically for PDF viewing.

    Access 2010 has a web browser control. This can be used to display PDFs on a form. http://www.vbforums.com/showthread.p...rowser-control

    Bing: VBA convert pdf to jpg
    http://www.myengineeringworld.net/20...iles-into.html
    http://windows.podnova.com/trends/ac...f_to_jpeg.html
    http://answers.microsoft.com/en-us/o...f-0e045b3654ee
    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.

  6. #6
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    For Access 2003, I think there exist some Adobe pdf activeX controls. You could try http://www.glyphandcog.com/XpdfViewer.html

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I've never used ActiveX controls. This appears to be a 3rd party add-in for a price.
    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. MDE TO MDB conversion
    By cooglerj in forum Import/Export Data
    Replies: 2
    Last Post: 05-05-2014, 10:58 AM
  2. Date Conversion
    By mkc80 in forum Access
    Replies: 1
    Last Post: 06-27-2012, 04:04 PM
  3. report conversion
    By nkvs in forum Reports
    Replies: 2
    Last Post: 11-17-2011, 01:04 PM
  4. Number conversion
    By FinChase in forum Access
    Replies: 2
    Last Post: 11-03-2011, 08:16 AM
  5. UM Conversion
    By Rawb in forum Database Design
    Replies: 5
    Last Post: 01-24-2011, 04:02 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