vb code for calculation from single text box

[abz_y2k]

Hi

Can anyone please guide me how to carry out this simple task

I got a database with record and total spend for each record. I want the total to be summed up in another text box to display the total i have spent so far

can anyone please help

 

[DCrake]

Re: vd code for calculation from single text box

Are you doing this via Access or Visual Basic?

 

[abz_y2k]

Re: vd code for calculation from single text box

The database is on access and coding am doing in visual basic

 

[abz_y2k]

Re: vd code for calculation from single text box

Any advice anyone?

 

[ghudson]

Re: vd code for calculation from single text box

Try the DSUM function. http://office.microsoft.com/en-us/access/HA012288291033.aspx

 

[boblarson]

Re: vd code for calculation from single text box

coding am doing in visual basic

So you are NOT writing code in Access but are instead using Visual Basic 4, 5, or 6 to connect as a frontend to Access? This forum category is for Visual Basic and not VBA which is what you are using if you are writing this from within Access.

 

[abz_y2k]

Re: vd code for calculation from single text box

Hi i have attached the sample database am working on.

What am trying to do is to sum up all the window locks fitted for every records.

So when i eg: enter 6 windows lock fitted for abs, it should show up on Total lock fitted text box. And when i add mick had 10 locks fitted it should total up abs and Micks etc etc.

Any help would be appreciated, been scratching my head all day today

Database is on Access 97

 

[boblarson]

Re: vd code for calculation from single text box

Don't be storing the calculated amount remaining. That should be calculated and DISPLAYED at runtime.

 

[abz_y2k]

how would i do that?

 

[abz_y2k]

any suggestion?