View Single Post
  #1 (permalink)  
Old January 16th, 2007, 11:15 AM
naveed77 naveed77 is offline
Authorized User
 
Join Date: Jul 2006
Location: dera ismail khan, nwfp, Pakistan.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to naveed77 Send a message via Yahoo to naveed77
Default problem in updating records & finding records

dear reader,

i m new to vb6 and access database, i m working on a project, well i want to update a record then it updates but in database it overwrites on first record not its original location.

here is the code that i use,

private sub cmdupdate()

dim tb as new adodb.recordset

tb!letter=txtletter.text
tb!date=date.value
tb!subject=txtsubject.text

tb.update
clearfields

end sub

where is the problem or please tell me the right code so that record must be updated on its original location in database.

another problem is to find data between dates. how can i find data between dates while i have only one field where current date is stored. how can i find data between dates using that one field ?

thnq in advance.
Reply With Quote