|
-
Mar 21st, 2006, 08:38 PM
#1
Thread Starter
Hyperactive Member
What's wrong with this?
Im trying to add the value in the database so the value will keep accumulating instead of just updating.
VB Code:
rs(1) = amt
rs(9) = amt + rs(9).value
Whenever I key in a value(amt), it will be store in rs(1) in the database, so now I wants to created a new column "rs(9)" for the accumulating value. Whats wrong with this code or is there anyway I can do? Please advice... 
-
Mar 21st, 2006, 08:41 PM
#2
Frenzied Member
Re: What's wrong with this?
use the value property
VB Code:
rs(9).Value = 'your new value
On error goto Trap
Trap:
in case of emergency, drop the case...
****************************************
If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option. if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
-
Mar 21st, 2006, 08:42 PM
#3
Frenzied Member
Re: What's wrong with this?
by the way, what field is rs(9) in your query or recordset?
On error goto Trap
Trap:
in case of emergency, drop the case...
****************************************
If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option. if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote