Shell said:
In Access 2000 is there a way using API calls (or another way) to get:
1. MAC Address
Randy Birch has sample code at
http://vbnet.mvps.org/code/network/macaddressremote.htm
Obligatory warning: Randy's site is aimed at VB programmers. Because there
are some significant differences between the controls available for forms in
VB and in Access, some of his samples will not port directly to Access. For
example, while the following code is how you update the text boxes in VB:
Private Sub Command1_Click()
Dim sRemoteMacAddress As String
If Len(Text1.Text) > 0 Then
If GetRemoteMACAddress(Text1.Text, sRemoteMacAddress, "-") Then
Text2.Text = sRemoteMacAddress
Else
Text2.Text = "(SendARP call failed)"
End If
End If
End Sub
in Access, you can only refer to a control's Text property when it has
focus, so you'd need
Private Sub Command1_Click()
Dim sRemoteMacAddress As String
If Len(Text1) > 0 Then
If GetRemoteMACAddress(Text1, sRemoteMacAddress, "-") Then
Text2 = sRemoteMacAddress
Else
Text2 = "(SendARP call failed)"
End If
End If
End Sub
I showed how to use WMI to get RAM in my December, 2005 "Access Answers"
column in Pinnacle Publication's "Smart Access". You can download the column
(and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html
3. MS Office Versions (ie 2000, xp etc with Pro and or Std)
Don't believe it's possible, since individual Office products can be
mixed-and-maxed. For example, I have multiple versions of Access on all of
my machines. What would you want to report for Office in that case?
