转二进制函数-赖观配
Access软件网QQ交流学习群(群号码198465573),欢迎您的加入!
首页 >技术文章> Access数据库-模块/函数/VBA


转二进制函数

发表时间:2007/10/18 21:52:52 评论(0) 浏览(5649)  评论 | 加入收藏 | 复制
   
摘 要:转二进制函数
正 文:
转自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群(群号:198465573)
 
 相关文章
字符串与二进制数组(二进制流)如何互相转换?  【UMVsoft整理  2007/5/12】
图片以二进制保存至表及提示显示例子  【咱家是猫  2008/1/7】
二进制合并与拆分图片实例演示(源码)  【江羽  2010/5/3】
Form2.Image 控件显示ADO 读取的二进制图片  【--  2010/8/12】
【Access示例】十进制数与二进制数的互相转换  【缪炜  2013/3/15】
漫说以Stream对象的二进制存储较大文件  【殷小宝  2013/12/29】
常见问答
技术分类
相关资源
文章搜索
关于作者

赖观配

文章分类

文章存档

友情链接