Solved

Access dll missing?

Posted on 2014-03-13
4
323 Views
Last Modified: 2014-03-31
Private Sub lstR_AfterUpdate()
    Dim objPdf As AcroPDF
    Set objPdf = Me.AcroPDF3.Object
    With objPdf
        RetVal = .LoadFile(DLookup("[FilePath]", "Table", "[ID] = " & Me.lstR.Value))
        .setZoom (76)
    End With
    End Sub

Open in new window


The above code works on 32 bit but crashes on 64 bit (Access Runtime), does anyone know how to fix? (It is supposed to display a pdf)
0
Comment
Question by:HKFuey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 58
ID: 39926918
It's not going to work.  If your using the 64 bit runtime, then it expects all calls to be 64 bit.

There's no real reason to use the 64 bit version of the runtime (and office) and many reasons not to.  This is one of them.

Can you switch to the 32 bit version?  or is it a 64 bit install of Office and you can't switch it (you can't mixed 32 and 64 bit apps within Office - needs to be one or the other).

Jim.
0
 

Author Comment

by:HKFuey
ID: 39926966
Sorry for the confusion I meant is was running on a 64 bit PC with 32 bit Access Runtime.

This is the same setup as our 32 bit PC's which work OK
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39927479
OK, well then the DLL is really missing.   You need to install the acrobat software (or whatever software the DLL came from ) on the machine.

Jim.
0
 

Author Closing Comment

by:HKFuey
ID: 39965983
Thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question