User Profile

Collapse

Profile Sidebar

Collapse
prafulla1978
prafulla1978
Last Activity: Nov 26 '14, 08:35 AM
Joined: Nov 23 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • prafulla1978
    replied to avoid duplicate entry in vb6
    in Access
    i have deloped the above code :
    Code:
    dim name as string
dim str as string
dim rs as recordset
dim rs as new adodb.recordset
str="Select name from table1 where name='" & txtname.text &"'"
rs.open str,db, adopenstatic , adlockoptimistic
name=rs.field(1).value
if name=txtname then
exit sub
else
rs.addnew
end if
    See more | Go to post
    Last edited by Rabbit; Nov 25 '14, 06:31 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.

      Leave a comment:

    • prafulla1978
      started a topic avoid duplicate entry in vb6
      in Access

      avoid duplicate entry in vb6

      sir,
      i am developed a application in visual basic 6.0 but at last iam facing a problem when a user search data that display in all textboxes form ms access database.
      but when he click on save button the old data (searched) also saved or when he enter the new data it gets saved any problem to this i have following code
      Visual basic 6.0
      do while not rs.eof
      if rs.field(1).val ue=txtcustname. text then
      msgbox...
      See more | Go to post
      Last edited by Rabbit; Nov 23 '14, 04:56 PM. Reason: Email removed per forum policy
      No activity results to display
      Show More
      Working...