Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-07 Thread Marion Noel Lodge
Hi Jason, You might be able to adapt this Sub for your needs: - Sub FindRecord(iTargetID AS Integer) Dim oColumn AS Object Dim iColumnValue AS Integer Dim iRowAS Integer Dim rs AS Object Dim sTargetIDAS String rs =

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-07 Thread Fernand Vanrie
Jason , this links opens a pdf http://www.baseprogramming.com/OOBasicDatabaseDev.pdf As far as I can tell, this website only (and I mean only) has two blog posts about Java programming. No references, nor anything else that seems useful. Perhaps the website has changed owner recently? On Tue,

[libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Jason White
This is some example code I'm using that opens a form. How do set set the current record number of the newly opened form from the basic script. Sub OpenDataEntry(oEvent As Object) Dim FrmName as string FrmName = Finalization - Data Entry

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Fernand Vanrie
Jason , on the website from Roberto Benitez http://www.baseprogramming.com/ you wil find what you are looking for ! This is some example code I'm using that opens a form. How do set set the current record number of the newly opened form from the basic script. Sub OpenDataEntry(oEvent As

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Jason White
Ok, so he put up a blog over his old site. I found the old content and the is no reference to opening a form from a basic macro. Surely the is an object reference. Aka Real documentation for Basic programming out there somewhere ? On Tue, Aug 6, 2013 at 10:24 AM, Jason White

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Tom Davies
Hi :) Maybe one of the links in this link? https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers It would be nice if the link that has already been given could be added in there so feel free if you know how to edit a wiki (it easy to learn by just doing

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Andrew Douglas Pitonyak
https://wiki.documentfoundation.org/images/5/50/BH40-BaseHandbook.odt http://www.baseprogramming.com/OOBasicDatabaseDev.pdf http://www.pitonyak.org/database/ http://www.pitonyak.org/database/AndrewBase.odt http://www.pitonyak.org/oo.php These links just provide some ideas of other places to

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Jason White
Well, thank you everyone for all the references. I've figured out the I am doing things backwards, I have the tool Xray, and the 1500 page introductory developers guide. Clearly this is a question for one of the core developers (if its not documented in the developers guide) On Tue, Aug 6, 2013

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Tom Davies
Hi :) Yes, sorry for all the Rtfm answers!  Prolly is best to ask on devs lists as they might have more idea of what you are doing.  There are a few here that seemed to understand but it was all waaay beyond me.  Regards from Tom :)  From: Jason White