Programming Help

Web Development

Welcome to Dream.In.Code
	Getting Help is Easy! Join 118,883 Programmers for FREE! Ask your question and get quick answers from experts. There are 2,038 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now! Chat LIVE With a Expert Register to Make This Box Go Away!

boshman	30 Jun, 2008 - 01:42 AM Post #1
New D.I.C Head Joined: 6 Jul, 2007 Posts: 7 My Contributions	ok heres the problem, I need MS Access 2003 to add up one number box from each record in the table and put it into another number box is there any quick(ish) way to do this or is it just a case of puttin it all on the same form and going CODE cdbl(text1.text) + cdbl(text5.text) + cdbl(text9.text).... etc btw I am using VB 6.0 on Access. Also one of the things that I'm trying to do is doing a maths operation. Basically CODE Private Sub text2_GotFocus() text2.Text = CInt(text3.Text) / 10 End Sub however when i try and debug this, MS access tells me that in order to work with something it needs to be in focus :S any help NEEDED!!! Many Thanks This post has been edited by boshman: 30 Jun, 2008 - 03:44 AM
	This Post Was Helpful! ^New!

grantunderland	15 Jul, 2008 - 04:48 PM Post #2
New D.I.C Head Joined: 14 Jun, 2008 Posts: 23 Thanked 1 times My Contributions	How are you trying to go about this? Is this on a form, report, DAP, etc? If it's a form, is it single, continuous, datasheet, etc? There are a lot of details that would help us help you. For example, IMHO, continuous forms are a bitch to program, but there are ways around that too.
	This Post Was Helpful! ^New!