Confirm MsgBox

5 posts / 0 new
Log in or register to post comments
Last post
Fri, 02/28/2020 - 15:14
#1
oyarzabalyago
Offline
Joined: 12/27/2019 - 11:41
Confirm MsgBox

 
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

Images: 
Top
Fri, 02/28/2020 - 16:44
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Can you show me the code that is giving you this dialog?

Top
Thu, 03/05/2020 - 12:29
(Reply to #2)
oyarzabalyago
Offline
Joined: 12/27/2019 - 11:41

'hago control total de la columna
Set db = Client.OpenDatabase("1%_ACTIVOS.IMD")
db.ControlAmountField "SALDO_SUMA"
 
 

Top
Thu, 03/05/2020 - 12:54
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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"
Top
Thu, 03/05/2020 - 14:20
oyarzabalyago
Offline
Joined: 12/27/2019 - 11:41

thank you very much Brian, it worked perfectly

Images: 
Top