Hello,
Is it possible to combine a Sub and an UNO action together in a macro as from the GUI this does not seem to be an option, thank you
Please give more information about what you are trying to do. Perhaps this is about a dispatcher command such as “.uno:Cut”. To see a subroutine like that, use the macro recorder in Writer. That is not currently possible in Base, so use the recorded code from Writer in your Base database. Or better yet, look up an example online.
Hi, I have some forms containing multiple table controls and some buttons at the top to navigate to other forms. If the user moves from a table control to a button to open another form, a macro will open the requested form without loading any data if the user did not save the latest change in the table control.
Therefor I d like to change the macro to first save the record and then open the new form.
Hope this makes sense, thks
Hello,
As noted already by @jimk you can lookup a slot on line → Macro to save record
This seems to work as you want:
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dispatcher.executeDispatch(document, ".uno:RecSave", "", 0, Array())
You may also want to delve into uno commands. See links in this post → I need documentation of oDispatcher.executeDispatch
Make certain the button to run this is on the form where the record is to be updated.
Thank you gentlemen, much appreciated!
Thank you gentlemen!
How about a dispatche in a Dialog Grid?
Primeira ideia se não houver melhor seria:
’ iLine= LocateBinSearch(Array(Idx); stxtPesquisa ): Integer; ’ a iLine
’ Args(3).Value = iLine then goto iLine
oGrid = oDlg.getControl(“tab_g1”).model.GridDataModel ???
oDispatch.executeDispatch(oDocFrm.oGrid ???, “.uno:GotoLine”, “”, 0, args)
The question marks are my great doubts
I found no examples about Grids inside a Dialog box
The mean idea is to performe a uno:gotoline after locate a certain key in an Array(idx) where Idx will be the line to go to.
Can you help?
Best Regards
@dosreis57
Do not understand why you continue to bury questions in other topics. Have seen you create new questions on the Portuguese sight. Why not here?
.
This comment is off-topic and requires a new question. Have asked this many times in past and always seems to get not response and do most of my other answers to you.
.
Tired of trying to help someone who will not help in return. Maybe someone else will help.
Sorry! I was not a ware that you assist both groups.
The ideia was not disturb but just try to get some help for those perheaps more avaible.
Ok I’ going to open a New Topic once you tell me i should.
Sorry once more
Best regards
??? have posted to you on both sites. How could you not be aware?
That is a choice for each of us. Your mistake was to post where I have and this notifies me. I chose to respond but often you did not. This is where the trouble starts. Posting on a new question opens it up to more potential answers.