Hi everyone
I have an activex that only works in 32bit. It works perfectly with 32bit Access and Visual basic code compiled as 32bit. However it fails on 64bit access. Is there a way I can run x64 access code as 32bit or x86?
Thanks
Hi everyone
I have an activex that only works in 32bit. It works perfectly with 32bit Access and Visual basic code compiled as 32bit. However it fails on 64bit access. Is there a way I can run x64 access code as 32bit or x86?
Thanks
I have never used ActiveX controls. I do have 32bit API functions. Had to use PtrSafe qualifier, such as:
Private Declare PtrSafe Function GetSystemMenu Lib "user32" (ByVal hwnd As Long, ByVal wRevert As Long) As Long
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.
see this link https://msdn.microsoft.com/en-us/library/gg264421.aspx which explains the differences and what changes you would need to make to your code to work in either environment - the answer is a definite no for compiled code. With regards ActiveX controls, you need to use a 64bit version of the control with 64bit access and 32bit version with 32bit Access.Is there a way I can run x64 access code as 32bit or x86?
Thanks, I am not a pro but this is my scenario. Please spare time to understand it
I am using a brothersoft dll "bpac.dll" as an external reference in access 2013
Following is the code to print from the printer
Private Sub btnPrint_Click()
Dim ObjDoc As bpac.Document 'bpac.document
Set ObjDoc = CreateObject("bpac.Document")
Dim strFilePath As String
'Code to assign label text lies here
ObjDoc.GetObject("objCompany").Text = Me.txtPost.Value
ObjDoc.GetObject("objName").Text = Me.txtName.Value
' ObjDoc.SetMediaById ObjDoc.Printer.GetMediaId(), True
ObjDoc.StartPrint "", bpoDefault
ObjDoc.PrintOut 1, bpoDefault
ObjDoc.EndPrint
ObjDoc.Close
Set ObjDoc = Nothing
End Sub
This code works fine with the 32bit but fails at 64bit( printer does not print and nothing happens). Is there a way to run this code or use declare statement? If so please how
sorry, no idea. QAs previously advised, you'll need to contact brother/brothersoft for a 64bit version of bpac.dll