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

Sounds to me that you may have had the Macro in a different document to your 
Base application.

Iain


On Thursday 11 Apr 2013 16:01:52 Ian Whitfield wrote:
> Hi All
>
> As Noel suggested here is the reply I sent to him after we had worked on
> the problem for a while off-list ...
>
> *I have cracked the problem*!! - I now have my Form working fine,
> (except for it's position on the screen - but that's a cosmetic!!). I
> went through what you last sent me and just got the same old error
> messages!! So I dropped back to my old favorite 'Google' and came across
> a video Tutorial by a guy called *Shane Piper* in the UK, (who I have
> corresponded with in the past). He has a great Tutorial on this subject -
> http://www.youtube.com/watch?v=9Zmd-zidIvg -
> and basically he is saying that all you need is the following ...
>
> /sub OpenForm//
> //const sNewDocumentName="NameOfYourForm"//
> //oNewFormDocument=ThisDatabaseDocument.FormDocuments.getbyname(sNewDocument
> Name).open// //end sub/
>
> I checked this on a couple of other sites and it was confirmed so I gave
> it a try ...
>
> Nothing happened!!! (??) No error messages accept if I tried a couple of
> clicks I got the 'sun.AnExceptionHas Occured' error. I messed around
> with this a bit with no change and then had a brain wave!!!
>
> "Maybe you need the full path?" - So I changed the first line to ..
>
> /const sNewDocumentName="NameOfDataBase.NameOfYourForm"//
> /
> And as I have said *IT WORKS*!!
>
> Hope this will be of use to others.
>
> 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