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+h...@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
