To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110324
Issue #|110324
Summary|Macro assigned to "Before updating of the record" even
|t in the Form control, executes twice
Component|Database access
Version|OOO320m9
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|rackham
------- Additional comments from rack...@openoffice.org Mon Mar 22 21:33:49
+0000 2010 -------
Hi,
In Base, the macro assigned to "Before updating of the record" event in the Form
control, executes twice.
Open "Rackham, Macros.base2.odb" file.
Open "Clients" Form.
On the 1rst record, change the value in "CAmensuel" field to 10.00.
Click on the "Updating record" button in the scrolling bar.
The "CAannuel" will change from 0.00 to 20.00.
Here is the macro :
Sub MajCAannuel
dim PysCtrlCAmensuel as object
dim PysCtrlCAannuel as object
PysCtrlCAmensuel =
ThisComponent.DrawPage.Forms.getByName("Clients").getByName("fmtCA mensuel")
PysCtrlCAannuel =
ThisComponent.DrawPage.Forms.getByName("Clients").getByName("numCA annuel")
'Xray PysCtrlCAmensuel
'Xray PysCtrlCAannuel
PysCtrlCAannuel.Value = PysCtrlCAannuel.CurrentValue +
PysCtrlCAmensuel.CurrentValue
PysCtrlCAannuel.commit
End Sub
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
