sample form coding pls...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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
 
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!
 
Back
Top