Problem details

[dadazhu]

The first problem I have to fix is that I do not know how to match "username and password" typed in the form with the relate data in the Access table. I used the codes as following,

Open "db1.mdb" For Input As #1 Len = Len(mudtmemberRecord)
Get #1, intNumber, mudtmemberRecord

Also, I am not sure whether I need to define an array like,

Private Type Memberstructure
strUname As String
strPassword As String
End Type
Dim mudtmemberRecord As Memberstructure

Then I can use array to match each other.
I know something must be wrong, can you tell me

[peet]

Originally posted by dadazhu
The first problem I have to fix is that I do not know how to match "username and password" typed in the form with the relate data in the Access table. I used the codes as following,

Open "db1.mdb" For Input As #1 Len = Len(mudtmemberRecord)
Get #1, intNumber, mudtmemberRecord

Also, I am not sure whether I need to define an array like,

Private Type Memberstructure
strUname As String
strPassword As String
End Type
Dim mudtmemberRecord As Memberstructure

Then I can use array to match each other.
I know something must be wrong, can you tell me

I think u should start by going through this excelent tutorial.

http://www.vbworld.com/databases/dbtutorial/

and u don't have to post the questions in more than one Forum at the time