Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #31.8K
when i run my code...this error come out [QUOTE]"data type mismatch in criteria expression"[/QUOTE] here my code: [CODE]Private Sub Text2_Change() TXT1 = "" TXT1 = "SELECT * FROM Profile WHERE sID =' " & Text2 & "'" If RS.State = 1 Then RS.Close End If RS.Open TXT1, Conn, adOpenKeyset, adLockOptimistic … |