Results 1 to 11 of 11
  1. #1
    tcp_doakley is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    6

    View snapshot of file in access form


    I have an access db (office 365) that's basically a list of excel files with attributes associated. I need to be able to see a snapshot of the file for each record. I've tried saving as a pdf -- but then office tells me the ole server isn't registered so pdf viewer activex control doesn't work. Tried using oleobject type in record, but can't get it to populate programmatically so it shows me the file. Tried using the attachment type, but that only shows the excel icon and doesn't show the file. Any help is greatly appreciated.

  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
    See if this older file of mine will help you (will do Excel and PDF, not just Word).

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

  3. #3
    tcp_doakley is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    6
    I'm such a newb, IDK how to get past this:

  4. #4
    tcp_doakley is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    6
    "the code in this project must be updated ..." My system is 64-bit. I tried doing suggestions with PtrSafe from other sites, but couldn't get it to work

  5. #5
    tcp_doakley is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    6
    Gicu, you are AWESOME!!! Thank you!

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    You could try the Shell command ?
    Code:
    shell "excel /ro " & PathToYourFile
    If the path has spaces, you will need to play around with the syntax I'm afraid
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hey looks like you managed to go past the 64 bit errors, those come from some of the older 32 bit modules, but probably not needed for your current requirement.

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

  8. #8
    tcp_doakley is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    6
    Please forgive me. I'm brand new here. Is there somewhere I should mark this as solved?

  9. #9
    tcp_doakley is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    6
    Y'all are great. I got it working. Thanks!

  10. #10
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101

    Look at the top of the forum page for instructions on how to mark the thread as solved.

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

  11. #11
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by tcp_doakley View Post
    Please forgive me. I'm brand new here. Is there somewhere I should mark this as solved?
    Thread Tools, at the top right of the page in the topmost green bar below the subject.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 1
    Last Post: 02-27-2020, 04:49 PM
  2. Need to upload Access file and view online
    By rameshmeena in forum Access
    Replies: 4
    Last Post: 03-17-2019, 10:28 AM
  3. Replies: 5
    Last Post: 05-05-2015, 11:22 PM
  4. Active/Live view of a PDF file in a form
    By linuxson in forum Access
    Replies: 1
    Last Post: 08-18-2014, 09:54 AM
  5. Replies: 1
    Last Post: 04-07-2010, 08:49 AM

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