Last post Jan 03, 2010 03:46 AM by Mikesdotnetting
Jan 02, 2010 07:20 PM|Poovairajaji|LINK
I've three text box collect value from user as textbox1=Firstname, textbox2=Lastname and textbox3=user_id as primary key . i am able to insert into access database but, problem here when user submit i want to check wheater the
user_id exist or not???
Jan 02, 2010 10:38 PM|rezakawser|LINK
in This case at you have operate select query to database using user_id.
if record exist then show erro message.
if not exist then insert new record .
procedure will be like this.
When submit button pressd.
Chcek User_id exist (select * from table name where User_Id = User_id)
show message User Id already exist.
Insert New record to database.
Jan 03, 2010 03:46 AM|Mikesdotnetting|LINK
Don't allow users to create their own PK value. No one does that. Use the Autonumber datatype instead. Then Access will create one that will be unique for each user.