Jump to content
Sign in to follow this  
asyiraandriana

Problem Dgn Coding...

Recommended Posts

erm...aku buat sistem guna access tp ada prob biler aku masuk id n password yg btul leh plak kuar msgbox kata salah n aku xleh login page seterusnya..blh tlg tgkkn x apa salah kt code ni....

Option Compare Database

Private Sub Label15_Click()

On Error GoTo Err_Label15_Click

Dim stDocName As String

If (Id_Pengguna = "admin" And Katalaluan = "admin") Or (Id_Pengguna = "rohana" And Katalaluan = "rohana") Or (Id_Pengguna = "rashidah" And Katalaluan = "rashidah") Then

stDocName = "Menu Sistem"

DoCmd.RunMacro stDocName

Else

MsgBox "PASTIKAN ID PENGGUNA DAN KATA LALUAN ANDA BETUL!..", , "PERHATIAN"

MsgBox "SILA CUBA SEKALI LAGI", , "TERIMA KASIH"

Id_Pengguna = "admin" Or "rohana" Or "rashidah"

Katalaluan = "admin" Or "rohana" Or "rashidah"

End If

Exit_Label15_Click:

Exit Sub

Err_Label15_Click:

MsgBox Err.Description

Resume Exit_Label15_Click

End Sub

Share this post


Link to post
Share on other sites

mm..ikut kira..betul dah..

Cume nih dalam Access...

So, maybe ko gune Option Compare Database tuh, dier case-sensitive

Kurang pasti ..apepun, koding tuh,spatutnya ok aje..

Share this post


Link to post
Share on other sites

mm..ikut kira..betul dah..

Cume nih dalam Access...

So, maybe ko gune Option Compare Database tuh, dier case-sensitive

Kurang pasti ..apepun, koding tuh,spatutnya ok aje..

nagakeciks....sy memang dh guna pn Option Compare Databasetu cuma sy x sertakan je time sy send message ni....camner erk...apa problem sebenarnya erk ???

ada sesiapa tau x???

Share this post


Link to post
Share on other sites

nagakeciks....sy memang dh guna pn Option Compare Databasetu cuma sy x sertakan je time sy send message ni....camner erk...apa problem sebenarnya erk ???

ada sesiapa tau x???

x..maksud saye..option compare database tuh replace ngan option compare text

cube dulu..

Share this post


Link to post
Share on other sites

mm...kalo camtu,sori lah..saye dah cube koding awak..tapi dalam vb..ok je, xde masalah ape2..vb n vbscript dalam access, sama je..patut xde masalah..

Share this post


Link to post
Share on other sites

mm...kalo camtu,sori lah..saye dah cube koding awak..tapi dalam vb..ok je, xde masalah ape2..vb n vbscript dalam access, sama je..patut xde masalah..

nagakeciks sy dh berjy selesaikan prob sy tu..senang jer....

mekasih ar tlg bg pendapat kt sy erk....... biggrin.gif

Share this post


Link to post
Share on other sites

nagakeciks sy dh berjy selesaikan prob sy tu..senang jer....

mekasih ar tlg bg pendapat kt sy erk....... biggrin.gif

sama2..tapi bleh x awak nyatakan cara awak selesaikan prob tuh..bleh dijadikan rujukan utk puteranians yg lain dan saye juga..

Thanks

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...