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


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

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.