Link to home
Start Free TrialLog in
Avatar of HKFuey
HKFueyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access dll missing?

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)
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

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.
Avatar of HKFuey

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HKFuey

ASKER

Thanks