Access自動刪除引用并自動重新添加引用的函數(shù)-判斷了32位及64位Windows和Office的多種情況
- 2017-07-23 19:46:00
- zstmtony 原創(chuàng)
- 5949
Access自動刪除指定的引用,然后再自動重新添加這個引用的通用代碼-判斷了32位及64位Windows和32位Office及64位Office的多種情況
在編寫Access通用平臺或通用開發(fā)庫時,或使用第三方控件或鏈接庫時,由于這個開發(fā)庫可能經(jīng)常會更新,由于更新后,開發(fā)庫的對象和屬性和方法都有所改變
必須要手工對這個對象重新引用,如果一次兩次還可以手工操作,如果經(jīng)常更新,就需要寫一個通用刪除和添加引用的函數(shù)了
自動重新添加Ocx dll 等控件或鏈接庫的引用(DevlibOcx引用)
Option Compare Database
Option Explicit
Private Const POINTERSIZE As Long = 4
Private Const ZEROPOINTER As Long = 0
Const MAX_LEN = 200 '字符串最大長度
Private Declare Sub apiCopyMemory Lib "kernel32" Alias "RtlMoveMemory" (hpvDest As Any, hpvSource As Any, ByVal cbCopy As Long)
Private Declare Function GetSystemWow64Directory Lib "kernel32" Alias "GetSystemWow64DirectoryA" (ByVal lpBuffer As String, ByVal nSize As Long) As Long
Private Declare Function GetSystemDirectory Lib "kernel32" Alias "GetSystemDirectoryA" (ByVal lpBuffer As String, ByVal nSize As Long) As Long
'Access或Excel VBA或VB6判斷windows系統(tǒng)是32位還是64位
'來判斷系統(tǒng)是32bit還是64bit,主要通過API來實(shí)現(xiàn),先在窗體模塊里申明以下API定義:
Private Declare Function GetProcAddress Lib "kernel32" (ByVal hModule As Long, ByVal lpProcName As String) As Long
Private Declare Function GetModuleHandle Lib "kernel32" Alias "GetModuleHandleA" (ByVal lpModuleName As String) As Long
Private Declare Function GetCurrentProcess Lib "kernel32" () As Long
Private Declare Function IsWow64Process Lib "kernel32" (ByVal hProc As Long, bWow64Process As Boolean) As Long
'然后在窗體或模塊中再建立一個判斷系統(tǒng)是32位還是64位的函數(shù),返回值是布爾值,如果系統(tǒng)是32位,此函數(shù)返回值是Flase 如果是64位,返回值是True,函數(shù)代碼如下:
Public Function Is64bit() As Boolean
Dim handle As Long, bolFunc As Boolean
bolFunc = False
handle = GetProcAddress(GetModuleHandle("kernel32"), "IsWow64Process")
If handle > 0 Then
IsWow64Process GetCurrentProcess(), bolFunc
End If
Is64bit = bolFunc
End Function
'獲取64位 windows及32位windows系統(tǒng) 的系統(tǒng)目錄 ,正常都是System32
Public Function GetSystemDir() As String
Dim sTmp As String * MAX_LEN '存放結(jié)果的固定長度的字符串
Dim nLength As Long '字符串的實(shí)際長度
Dim length As Long
Dim strPath As String
'獲得System目錄
length = GetSystemDirectory(sTmp, MAX_LEN)
strPath = Left(sTmp, length)
GetSystemDir = strPath
End Function
'獲取64位windows系統(tǒng)下32位的系統(tǒng)目錄 ,正常是SysWow64
Public Function GetSystemWow64Dir() As String
Dim sTmp As String * MAX_LEN '存放結(jié)果的固定長度的字符串
Dim nLength As Long '字符串的實(shí)際長度
Dim length As Long
Dim strPath As String
'獲得System目錄
length = GetSystemWow64Directory(sTmp, MAX_LEN)
strPath = Left(sTmp, length)
GetSystemWow64Dir = strPath
End Function
'自動重新添加Ocx dll 等控件或鏈接庫的引用(DevlibOcx引用)
Public Function ReAddDevLibReference()
Dim ref As Reference
Dim strMDE As String
On Error Resume Next
strMDE = CurrentDb.Properties("MDE")
On Error GoTo 0
If strMDE = "" Then
#If Win64 Then
If Dir(GetSystemDir & "\DevLibOcx.dll") = "" Then
MsgBox GetSystemDir & "\DevLibOcx.dll 文件不存在,請檢查文件是否丟失!"
End If
#Else
If Is64bit Then
If Dir(GetSystemWow64Dir & "\DevLibOcx.dll") = "" Then
MsgBox GetSystemWow64Dir & "\DevLibOcx.dll 文件不存在,請檢查文件是否丟失!"
End If
Else
If Dir(GetSystemDir & "\DevLibOcx.dll") = "" Then
MsgBox GetSystemDir & "\DevLibOcx.dll 文件不存在,請檢查文件是否丟失!"
End If
End If
#End If
For Each ref In Application.References
If ref.FullPath Like "*DevLibOcx.dll" Then
Application.References.Remove ref
Exit For
End If
Next
#If Win64 Then ’ 64bit Office or 32bit Office Application.References.AddFromFile GetSystemDir & "\DevLibOcx.dll"
#Else
If Is64bit Then
Application.References.AddFromFile GetSystemWow64Dir & "\DevLibOcx.dll"
Else
Application.References.AddFromFile GetSystemDir & "\DevLibOcx.dll"
End If
#End If
End If
End Function
分享
Access數(shù)據(jù)庫自身
- office課程播放地址及課程明細(xì)
- Excel Word PPT Access VBA等Office技巧學(xué)習(xí)平臺
- 將( .accdb) 文件格式數(shù)據(jù)庫轉(zhuǎn)換為早期版本(.mdb)的文件格式
- 將早期的數(shù)據(jù)庫文件格式(.mdb)轉(zhuǎn)換為 (.accdb) 文件格式
- KB5002984:配置 Jet Red Database Engine 數(shù)據(jù)庫引擎和訪問連接引擎以阻止對遠(yuǎn)程數(shù)據(jù)庫的訪問(remote table)
- Access 365 /Access 2019 數(shù)據(jù)庫中哪些函數(shù)功能和屬性被沙箱模式阻止(如未啟動宏時)
- Access Runtime(運(yùn)行時)最全的下載(2007 2010 2013 2016 2019 Access 365)
Access VBA函數(shù)模塊
Access Activex第三方控件
- Activex控件或Dll 在某些電腦無法正常注冊的解決辦法(regsvr32注冊時卡?。?/a>
- office使用部分控件時提示“您沒有使用該ActiveX控件許可的問題”的解決方法
- RTF文件(富文本格式)的一些解析
- Access樹控件(treeview) 64位Office下出現(xiàn)橫向滾動條不會自動定位的解決辦法
- Access中國樹控件 在win10電腦 節(jié)點(diǎn)行間距太小的解決辦法
- EXCEL 2019 64位版(Office 2019 64位)早就支持64位Treeview 樹控件 ListView列表等64位MSCOMMCTL.OCX控件下載
- VBA或VB6調(diào)用WebService(直接Post方式)并解析返回的XML
Access ADP Sql Server等
- 早期PB程序連接Sqlserver出現(xiàn)錯誤
- MMC 不能打開文件C:/Program Files/Microsoft SQL Server/80/Tools/Binn/SQL Server Enterprise Manager.MSC 可能是由于文件不存在,不是一個MMC控制臺,或者用后來的MMC版
- sql server連接不了的解決辦法
- localhost與127.0.0.1區(qū)別
- Roych的淺談數(shù)據(jù)庫開發(fā)系列(Sql Server)
- sqlserver 自動備份對備份目錄沒有存取權(quán)限的解決辦法
- 安裝Sql server 2005 express 和SQLServer2005 Express版企業(yè)管理器 SQLServer2005_SSMSEE
文章分類
聯(lián)系我們
聯(lián)系人: | 王先生 |
---|---|
Email: | 18449932@qq.com |
QQ: | 18449932 |
微博: | officecn01 |