gstylianou
Registered User.
- Local time
- Today, 16:36
- Joined
- Dec 16, 2013
- Messages
- 357
Good evening
I am facing a problem which is really strange and I hope someone to give the answer. Within a VBA Module I have several equations some of them are simple and some more complex. Specifically, I have the following equation:
X= 495 / (1.29579 - 0.35004 * (Log(87 + 97 - 32)) + 0.221 * (Log(167))) - 450
The problem is that, it gives a wrong result (completely wrong!!) when I give it as a string in one related field in my form. ! Moreover, the even dumber thing is if i copy and paste it into excel as it is i have the correct result(!!) And I say "correct" since I know exactly the result that should be occur through another Excel file.
Note that:
1. The related field which i want to give the result it is numeric field (Double, Standard, 2)
2. I created a new calculated field in a table with the same equation in order to check what's going wrong with the same data type of field (Double, Standard, 2) and it gives a completely different result from that in VBA
I don't know what else I can say, but the only thing I believe (and I've had it in my mind for hours) maybe there is a problem with my Office package ? - ( 2019 ProPlus 32bit)
Any help is more than welcome
I am facing a problem which is really strange and I hope someone to give the answer. Within a VBA Module I have several equations some of them are simple and some more complex. Specifically, I have the following equation:
X= 495 / (1.29579 - 0.35004 * (Log(87 + 97 - 32)) + 0.221 * (Log(167))) - 450
The problem is that, it gives a wrong result (completely wrong!!) when I give it as a string in one related field in my form. ! Moreover, the even dumber thing is if i copy and paste it into excel as it is i have the correct result(!!) And I say "correct" since I know exactly the result that should be occur through another Excel file.
Note that:
1. The related field which i want to give the result it is numeric field (Double, Standard, 2)
2. I created a new calculated field in a table with the same equation in order to check what's going wrong with the same data type of field (Double, Standard, 2) and it gives a completely different result from that in VBA
I don't know what else I can say, but the only thing I believe (and I've had it in my mind for hours) maybe there is a problem with my Office package ? - ( 2019 ProPlus 32bit)
Any help is more than welcome