Re: [libreoffice-users] Using a Button to activate Subform.

Hi Ian,

Is there an error message showing in the Macro Edit window?

You should be able to close the window after clicking on the Stop Macro
button, (a red circle with the white 'X' in it, in the middle of the
controls up the top.)

Does the sub Form work if you run it manually?  (Double click on the Form
name.)  If so then your button should call the sub that calls the Form - I
take it that the Table is connected to the Form.

If none of this helps, could you post the modified code you are attempting
to run?

Noel
--
Noel Lodge
lodgemn@gmail.com


On 29 March 2013 23:23, Ian Whitfield <whitfield@telkomsa.net> wrote:

> Thanks Noel
>
>
> On 29/03/13 13:13, Marion & Noel Lodge wrote:
>
> > Hi Ian,
> >
> > Not  sure if this is what you need, but it works for me.  I got it from
> > the
> > Web.
> >
> > On the Events tab of my button under 'Mouse button pressed', I connect to
> > the sub, OpenfMembers().  If you substitute your form name in place of
> > "fMembers" I think it should work for you too.
> >
> > Sub OpenfMembers(oEvent AS Object)
> >
> >        OpenForm("fMembers")
> >
> > End Sub
> >
> >   Sub OpenForm(FormName AS String)
> >
> >        With ThisDatabaseDocument.**currentcontroller
> >
> >             If Not .isConnected Then
> >
> >                  .Connect
> >
> >             End if
> >
> >        End With
> >
> >        ThisDatabaseDocument.**FormDocuments.getByName(**FormName).open
> >
> > End Sub
>
> I tried this and it seems to remind me that I used something like this
> before!!
>
> However when I try it and "press the button" on my Main Form it takes me
> to the Macro Edit window and I can not close this as it says "Basic is
> still running"!!
>
> Should I be linking to my Table or to my Form?? Otherwise any other ideas??
>
> Thanks a lot
>
>
> IanW
> Pretoria RSA
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org <users%2Bhelp@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@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