VBA APIs for running actions on forms
Details of the API services for running actions on forms¶
TGK_refreshTree
| Element | Description |
|---|---|
| Syntax | Application.run("Tgkrmacro.xlam!TGK_refreshTree") |
| Description | Overrides the dimensions tree refresh. - In the processing wizard, the refresh at the end of data processing can be overridden without using custom macros. - When edited values in transactional forms are saved, the dimensions tree is refreshed automatically, if necessary. |
TGK_ManipulateFormRow
| Element | Description |
|---|---|
| Syntax | Dim bResult as Boolean bResult = Application.run("Tgkrmacro.xlam!TGK_ManipulateFormRow", range, " |
| Description | Allows you to manipulate a row of a transactional form. |
| Necessary parameters | - RANGE. Range relative to the cell in the row to be manipulated and in the column relative to the deletion filter. - CODICE_OPERAZIONE. String that identifies the type of operation to be performed on the row identified by the previous parameter. The parameter can have the following values: - ADD. Adds a row at the bottom of the matrix and opens the details form for the newly created row. - EDIT. Opens the details for to edit the transactional form matrix row. - DELETE. Deletes the row. - UNDELETE. Undoes the deletion of the row. |
| Value returned | TRUE if the operation was completed successfully; FALSE otherwise. An operation may fail for the following reasons: - The active report is not open in data entry mode. - The specified range does not correspond to a deletion cell of a transactional matrix. - An invalid operation has been specified. - An ADD or EDIT operation has been specified and the editor has not been enabled for transactional forms. - A DELETE action has been specified on a row that has already been deleted. - An UNDELETE action has been specified on a row that has not yet been deleted. |