Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.