Ask Your Question
0

In LibreOffice Base, How to write a button macro that will open different form to a specific PrimaryID?

asked 2015-10-19 06:04:22 +0200

anonymous23423 gravatar image

updated 2015-10-20 13:21:30 +0200

Alex Kemp gravatar image

In LibreOffice Base, How to write a button macro that will open different form to a specific PrimaryID?

In LibreOffice Base, How to create a macro for a button that reads an ID field from the current record then uses this ID to open a different form to the record with ID = PrimaryID?

I'm using LibreOffice 5 with Windows 8.1

Would be nice if somebody would add this to the official documentation under macros.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-10-19 22:09:30 +0200

doug gravatar image

You could use the learning of this answer (how to open form and and navigate records). Create a control that displays the PrimaryID of the record, call the control in an object variable (look for answers that use ThisComponent or ThisDatabaseDocument as a starting point) the value being ControlObject.Value, then create a recordset using a query limited to that id or engage in a math exercise of counting how many records are earlier or later and browsing in the full recordset to that record. Or apply a filter like in the linked answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-10-19 06:04:22 +0200

Seen: 1,294 times

Last updated: Oct 19 '15