| Author |
 Topic Search  Topic Options
|
IrishNewbie 
Newbie
Joined: 06 November 2003
Status: Offline
Points: 38
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 07 November 2003 at 6:30am |
Marty, the problem with the create account button is that sometimes when its pressed once the record isnt created and i have to click it again for it to be put in.
Do i not need a password field in the DB for when the user returns to log into his account????
|
 |
Diep-Vriezer
Senior Member
Joined: 06 August 2003
Location: Netherlands
Status: Offline
Points: 831
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 November 2003 at 9:00am |
|
You could create a routine (sub) wich will add the data, and afterwards validates that the data is there. If not, it will add it again, and so on.
|
|
Gone..
|
|
IrishNewbie
Newbie
Joined: 06 November 2003
Status: Offline
Points: 38
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 November 2003 at 9:47am |
|
is that for entering the password??? is there a reason that the DB wont accept the password when its basically a string like the rest of the fields??? Its frustrating cos thats the only field it wont enter into the DB.
|
|
Diep-Vriezer
Senior Member
Joined: 06 August 2003
Location: Netherlands
Status: Offline
Points: 831
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 November 2003 at 7:18am |
Wait. That routine is used to be sure the data gets into the database, because you have to push the button twice. Not really efficient, but it works.
|
|
Gone..
|
|
IrishNewbie
Newbie
Joined: 06 November 2003
Status: Offline
Points: 38
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 November 2003 at 9:16am |
Can you think of any reason why i am having trouble inserting the password data only?? its the only field it wont take.
|
|
Diep-Vriezer
Senior Member
Joined: 06 August 2003
Location: Netherlands
Status: Offline
Points: 831
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 November 2003 at 10:45am |
Post you code. It should look like this:
If txtPwd1.Text = txtPwd2.Text Then
'The database routine
Else
'The error msg.
End If
|
By the way, VB.NET has validators, which do this kind of validation BEFORE the data goes into the database. That might be a solution.
|
|
Gone..
|
|
IrishNewbie
Newbie
Joined: 06 November 2003
Status: Offline
Points: 38
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 November 2003 at 11:58am |
|
I think i figured out whats wrong, is Password a reserved word in Access?? I changed the column name from Password to Pword and its working ok now.
|
|
Diep-Vriezer
Senior Member
Joined: 06 August 2003
Location: Netherlands
Status: Offline
Points: 831
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 November 2003 at 12:57pm |
 Yes password is a reserved word.. Just like FROM, WHERE, INSERT, DELETE etc.
|
|
Gone..
|
|
