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 finding data between two dates while one field for current date. i mean i want to find data i.e. from date and to date. so how can i do this whereas i have only one field for storing current date. ?

thnq in advance.

hi there...

first, you are opening a recordset, but is not related to any database.. how is this working??

the second one is easily solved using SQL

Select x from x where datefield < firstdate and datefield > seconddate


HTH

Gonzalo