7/23/2019 Pertemuan 4 Lanjutan.doc

1/3

Pertemuan 4 Lanjutan

Coding Form Login (Dengan Tabel Pengguna)

Option Explicit

Public LoginSucceeded As Boolean

Private Sub cmdCancel_Click()

LoginSucceeded = False

Unload Me

menu.nmlogin.Visible = Tue

menu.nmlogin.Visible = False

Me.!ide

End Sub

Private Sub cmdOK_Click()

Adodc".#ecodSouce = $select%&om pengguna '(ee useid=)$ * txtUse+ame * $)$

Adodc".#e&es(

,it( Adodc".#ecodset

.Find -$useid=)$ * Tim-txtUse+ame * $)$

/& .EOF T(en

MsgBox $Use Sala( 0 Sila1an 2oba Lagi3$0 0 $Login$

txtUse+ame.Text = $$

txtUse+ame.SetFocus

Else/& Tim-txtPass'od = Tim-3Pass'od T(en

/& Le&t-txtUse+ame0 4 = $A5M$ T(en

menu.S(o'

menu.nmmaste.Enabled = Tue

menu.nmtansa1si.Enabled = Tue

menu.nmepot.Enabled = Tue

menu.(a1.2aption = .Fields-$a1ses$

FGT fgt-sunrise.blogspot.com

7/23/2019 Pertemuan 4 Lanjutan.doc

2/3

&mtansa1si.1u.Text = .Fields-$useid$

&mtansa1si.nu.Text = .Fields-$nmuse$

LoginSucceeded = Tue

Me.!ide

Else

menu.S(o'

menu.nmmaste.Enabled = False

menu.nmepot.Enabled = False

menu.(a1.2aption = .Fields-$a1ses$

&mtansa1si.1u.Text = -$useid$

&mtansa1si.nu.Text = -$nmuse$

LoginSucceeded = Tue

Me.!ide

End /&

Else

MsgBox $Pass'od Sala(0Sila1an 2oba lagi3$0 0 $Login$

txtPass'od.Text = $$

txtPass'od.SetFocus

End /&

End ,it(

menu.nmlogin.Visible = False

menu.nmlogout.Visible = Tue

menu.nmmaste.Visible = Tue

menu.nmtansa1si.Visible = Tue

menu.nmepot.Visible = Tue

End Sub

FGT fgt-sunrise.blogspot.com

7/23/2019 Pertemuan 4 Lanjutan.doc

3/3

Private Sub Form_Activate()

txtUse+ame.Text = $$

txtPass'od.Text = $$

txtUse+ame.SetFocus

End Sub

FGT fgt-sunrise.blogspot.com