jwcolby
jwcolby at colbyconsulting.com
Tue Jun 12 12:21:28 CDT 2007
Sorry bout that.
John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Tuesday, June 12, 2007 1:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Track PC Number
Actually, the "End Function" wasn't on a separate line.
Here it is again.
------------------
Function lbf_GetFirstHardDriveInfo(strType As String) As Variant
''*******************************************************
'' Procedure Identification
''---------------------------------------------------------
'' Name: lbf_GetFirstHardDriveInfo
''
'' Purpose: Retrieves info on the hard drive
''
'' Options: "FreeSpace", "FileSystem", "SerialNumber"
'' "TotalSize", "VolumeName"
''
'' Notes:
''
''
'' Date/Author: 01/20/03 John Skolits
''***********************************************************
On Error GoTo lbf_GetFirstHardDriveInfo_ERR
'*********BEGIN CODE HERE ********
Dim fs, a, pdrive, pMachineID
Set fs = CreateObject("Scripting.FileSystemObject")
For Each pdrive In fs.Drives
If pdrive.DriveType = 2 Then
Select Case strType
Case "FreeSpace"
lbf_GetFirstHardDriveInfo = _
Format(CDbl((pdrive.FreeSpace)), "#,###,###")
Case "FileSystem"
lbf_GetFirstHardDriveInfo = _
CStr((pdrive.FileSystem))
Case "SerialNumber"
lbf_GetFirstHardDriveInfo = _
CStr(Hex(pdrive.SerialNumber))
Case "TotalSize"
lbf_GetFirstHardDriveInfo = _
CDbl((pdrive.TotalSize))
Case "VolumeName"
lbf_GetFirstHardDriveInfo = _
CStr((pdrive.VolumeName))
End Select
End If
Next
lbf_GetFirstHardDriveInfo_EXIT:
Exit Function
lbf_GetFirstHardDriveInfo_ERR: 'Display the error
Dim strCallingObject As String
strCallingObject = "lbf_GetFirstHardDriveInfo" _
& " " & Application.CurrentObjectName
MsgBox Err, Error, strCallingObject
Resume lbf_GetFirstHardDriveInfo_EXIT
End Function
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com