LibreBase - Enable Record Macro

Use the Tools > Options menu option. Navigate to the LibreOffice > General option within the Options dialog. There is a checkbox labeled "Enable experimental (unstable) features". Make sure it is checked.

Dear Jacobsallan

Thanks for your quick response

I've done what you suggest however the Record Macro is still greyed

regards Your Investment - Wealth - Health - Education consultant

Budi Machribie (F06592)
The SunHorse Team

PT.Sunlife Finance Indonesia
Gd CIMB-Niaga 3Ath fl
Jl.Jen.Sudirman kav 25
Jakarta 12920

+08161815979

Blog-http://tough2slf.multiply.com/

Website: http://www.tough2slf.net78.net/

________________________________
From: Jacobsallan &lt;<email address hidden>&gt;
To: <email address hidden>
Sent: Friday, November 4, 2011 11:45 AM
Subject: Re: [Question #177487]: LibreBase - Enable Record Macro

Your question #177487 on update-manager in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/update-manager/+question/177487

    Status: Open =&gt; Answered

Jacobsallan proposed the following answer:
Use the Tools &gt; Options menu option.  Navigate to the LibreOffice &gt;
General option within the Options dialog.  There is a checkbox labeled
&quot;Enable experimental (unstable) features&quot;.  Make sure it is checked.

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/update-manager/+question/177487/+confirm?answer_id=0

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/update-manager/+question/177487

You received this question notification because you asked the question.

Online help says that macro recording is available for text documents in Writer or spreadsheets in Calc. Not Base.

Dear Jacobsallan

Too Bad for Base....should I go back to MS-Access?
BTW do you know a workaround or whom I should contact

Thanks anyway

 Your Investment - Wealth - Health - Education consultant

Budi Machribie (F06592)
The SunHorse Team

PT.Sunlife Finance Indonesia
Gd CIMB-Niaga 3Ath fl
Jl.Jen.Sudirman kav 25
Jakarta 12920

+08161815979

Blog-http://tough2slf.multiply.com/

Website: http://www.tough2slf.net78.net/

________________________________
From: Jacobsallan &lt;<email address hidden>&gt;
To: <email address hidden>
Sent: Saturday, November 5, 2011 8:06 AM
Subject: Re: [Question #177487]: LibreBase - Enable Record Macro

Your question #177487 on libreoffice in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

    Status: Open =&gt; Answered

Jacobsallan proposed the following answer:
Online help says that macro recording is available for text documents in
Writer or spreadsheets in Calc.  Not Base.

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487/+confirm?answer_id=2

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

You received this question notification because you asked the question.

The LibreOffice home page is http://www.libreoffice.org/ .

To log a bug, use https://bugs.freedesktop.org/ . You will need to register using an email address an password first.

Hi Budi

What is it that you want to do with macros? Maybe there is some other way of achieving it. From what I remember of Access (many years ago) there was no macro recording. There was the VBA programming language. Is that what you are looking for?

Tony

Dear Tony

What I wanna do is simple to make a push button to open another form from within a form .. for instance that button is in form named address with action to open a client/produk form ..

Sorry bothering you

regards
 Your Investment - Wealth - Health - Education consultant

Budi Machribie (F06592)
The SunHorse Team

PT.Sunlife Finance Indonesia
Gd CIMB-Niaga 3Ath fl
Jl.Jen.Sudirman kav 25
Jakarta 12920

+08161815979

Blog-http://tough2slf.multiply.com/

Website: http://www.tough2slf.net78.net/

________________________________
From: Tony Pursell &lt;<email address hidden>&gt;
To: <email address hidden>
Sent: Saturday, November 5, 2011 6:55 PM
Subject: Re: [Question #177487]: LibreBase - Enable Record Macro

Your question #177487 on libreoffice in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

Tony Pursell requested more information:
Hi Budi

What is it that you want to do with macros?  Maybe there is some other
way of achieving it.  From what I remember of Access (many years ago)
there was no macro recording.  There was the VBA programming language.
Is that what you are looking for?

Tony

--
To answer this request for more information, you can either reply to
this email or enter your reply at the following page:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

You received this question notification because you asked the question.

Hi Budi

In Design mode, insert a new button, right click on the new button, choose 'Control..', in the Properties dialogue choose the 'Events' tab, against the appropriate event (possibly, 'Execute action') click the '...' button, under 'Assign:' click the 'Macro' button, then select the macro you want.

You will, of course, need to learn a bit about LO macros and macro coding. This is the same sort of task as learning VBA. There are a lot of on-line resources. You could start at http://www.pitonyak.org/oo.php Much of the help out there is still listed under OpenOffice.org which is fully compatible with LibreOffice.

Tony

PS If this answers your question, please go to

https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

and mark it as Solved

Hi Tony,

We're back in square one .... my problem is the Macro ..how do I code the OpenForm Macro...

 Your Investment - Wealth - Health - Education consultant

Budi Machribie (F06592)
The SunHorse Team

PT.Sunlife Finance Indonesia
Gd CIMB-Niaga 3Ath fl
Jl.Jen.Sudirman kav 25
Jakarta 12920

+08161815979

Blog-http://tough2slf.multiply.com/

Website: http://www.tough2slf.net78.net/

________________________________
From: Tony Pursell &lt;<email address hidden>&gt;
To: <email address hidden>
Sent: Saturday, November 5, 2011 11:00 PM
Subject: Re: [Question #177487]: LibreBase - Enable Record Macro

Your question #177487 on libreoffice in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

    Status: Open =&gt; Answered

Tony Pursell proposed the following answer:
Hi Budi

In Design mode, insert a new button, right click on the new button,
choose &#39;Control..&#39;, in the Properties dialogue choose the &#39;Events&#39; tab,
against the appropriate event (possibly, &#39;Execute action&#39;) click the
&#39;...&#39; button, under &#39;Assign:&#39; click the &#39;Macro&#39; button, then select the
macro you want.

You will, of course, need to learn a bit about LO macros and macro
coding.  This is the same sort of task as learning VBA.  There are a lot
of on-line resources.  You could start at http://www.pitonyak.org/oo.php
Much of the help out there is still listed under OpenOffice.org which is
fully compatible with LibreOffice.

Tony

PS If this answers your question, please go to

https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

and mark it as Solved

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487/+confirm?answer_id=7

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

You received this question notification because you asked the question.

>> What I wanna do is simple to make a push button to open another form from within a form .. for instance that button is in form named address with action to open a client/produk form ..

Start with a master document in Writer. You can link to existing databases from within Writer. You don't have to have Base open. Someone else will have to answer your questions about macro coding.

Hi Budi

I'm sorry but I am not an expert at writing macros, that is why I have given you a link to a site which gives you some information on writing macros. There is a forum at

http://user.services.openoffice.org/en/forum/viewforum.php?f=20&sid=50fdd9bc8ff8175e1c7f94ee1a93bc95

which deals with macros. You could ask for help there.

Tony

Here is another link to macro writing for you

http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide

OK, I have written a macro to open a form, and it works when assigned to a button in the manner I described above. Here is the code

---------------------------------------------------------------------------------------------------------------------
REM ***** BASIC *****

Sub Main

Dim Doc As Object
Dim Url As String
Dim Dummy() 'An (empty) array of PropertyValues

Url = "file:///home/tony/MyDocuments/OOo Testing/Guest_Invite.odt"

Doc = StarDesktop.loadComponentFromURL(Url, "_blank", 0, Dummy)

End Sub
---------------------------------------------------------------------------------------------------------------------

Of course, you need to write it with your file name in the line which begins Url = "file:///

To create the macro, go Tools > Macros > Organise Macros > LibreOffice Basic...

Click on Organiser...

Click on the symbol like > against My Macros to expand it, and again to open Standard. The click New... and enter a Module name (I called it myFileOpen - its important that this name does not clash with a name already defined for a standard LibreOffice macro)

Click close and you should see it listed as a module under Standard with an Existing macro listed called Main.

Click on the Module name (myFileOpen) and the Macro name (Main) to select them (this seems to be needed even if they already are highlighted) then click Edit. Copy the code above between the lines Sub Main and End Sub. Change the file name to the one you need to open. Click on the Compile icon (the first icon on the lower tool bar), then use F5 to run the macro. If all is correct, it will open your form document.

Now assign the macro to the button as I described above.

Tony

PS If this answers your question, please mark it as Solved

Just for clarification, I did not actually create the above macro code, it came from here:

http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/StarDesktop

Which is part of the Basic Guide which is here:

http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide

It is well worth looking at.

Tony Pursell & Jacob Allan I'd like to thank you in helping me with question 17748 sofar ... both are Godsend :)

Perhaps you know what the problem is with the following Macro

Sub OpenAForm(oEv As Object)
Dim GetFormName As String
Dim GetForm as Object
GetFormName = "Name2c"
GetForm = ThisDatabaseDocument.FormDocuments.GetByName(GetFormName)
GetForm.Open
End Sub

since when I run it following message appears

Basic runtime error
Object variable not set

regards Your Investment - Wealth - Health - Education consultant

Budi Machribie (F06592)
The SunHorse Team

PT.Sunlife Finance Indonesia
Gd CIMB-Niaga 3Ath fl
Jl.Jen.Sudirman kav 25
Jakarta 12920

+08161815979

Blog-http://tough2slf.multiply.com/

Website: http://www.tough2slf.net78.net/

________________________________
From: Tony Pursell &lt;<email address hidden>&gt;
To: <email address hidden>
Sent: Monday, November 7, 2011 1:10 AM
Subject: Re: [Question #177487]: LibreBase - Enable Record Macro

Your question #177487 on libreoffice in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

Tony Pursell proposed the following answer:
OK, I have written a macro to open a form, and it works when assigned to
a button in the manner I described above.  Here is the code

---------------------------------------------------------------------------------------------------------------------
REM  *****  BASIC  *****

Sub Main

Dim Doc As Object
Dim Url As String
Dim Dummy() &#39;An (empty) array of PropertyValues

Url = &quot;file:///home/tony/MyDocuments/OOo Testing/Guest_Invite.odt&quot;

Doc = StarDesktop.loadComponentFromURL(Url, &quot;_blank&quot;, 0, Dummy)

End Sub
---------------------------------------------------------------------------------------------------------------------

Of course, you need to write it with your file name in the line which
begins Url = &quot;file:///

To create the macro, go Tools &gt; Macros &gt; Organise Macros &gt; LibreOffice
Basic...

Click on Organiser...

Click on the symbol like &gt; against My Macros to expand it, and again to
open Standard.  The click New... and enter a Module name (I called it
myFileOpen - its important that this name does not clash with a name
already defined for a standard LibreOffice macro)

Click close and you should see it listed as a module under Standard with
an Existing macro listed called Main.

Click on the Module name (myFileOpen) and the Macro name (Main) to
select them (this seems to be needed even if they already are
highlighted) then click Edit.  Copy the code above between the lines Sub
Main and End Sub.  Change the file name to the one you need to open.
Click on the Compile icon (the first icon on the lower tool bar), then
use F5 to run the macro.  If all is correct, it will open your form
document.

Now assign the macro to the button as I described above.

Tony

PS If this answers your question, please mark it as Solved

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487/+confirm?answer_id=12

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

You received this question notification because you asked the question.

The symbol ThisDatabaseDocument is not defined. It looks to be legitimate in OpenOffice but not in LibreOffice. Their online documentation references the URL http://www.pitonyak.org/database/ . Download "Random DB Ramlins" or "PDF Ramblins". This reference seems to have been written before OpenOffice introduced the "ThisDatabaseDocument" symbol.

Budi,

You need to see

http://wiki.services.openoffice.org/wiki/Macros_in_Database_Documents

This describes why ThisDatabaseDocument was introduced in version 3 of OOo

I assume you are using version 3. Check it in Help > About.

The error message may be referring to the Object passed as a parameter (oEv) not being set. As it is not being used in the subroutine, why is it there?

Also, Budi, can I ask you not to include all the text of my emails in your reply to them. If you look at

https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

you will see that you are making your conversation with us very difficult to read without a lot of scrolling up and down the web page.

Tony

Hi Tony

Even Pitonyek and the LibreOffice Users side could not give me a satisfactorily answer
To make things worse ... when I tried to reinstall LibreOffice again I got the following feedback
"The action need the installation of packages from not authenticated sources".. the following problem ... I  could't download because

a message appears mentioning "check your internet connection" which is weird cause there is an internet connection to other website

I hope with the Ubuntu version 12.04 the LibreOffice is in a stable condition

Thanks for your and Jacob's cooperation in this matter

regards,

Your Investment - Wealth - Health - Education consultant

Budi Machribie (F06592)
The SunHorse Team

PT.Sunlife Finance Indonesia
Gd CIMB-Niaga 3Ath fl
Jl.Jen.Sudirman kav 25
Jakarta 12920

+08161815979

Blog-http://tough2slf.multiply.com/

Website: http://www.tough2slf.net78.net/

________________________________

Hi Budi

I would love to be able to help you further with macros, but I really don't have the time to learn enough about them to answer all your questions.

If you have other problems, not related directly to macros, you should ask for help with them in a separate question.

Tony

Dear all,

I resolved the problem by some serious research. There is an Add-On that does the trick for you.
OpenOffice Base Switchboard
Search for it in the extension database of OoO. Upload is as regular add-on. Under Tools- Addon you will find your add on. Click on it and it will start a wizard that will allow you to add items[such as forms,queries etc] to your switchboard. It allows quite some features such as sizing, colouring and even use pics as clickable buttons for your menu. Take your time to get used to it.
It creates 2 tables in your database, which contains all the relations for your switchboard.

Tony, many thanks for your help. Think all can be helped on this related question using the switchboard. It does not take any further programming

regards
hans

Hi Hans

Thank you for that information. I will remember that, if I am asked about this again.

Can I ask you to go to your original question

https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/211679

and mark it as Solved. Perhaps you should copy and paste the reply you made here to that question as well.

Thanks a lot!

Tony

Hans & Tony Pursell thanks a lot ... the waiting about a year for the answer has paid off .. bravo.. Your Investment - Wealth - Health - Education consultant

Budi Machribie (F06592)
The SunHorse Team (MyBrilliantAgency)

PT.Sunlife Finance Indonesia
Gd CIMB-Niaga 3Ath fl
Jl.Jen.Sudirman kav 25
Jakarta 12920

+08161815979

Blog : http://intranet2012.wordpress.com/

Website: http://www.tough2slf.net78.net/

________________________________
 From: hans <email address hidden>
To: <email address hidden>
Sent: Monday, October 22, 2012 2:45 PM
Subject: Re: [Question #177487]: LibreBase - Enable Record Macro

Your question #177487 on libreoffice in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/libreoffice/+question/177487

hans posted a new comment:
Dear all,

I resolved the problem by some serious research. There is an Add-On that does the trick for you.
OpenOffice Base Switchboard
Search for it in the extension database of OoO. Upload is as regular add-on. Under Tools- Addon you will find your add on. Click on it and it will start a wizard that will allow you to add items[such as forms,queries etc] to your switchboard. It allows quite some features such as sizing, colouring and even use pics as clickable buttons for your menu. Take your time to get used to it.
It creates 2 tables in your database, which contains all the relations for your switchboard.

Tony, many thanks for your help. Think all can be helped on this related
question using the switchboard. It does not take any further programming

regards
hans

--
You received this question notification because you asked the question.

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Dear friend!

Don't miss that new stuff I've just found, you're going to love it for sure, take a look here https://clck.ru/BDhmp

Thx, budi machribie

Sent from Mail for Windows 10

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Yo!

We've recently visited a very beautiful place and wanted to share that with you, check it out, it's amazing http://bit.do/dxecE

Best Wishes, budi machribie

From: question177487 [mailto:<email address hidden>]
Sent: Saturday, June 24, 2017 5:59 AM
To: <email address hidden>
Subject: That is so rad.

Because Hearthstone's rules on the margins are basically just winging it. What he said is generally true, exceptions being cards that affect themselves (Blademaster, Twilight Drake, Tinkertown).

Dread Infernal might just say that because basic cards give a little more information than needed (e.g. Blessing of Kings telling you what +4/+4 means).

Sent from Mail for Windows 10

Hey,

We’ve met some cool people at a very nice place yesterday, just take a look at who they are http://aaaabk.micromic.ru/aaaacq

Warm regards, budi machribie

From: question177487 [mailto:<email address hidden>]
Sent: Thursday, June 29, 2017 6:13 AM
To: <email address hidden>
Subject: It rhymes with blownuts.

Not an owner but I always thought it was transcoded in the box on the fly and Slingbox was only responsible for directing where each party should fire UDP packets at to bypass NAT and most firewalls. Once the UDP stream was established you just pull from the box directly.

    I can't imaging Sling paying for all that bandwidth on a single payment and no subscription model.

!

Sent from Mail for Windows 10

Dear friend!

I've just heard from a friend about that amazing stuff, I'm so excited, you've got to take a look http://novenahealthcare.com/modify.php?4342

Regards, budi machribie

Sent from Mail for Windows 10

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Hey,

I've heard you were looking for that stuff for a long time, so I finally found it for you, read more here http://gadalka-kiev.com/templates/gk_creativity//staff.php?b5b4

Sent from my iPhone, budi machribie

From: question177487 [mailto:<email address hidden>]
Sent: Sunday, August 06, 2017 12:52 PM
To: <email address hidden>
Subject: how is this socialism?

*raises hand*

But I don't mind -- we are headed out to a friend's for dinner (I missed bump day due to helping smoke ribs and making other stuff for tonight, doh!) and I'm happy for the hubs to indulge in some good bourbon tonight (he won't get sloshed but shouldn't drive). I'll enjoy a glass of wine, great food, and the company. Happy New Year ladies!

Sent from Mail for Windows 10

This question was expired because it remained in the 'Open' state without activity for the last 15 days.