这是不同的：将公式转换为值

解决方案 ManningFan写道： 不要问为什么，这只是一个客户端想做... 我想在我的数据库中放一个带有4个文本框的表格; txtA，txtB， txtFormula和txtValue 客户希望能够在txtA和txtB中输入数字。然后他希望能够在txtFormula中输入一个公式并将 值吐入txtValue。 所以，对于例如，他将6输入txtA，将10输入txtB。在 txtFormula中他输入; （txtA + txtB）/ 2 txtValue应显示数字8. 这可能吗？ txtA = 1 txtb = 2 ？ Eval（（txtA + txtB）/ 2） 1.5 6月4日下午12:07，沙拉< o ... @ vinegar.comwrote： ManningFan写道： 不要问为什么，这只是客户想做的事情...... 我想在我的数据库中放一个带有4个文本框的表格; txtA，txtB， txtFormula和txtValue 客户希望能够在txtA和txtB中输入数字。然后他想要能够在txtFormula中输入一个公式并将 值吐入txtValue。 因此，例如，他将6输入txtA，将10输入txtB。在 txtFormula中他输入; （txtA + txtB）/ 2 txtValue应显示数字8. 这可能吗？ txtA = 1 txtb = 2 ？ Eval（（txtA + txtB）/ 2） 1.5-隐藏引用文字 - - 显示引用文字 - 出于某种原因，当你这样做的时候会这样做，但是当你这么做的时候不会这样做。（E.txtFormula）。我知道我很接近，但还没有到那里。 " ManningFan" < ma ******** @ gmail.com写信息 新闻：11 ********************* @ o5g2000hsb.googlegrou ps.com ... 6月4日下午12:07，沙拉< o ... @ vinegar.comwrote： ManningFan写道： 不要问为什么，这只是客户想做的事情...... 我想在我的数据库中放置一个带有4个文本框的表单; txtA，txtB， txtFormula和txtValue 客户希望能够在txtA和txtB中输入数字。然后他想要能够在txtFormula中输入一个公式并将 值吐入txtValue。 因此，例如，他将6输入txtA，将10输入txtB。在 txtFormula中他输入; （txtA + txtB）/ 2 txtValue应显示数字8. 这可能吗？ txtA = 1 txtb = 2 ？ Eval（（txtA + txtB）/ 2） 1.5-隐藏引用文字 - - 显示引用文字 - 出于某种原因，当你这样做的时候会有效，但是当你这么做的时候不会这样做。（E.txtFormula）。我知道我很接近，还没到那里。 我认为你需要更好地定义txtA和txtB。 ？ Evail（（[txtA] + [txtB]）/ 2） 您更可能需要定义一个函数来解析公式并且 返回一个价值。 Don''t ask why, this is just something a client wants to do... I want to put a form in my database with 4 text boxes; txtA, txtB,txtFormula and txtValue The client wants to be able to enter numbers into txtA and txtB. Hethen wants to be able to enter a formula in txtFormula and spit thevalue into txtValue. So, for instance, he enters 6 into txtA and 10 into txtB. IntxtFormula he types; (txtA + txtB) / 2 txtValue should then display the number 8. Is this possible? 解决方案 ManningFan wrote:Don''t ask why, this is just something a client wants to do...I want to put a form in my database with 4 text boxes; txtA, txtB,txtFormula and txtValueThe client wants to be able to enter numbers into txtA and txtB. Hethen wants to be able to enter a formula in txtFormula and spit thevalue into txtValue.So, for instance, he enters 6 into txtA and 10 into txtB. IntxtFormula he types; (txtA + txtB) / 2txtValue should then display the number 8.Is this possible? txtA = 1txtb = 2? Eval((txtA + txtB) / 2)1.5 On Jun 4, 12:07 pm, salad <[email protected]:ManningFan wrote: Don''t ask why, this is just something a client wants to do... I want to put a form in my database with 4 text boxes; txtA, txtB, txtFormula and txtValue The client wants to be able to enter numbers into txtA and txtB. He then wants to be able to enter a formula in txtFormula and spit the value into txtValue. So, for instance, he enters 6 into txtA and 10 into txtB. In txtFormula he types; (txtA + txtB) / 2 txtValue should then display the number 8. Is this possible? txtA = 1txtb = 2? Eval((txtA + txtB) / 2) 1.5- Hide quoted text -- Show quoted text -For some reason that works when you do it like that, but not when youdo Eval(Me.txtFormula). I know I''m close, just not quite there yet. "ManningFan" <ma********@gmail.comwrote in messagenews:11*********************@o5g2000hsb.googlegrou ps.com...On Jun 4, 12:07 pm, salad <[email protected]: ManningFan wrote: Don''t ask why, this is just something a client wants to do... I want to put a form in my database with 4 text boxes; txtA, txtB, txtFormula and txtValue The client wants to be able to enter numbers into txtA and txtB. He then wants to be able to enter a formula in txtFormula and spit the value into txtValue. So, for instance, he enters 6 into txtA and 10 into txtB. In txtFormula he types; (txtA + txtB) / 2 txtValue should then display the number 8. Is this possible? txtA = 1 txtb = 2 ? Eval((txtA + txtB) / 2) 1.5- Hide quoted text - - Show quoted text - For some reason that works when you do it like that, but not when youdo Eval(Me.txtFormula). I know I''m close, just not quite there yet. I think you will need to better define txtA and txtB. ? Evail(([txtA] + [txtB]) / 2) You will more likely need to define a function to parse the formula andreturn a value. 这篇关于这是不同的：将公式转换为值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！