For the second point, I would recommend a message box.
As I stated previously, you create the four fields and then join them in a field of a query
- [a]&"."&[b]&"."&[c]&"."&[d]
and you call this field
IP
In the form where you enter new records (IP) which is based on the Query (with IP field), you add a button which will tell you whether this IP was used or not with this code:
- If (DCount("[IP]", "QueryName", "[IP] =" & "[Forms]![FormName]![IP]")) >= 1 Then
-
MsgBox "This IP exists"
-
ElseIf (DCount("[IP]", "QueryName", "[IP] =" & "[Forms]![FormName]![IP]")) = 0 Then
-
MsgBox "This IP is New"
-
End If
-
This will count the records with the same IP and return the first message if it was used before and second one if it is the first time to be used.
Sure you can attach this msgbox to any other event.
As for the third point, I would stick to my first reply. Note that you can add User's Table for this purpose so that users will enter their names upon opening the database and then you get the same into the IP userID using
DLast
Regards,
Ali