problem in updating records & finding records
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
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.