p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB Databases Basics (http://p2p.wrox.com/forumdisplay.php?f=82)
-   -   problem in updating records & finding records (http://p2p.wrox.com/showthread.php?t=52771)

naveed77 January 16th, 2007 11:15 AM

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.

gbianchi January 16th, 2007 12:12 PM

please don't cross post....

http://p2p.wrox.com/topic.asp?TOPIC_ID=54910

HTH

Gonzalo


All times are GMT -4. The time now is 03:48 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.