Display username from MS access
Tue, 10/04/2011 - 02:14 — nurvisualbasic
hi , i need your help !!
plz reply my messages .
i m using vb 6.0 .
i want to display the username who have login from the
frmLogin into the frmLocation when i clicking the next or login button .
the username is get from access and when user login the page , the username from access are display in the label on the frmLocation .
plss helpppppp me!!!!
Display username from MS access
***********code for frmLog_In
Private Sub CmdLogIN_click()
global con as new ADODB.Connection
dim rs as new ADODB.Recordset
rs.Open "select * from tbluser where uname='" & txtuname & "' and pw='" & txtpw & "' ",con,2,3
If rs.recordcount=0 then
Msgbox "Invalid User Name and password.",vbExclamation,"Invalid"
Else
With frmLocation
.lblUname.Caption= rs!uname
.lblpw.Caption= rs!pw
Unload Me
.Show 1
End With
End If
rs.Close
End Sub
Post new comment