Re: [libreoffice-users] Base - automatically running a macro on form opening

Well, for sure you can fire a macro when a document opens. I expect it 
is the same for a form, but I have not tried it. Try this:

Tools > Customize > Events

You can set macros for Document loading finished (for example). There is 
a drop-down in the bottom for "Save in". Set this to the form, not 
LibreOffice since you only want this for your specific form / document.

Next, you want a macro that is triggered when you move to the next 
record. I don't remember off hand if you can do this (I have not looked 
at it in a few years). If I did, I probably mention it in AndrewBase.odt 
if I ever did this specifically. I just don't remember and I do not have 
time to look it up right now.


On 02/06/2016 04:52 AM, Marion & Noel Lodge wrote:
> Hi Egbert,
>
> If you are running on a Windows machine, I have found ways to do what you
> were asking and I could make some suggestions if that would help.
>
> Noel
> --
> Noel Lodge
> lodgemn@gmail.com
>
> On 4 February 2016 at 14:59, Egbert Eissing <nicari234@yahoo.co.uk> wrote:
>
> > I need to fire up a macro automatically when I open a form, or when I move
> > to the next record.
> > There is obviously no form event that allows me to do that. I have placed
> > a simple macro, containing nothing but a message box into all relevant
> > event slots, to see whether any one of them will fire. But none did. This
> > appears to be strange to me, lacking such an important function.I am now
> > using a button to run my macro, but this is unsatisfactory.
> > Does anyone have an idea how I can accomplish my task?Thanks for any
> > help.Egbert
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted