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(sNewDocumentName).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: [email protected]
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
