Confirm MsgBox

oyarzabalyago

Forums

 
Hello, I am calculating total field, and it always asks me for confirmation. I would like to know if it is possible to code the OK always. Or if the total of the column can be added in another way, the example is welcome. Thank you

Brian Element Thu, 03/05/2020 - 12:54

You need to make sure that the stats have first been generated before displaying the amount field.  This is how you would do it:


Set db = Client.OpenDatabase("1%_ACTIVOS.IMD")
Set stats = db.FieldStats("SALDO_SUMA")
If Not stats.computed Then
	stats.ComputeStats
End If
db.ControlAmountField "SALDO_SUMA"