sample form coding pls...

[anthony p.]

Hi,

Any help for a very simple sample computation coding pls? like: (add1 + add2
= ans) It's badly needed. I tried and tried so many times creating
events(code builder) on my form controls but it didn't work. I don't know if
i got the right track. Also, i don't know how to run it to get the right
answer.

Thanks in advance.

 

[Piers 2k]

Bit more info pls?

What are you actually trying to do - what fields? And where do you need it -
Query, Form or Report? Or all?

Piers

 

[anthony p.]

Hi,

I just want to use and compute my textbox unbound like: add1 + add2 =
answer
I know how to compute it in a Query. The reason why do i badly need it in
form coding because some of my computation in query are not workiing. So,
this will serve as my reference and it is because i don't know everythng
about form coding and how does it run. I just really need a simple sample
form coding of Add1 + Add2 = Answer and how do i run it?

help me pls.!

Many thanks in advance.

 

[Piers 2k]

OK,

The main part of the formula is the same wherever you are. If you are adding
10 to a field called Number, the formulae would be:

Query: MyFormula: [Number] + 10 (MyFormula is any name you wish to use)
Form: =[Number]+10 (put it in a text box)

Or adding two fields:
Query: DoMyThing: [Number] + [OtherField]
Form: =[Number] + [OtherField]

Just make sure that, if you're field is called number, that the NAME of the
text box isn't Number as well. It gets confusing!!

Hope this helps,

Piers

 

[anthony p.]

Hi Piers,

Thanks a lot for that!

Can you pls. give me a procedure or sample coding on how to code it in
Visual Basic Editor? Let us use example: =[number] + [otherfield]

It's my frustration Piers (That's really true!). I hope you will be my
answer. This will serve/help me start using Visual Basic coding in Access.

Thanks a lot and gob bless always!