Math Functions

[matethreat]

Hello,

I am having troubles getting my math functions to work in code.

Text 1 is just a number someone enters. Then I have a calculate button that is pressed and I entered the following code in the OnClick Event of that button.

Me.Text2 = SQRT(Me.Text1)

This is just an example.

Does anyone know why I am having problems with this.


Destiny Is Not The Chances We Take, But The Descisions We Make.

 

[RoyVidar]

If sqrt is a function you've created yourself, make sure it is in a standard modue. Else the inbuilt thingie is sqr.

But please state what kind of problem you're having, error message...

Roy-Vidar

 

[matethreat]

I did figure out that it was sqr. The problem is if you look at the help files within access 2000 they tell you it is SQRT. I am trying to locate all the math functions available but they don't seem to be within the help files. Currently I am trying to figure out what the Arc Tangent is, really frustrating.

Destiny Is Not The Chances We Take, But The Descisions We Make.

 

[RoyVidar]

Strange, if I type "math" in the answer wizard in help (2000 - in VBE), I get a list of functions, where Atn is one of them (but don't ask me what it does;-)).

Roy-Vidar

 

[rou13]

Arc Tangent is the inverse of the trigonometric Tangent function (you remember Trigonometry?). By "inverse", we mean the input (function argument) is assumed to be the tangent of some angle, and the result (i.e. the answer, the value of Atn) is what the angle is.

 

[matethreat]

I know what each function means I just didn't know what the abbreviation for those functions were in Visual Basic.

My problem is I couldn't use the help menu in the visual basic window, so I wasn't getting the proper help files. I had to use the help file from the form, which was giving me functions that weren't applicable in Visual Basic.

The Visual Basic help file didn't install on the first try, I have got it working now, and don't imagine I will have any more confusion figuring out the functions.

Thanks for the help.

Destiny Is Not The Chances We Take, But The Descisions We Make.