Access开发培训
网站公告
·Access专家课堂QQ群号:151711184    ·Access快速开发平台下载地址及教程    ·欢迎加入Access专家课堂微信群!    ·如何快速搜索本站文章|示例|资料    
您的位置: 首页 > 技术文章 > Access数据库-模块/函数/VBA

转二进制函数

时 间:2007-10-18 21:52:52
作 者:gnoy   ID:42  城市:广州
摘 要:转二进制函数
正 文:

转自OFFICE中国 gnoy

'Adapt By:Gnoy

'-------------------------------------------------------------------------

Private Declare Sub CopyMemory _
Lib "kernel32" Alias "RtlMoveMemory" _
(Destination As Any, Source As Any, ByVal length As Long)

Public Function ByteArrayAsBin(ByVal b As Variant) As String
Dim z As Long
Dim u As Long
u = UBound(b)
For z = 0 To u
ByteArrayAsBin = ByteArrayAsBin & ByteAsBin(b(z))
If z <> u Then
If (z + 1) Mod 4 = 0 Then
ByteArrayAsBin = ByteArrayAsBin & vbNewLine
Else
ByteArrayAsBin = ByteArrayAsBin & " "
End If
End If
Next z
End Function

Public Function ByteAsBin(ByVal b As Byte) As String
Dim z As Long
For z = 7 To 0 Step -1
ByteAsBin = ByteAsBin & Abs(CLng(CBool(b And (2 ^ z))))
Next z
End Function

Public Function CurrencyAsBin(ByVal c As Currency) As String
Dim b(7) As Byte
CopyMemory b(0), c, 8
CurrencyAsBin = ByteArrayAsBin(b)
End Function

Public Function DateAsBin(ByVal d As Date) As String
Dim b(7) As Byte
CopyMemory b(0), d, 8
DateAsBin = ByteArrayAsBin(b)
End Function

Public Function DoubleAsBin(ByVal d As Double) As String
Dim b(7) As Byte
CopyMemory b(0), d, 8
DoubleAsBin = ByteArrayAsBin(b)
End Function

Public Function IntegerAsBin(ByVal i As Integer) As String
Dim b(1) As Byte
CopyMemory b(0), i, 2
IntegerAsBin = ByteArrayAsBin(b)
End Function

Public Function LongAsBin(ByVal l As Long) As String
Dim b(3) As Byte
CopyMemory b(0), l, 4
LongAsBin = ByteArrayAsBin(b)
End Function

Public Function SingleAsBin(ByVal s As Single) As String
Dim b(3) As Byte
CopyMemory b(0), s, 4
SingleAsBin = ByteArrayAsBin(b)
End Function

Public Function StringAsBin(ByVal s As String) As String
Dim b() As Byte
Dim z As Long
Dim u As Long
b = StrConv(s, vbFromUnicode)
StringAsBin = ByteArrayAsBin(b)
End Function

Access软件网QQ交流群 (群号:54525238)       Access源码网店

常见问答:

技术分类:

相关资源:

专栏作家

关于我们 | 服务条款 | 在线投稿 | 友情链接 | 网站统计 | 网站帮助