Apache OpenOffice Community Forum

I am trying to use two different buttons in my forms; one to open another form, and one to close it. But i can't figure out how to do it! there are plenty of preset actions, but none of them open and close forms.

[Solved] Closing form with macro

Use property "Additional Info" to specify the name of the form to open.
Assign this macro to the button's event "Before Commencing": The button must belong to a top-level form rather than a subform.

Where do I put the macro? I can't find where to write it into

[Tutorial] How to install a code snippet
Next version 3.1 will allow for macros embedded in database documents. Since this macro is designed to work with any embedded form, you may prefer the global container.

I can get it to open another form on demand, but I still can't get it to close it; that link you gave me wasn't particularly helpful (little ole me just got confused!)

You can use a button to open a URL such as http://google.com or file:///tmp/document.odt
Most office commands have URLs too. One of them is .uno:CloseDoc which corresponds to menu:File>Close

Where do i type that in?

Button properties
Action: Load document or web page
URL: .uno:CloseDoc

or call menu:Insert>Hyperlink...

Thanks

This helped me a lot.

Can you use buttons to generate reports as well? If so, how would the macro need to be changed?

Thanks again.

When I change ... ... to ... ... the office freezes. It's one of hundreds of bugs in the database API.
Do you know the switchboard extension? Obviously it contains working code to open a report. I don't waste more time with this branch of the API, particularly not for gimmicks like loading a report with one click.

Hi Villeroy,

you helped me also a lot with that macro, too,....many thanks,

Next questions:

How can i transfer data with that macro?

Example: When I have data "Green Monster" in form A, than I want that the data of "Green Monster" also appears in the next form B ... so that I can go on working easily....

I tried different possiblities, but nothing works out... (post/get ... etc)

Jens

Normally you would use a subform attached to the same form document.

Villeroy wrote:[Solved] Closing form with macro

Use property "Additional Info" to specify the name of the form to open.
Assign this macro to the button's event "Before Commencing":

Code: Select all

Sub openFormByTag(oEv)
REM OOo3.0: Reads the form name from a calling control's tag
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 

The button must belong to a top-level form rather than a subform.

This macro helped me open a form, but can it be modified to open a specific record within a form? Thanks in advance.

ChristyMcFadden wrote:...can it be modified to open a specific record within a form?

Yes.

See the following:
Open a Form filtered
RPG's Tutorial: Open Form with Macros
Some problems can crop up if you use the Open Document event
...