Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
FUNCTION BEHAVIOUR?
Thnks for the reply i the problem is because i call the function from the text box property in the after update property i type =durchschnittNoten() that make infinite loop and only call function so i must write it manually in the vb code Private sub txt0_AfterUpdate() call Average End Sub- easten
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
FUNCTION BEHAVIOUR?
i'm sorry if i write the code a little bit confusing in my thread. but i don't write the code because i thought the code will not have any relation with the function behaviour i get. the code: Function Average() On error Goto Err_Handler Dim divident as Double Dim total as Double divident...- easten
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
FUNCTION BEHAVIOUR?
I have made a code using function and not sub in the module. the function will be used for every form i made, the function is used to calculate the average and generate it when the after update event happen. the code: Public Function Average() On Err Goto Err_Handler Code**************...- easten
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Dynamic Dividing
thks Alex the code really help me a lot- easten
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Dynamic Dividing
firstly, i would like to thanks for all the answers in this forums, it helps me a lot. i have a question that i didn't find in this forum. i have 5 fields (math, physic, informatic, German, and Englih) in one table, and i want to calculate the average's mark from these 5 fields, for example...- easten
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
