日韩天天综合网_野战两个奶头被亲到高潮_亚洲日韩欧美精品综合_av女人天堂污污污_视频一区**字幕无弹窗_国产亚洲欧美小视频_国内性爱精品在线免费视频_国产一级电影在线播放_日韩欧美内地福利_亚洲一二三不卡片区

取得磁碟機之Volumn及Serial Number_Access數(shù)據(jù)庫教程

編輯Tag賺U幣
教程Tag:暫無Tag,歡迎添加,賺取U幣!

推薦:巧用Access逐條輸出Excel中的記錄
Excel 2000并不支持單條記錄的輸出,如果想把Excel 2000里的通訊錄一條一條打出來,倒也成問題。來來來,且看我是如何讓它乖乖就范的! 比起Excel 2000 來說,Access才能算是個數(shù)據(jù)庫,畢竟E

適用ACCESS97、2000

這兩項磁碟機資料須使用API函數(shù)方可取得,代碼如下:

以下為引用的內(nèi)容:

Private Declare Function GetVolumeInformation Lib "kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String, ByVal lpVolumeNameBuffer As String, ByVal nVolumeNameSize As Long, lpVolumeSerialNumber As Long, lpMaximumComponentLength As Long, lpFileSystemFlags As Long, ByVal lpFileSystemNameBuffer As String, ByVal nFileSystemNameSize As Long) As Long

Function GetVolumn(X As String) As String
If Len(X) < 3 Then
X = Left(X, 1) & ":\"
Else
X = Left(X, 3)
End If
Dim nRet As Long, VolName As String, VolSN As Long, MaxCompLen As Long
Dim VolFlags As Long, VolFileSys As String
VolName = Space$(256)
VolFileSys = Space$(256)
nRet = GetVolumeInformation(X, VolName, Len(VolName), _
VolSN, MaxCompLen, VolFlags, _
VolFileSys, Len(VolFileSys))
If nRet = 1 Then
GetVolumn = VolName
Else
GetVolumn = ""
End If
End Function

Function GetNumber(X As String) As String
If Len(X) < 3 Then
X = Left(X, 1) & ":\"
Else
X = Left(X, 3)
End If
Dim nRet As Long, VolName As String, VolSN As Long, MaxCompLen As Long
Dim VolFlags As Long, VolFileSys As String
VolName = Space$(256)
VolFileSys = Space$(256)
nRet = GetVolumeInformation(X, VolName, Len(VolName), _
VolSN, MaxCompLen, VolFlags, _
VolFileSys, Len(VolFileSys))
If nRet = 1 Then
GetNumber = VolSN
Else
GetVolumn = ""
End If
End Function

前面的Declare陳述式宣告一個API函數(shù)(GetVolumeInformation),可取得磁碟機的兩項資料。

分享:Access應用:仔細地選擇索引
仔細地選擇索引 Access根據(jù)數(shù)據(jù)類型,使用了一個索引來依照合理的順序分類數(shù)據(jù)。正確的索引能夠提高其性能,而錯誤的索引則會降低效率。到目前為止,最常見的錯誤就是設(shè)置過多的索引。因為Acc

來源:模板無憂//所屬分類:Access數(shù)據(jù)庫教程/更新時間:2008-08-22
相關(guān)Access數(shù)據(jù)庫教程