Darn I wish it were true that I know what to do... I've managed to stick some things I found on the net together...but I just do not know how to get the computer and Windows Users IDs from their respective tables without a where clause or lookup or something this noob doesn't know exists...
So, are you saying I can do this with a recordset ?
Something like this:
Public Function ComputerUpdate()
Dim sComputername As String
Dim db As DAO.Database
Dim r As DAO.Recordset
Set db = CurrentDb
Set r = db.OpenRecordset("t_Computers", dbOpenDynaset)
r.FindFirst "Computer_Name='" & ComputerName() & "'"
If r.NoMatch Then
r.AddNew
r!Computer_Name = ComputerName()
r.Update
End If
'Is this where I would add something a DLookup to find the table _ID that matches the computer name currently in use and create a tempvars so I can insert them in t_User_Logs???
r.Close
End Function
I have been at this all weekend and I am pretty well done... if you can help/guide me I would really, really appreciate it as I have had no success doing what I want to do...
Thanks,
Bill