To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=86862
Issue #|86862
Summary|Before Record Change causes mainform records to skip
Component|Database access
Version|OOo 2.3.1
Platform|PC
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|voobase
------- Additional comments from [EMAIL PROTECTED] Mon Mar 10 08:42:13 +0000
2008 -------
This issue relates to mainform records being skipped over when using a mouse to
operate the next/previous form navigator buttons if you are using a macro (any
macro) triggered by the Before Record Change event of your subform. The form is
the normal main / sub setup with many subform records related to each main
record.
The macro is not important as long as more than a few lines of code and is being
triggered by the Before Record Change event of the subform. When there are more
than 10 subform records related to a mainform record, and you are navigating the
mainform records with a mouse click of the navigator bar, quite often this
mainform record gets skipped over.
This problem occurs on both Windows XP and Vista and I have reproduced it with
oOffice V2.2.1 (PortableApps), V2.3.0 and V2.3.1. It will occur with vista if
there are 10 or more subform records for a main and with XP with 20 or more
subform records. An interesting clue I have discovered is that the normal click
operation of the mouse will have the issue occur consistently, however if you
tap the mouse button super quickly the problem will not occur as much. I have
changed the delay in the navigator bar properties but this has no effect.
I will attach the simple database which I have been using to confirm this bug.
It consists of 36 mainform records with the amount of subform records for each
increasing each time up to a maximum of 21. The XP computer seems to only have
issues with the last couple of entries where the subform records are about 20
whilst vista has a problem when there are more than 10. The macro is nothing
special as seen below.
Sub BeforeRecordAction_SayBoo(event As Object)
Dim Word
Dim Form As Object
Dim Control As Object
Dim ControllerName As String
Dim FormName As String
Word = "Boo"
If Word = "Boo" then
' msgbox "Say " & Word
endif
End Sub
I also have raised this on the oOForum at
http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=3272&sid=cd328e5d61411368efff882a6d5feb84
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
