Access...tolong Aku

[ask4help 0]

aku tengah wat sistem utk unit aku..sistem simple jek.. dan aku gunakan microsoft access..aku cadang nak wat sistem nih nampak best sket..so bagi sesapa yg ada tips berguna utk access tuh rakin2laa kongsi..

1st yg aku nak tanya, camna nak wat login dan password utk user...kat mana nak carik function nih...hanya org tertentu je yg leh masuk dlm access kita..

kalo ada soklan lagi aku posting kat sini je...

[DevGuy 0]

anyway kalau nakbuat login kena lae ada database. and database mesti la normalization,have relationship.

anyway banyak contoh lat internet. u can get from book to and www.planet-source-code.com..

oklahh good luck.

[ask4help 0]

ooo..thank's..cara lain yg senang sket nak wat login ngan password sebelum masuk database kita tuh camna?

aku ada nengok satu sistem member aku wat, sebelum leh masuk database tuh kene masuk login name dan password..yg tuh aku tanya camna nakwat?

[zulkifly_said 0]

nak tanya dulu, nak buat access saja ke atau access sbg back end dan interface dgn vb ke, jbuilder ke etc.

...emmmm

[ask4help 0]

sumanya dlm access...table form report suma kat access...tak melibatkan vb atau yg lelain langsung...

[badai_707 0]

ko create form login, buat Textbox Text1 and Text2,buat button "OK", klik kiri and masukan coding

Private Sub CommandOK_Click()

On Error GoTo Err_CommandOK_Click

Dim stDocName As String

Dim stLinkCriteria As String

Dim papar As String

stDocName = "FormMenu"

If Text1 = "Username" And Text4 = "password" Then

DoCmd.Close

DoCmd.OpenForm stDocName, , , stLinkCriteria

Else

papar = MsgBox("Silap", vbInformation)

End If

Exit_Command0_Click:

Exit Sub

Err_Command0_Click:

MsgBox Err.Description

Resume Exit_Command0_Click

End Sub