本人明天急需一个vb程序,主要功能是在局域网里的每台机器运行,将机器名,ip保存到另一台机器上的一个access上,本人已经写好了函数,在做连接access,但是能力有限,特来求助,主要代码如下:
Option Explicit
Private Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As LongPrivate Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
'Return the user's name.
Private Function UserName() As String
Const UNLEN = 256 ' Max user name length.
Dim user_name As String
Dim name_len As Long user_name = Space$(UNLEN + 1)
name_len = Len(user_name)
If GetUserName(user_name, name_len) = 0 Then
UserName = "<unknown>"
Else
UserName = Left$(user_name, name_len - 1)
End If
End Function
'Return the machinename.
Private Function MachineName() As String
Dim sBuffer As String * 255
If GetComputerName(sBuffer, 255&) <> 0 Then
MachineName = Left(sBuffer, InStr(sBuffer, vbNullChar) - 1)
Else
MachineName = "(未知)"
End If
End Function
Private Sub Main()
Dim db As Database
Dim rs As Recordset
Dim WS, bt, bt1, bt2, bt3, IPAddress
Set WS = CreateObject("MSWinsock.Winsock")
Set db = OpenDatabase(App.Path + "/ppl.mdb")
Set rs = db.OpenRecordset("ppl")
IPAddress = WS.LocalIP
bt = Time
bt1 = Date
bt2 = UserName()
bt3 = MachineName需将ipaddress,bt等保存到access的数据库上,大家帮帮忙了。有分的
Option Explicit
Private Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As LongPrivate Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
'Return the user's name.
Private Function UserName() As String
Const UNLEN = 256 ' Max user name length.
Dim user_name As String
Dim name_len As Long user_name = Space$(UNLEN + 1)
name_len = Len(user_name)
If GetUserName(user_name, name_len) = 0 Then
UserName = "<unknown>"
Else
UserName = Left$(user_name, name_len - 1)
End If
End Function
'Return the machinename.
Private Function MachineName() As String
Dim sBuffer As String * 255
If GetComputerName(sBuffer, 255&) <> 0 Then
MachineName = Left(sBuffer, InStr(sBuffer, vbNullChar) - 1)
Else
MachineName = "(未知)"
End If
End Function
Private Sub Main()
Dim db As Database
Dim rs As Recordset
Dim WS, bt, bt1, bt2, bt3, IPAddress
Set WS = CreateObject("MSWinsock.Winsock")
Set db = OpenDatabase(App.Path + "/ppl.mdb")
Set rs = db.OpenRecordset("ppl")
IPAddress = WS.LocalIP
bt = Time
bt1 = Date
bt2 = UserName()
bt3 = MachineName需将ipaddress,bt等保存到access的数据库上,大家帮帮忙了。有分的
解决方案 »
- 请教啊
- 跪求经验。。。通用中介软件问题,有经验的大虾来
- 急需Visual Basic“学习版”的安装程序
- 请教:msflexgrid如何实现单行选取(即拖动鼠标仍然只选一行),在线等.
- 如何实现VB重多条件判定,谢谢!
- 一个工程中不同窗口的参数调用问题
- 哪儿有VB6.0开发人员指南 书的光盘下载
- 求助,VB6如何把文本文件由默认的ANSI编码格式存为UTF-8编码格式
- 条码机
- 请教VB中ADO中有否DAO的DbEngine.Compactdatabase 最适化的功能,如何实现?谢谢
- 将word中的内容(含有公式)逐行读入另一个文件中
- 如何VB的程序中实现得到其他程序的某一列表框(list box) 中的数据?
rs("BT")=bt '赋值
rs("BT1")=bt1 '赋值
rs("BT2")=bt2 '赋值
rs("BT3")=bt3 '赋值
rs.update '写数据库
由于不知道你的数据库中相应的字段名称,所以我就用大写的来表示,楼主可以自己改
rs("IP")=ipaddress
这样的程序可以使用winsock控件来代替Set WS = CreateObject("MSWinsock.Winsock")
这样access容易损坏那么可以考虑三层结构