Hi I have libreoffice 188.8.131.52 and using it as frontend for mysql database, using JDBC connector. I have a parameter query based on user input and have created a form based on that query. I am using a form button in a main input form based on a table and I call the query or form by a button which runs a macro to open the form. This macro I got from the web and it is simply:
Sub openFormByTag(oEv) cWhat = com.sun.star.sdb.application.DatabaseObject.FORM oModel = oEv.Source.getModel() sName = oModel.Tag oView = oModel.Parent.Parent.Parent.Parent.getCurrentController() oView.loadComponent(cWhat, sName, FALSE) End Sub
What I would like is to run the parameter query/form and size it and have it appear to the right and in front of the mainform. The query/form is really for checking some fields which have to be filled in the main form. Is this possible and can you advise how to code this.
Ideally I would like this query to be to appear as a sub form. Would this be possible?
Edit (moved from not-an-answer answer by @Ratslinger ):
I have a rollcall/attendance table which is filled in with a form. This rollcall table includes fields ‘class id’ and ‘child id’ both linked to two respective tables. I have a parameter query where a teacher can input class ids and it results in details of child name, id and class id, room, teacher id etc, in ascending order based on class id. The main purpose is to give the teacher a check that they are using correct data when filling in the rollcall table.
So far I have a button which runs the query or form based on the query and that seems to run fine but it opens a complete new page and it fills the whole screen. I would like the be able to size the new query or form so that it is readable and on top of or to the right of the main rollcall form.
As I said I run the query with the above macro. I am afraid I can not explain it any better. This may not be the way experts might do this but I am just a novice.