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 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.