Hello to everyone
i have a problem with my project.
in one form i have 2 textboxes
in one i have displayed the serial number.
in the second i want display the current user logged on software.
how can i display the current user logged in ?????
the code for the serial number is :
et ac = New ADODB.Connection
Set ar = New ADODB.Recordset
Call DB
ac.Open strConek
With ar
criteria = "Select *From tblFurnizimet"
.Open criteria, strConek, adOpenStatic, adLockOptimistic
If ar.RecordCount = 0 Then
txtNrSerial = 1
Else
.MoveLast
txtNrSerial.Text = Val(!ID) + 1
.Close
End If
End With