Get TextBox Value in Libre BASE

Keyboard macros or custom scripts

Get TextBox Value in Libre BASE

Postby cplmckenzie » Sat Jul 22, 2017 12:48 am

Hello All,

I have a question or 3 about getting the string value of a textbox on a BASE form.

I have been searching this formum for a couple of weeks now for the answer.

I see many references to "This is how it is done....."

oForm = ThisComponent.DrawPage.Forms.GetByName("myFormName")
oControl = oForm.GetByName("myControlName") to reference the Control object
oForm.GetByName("myControlName").Text


But in all these references given... None shows the Additional calls and Dim's that need to be made.

So my question is....Can anyone point me to a complete Sub procedure that shows (step by step) how to get the value
of a textbox.string value.

Any help is greatly appreciated.

cplmckenzie
LibreOffice 5.3 on Linux Ubuntu
cplmckenzie
 
Posts: 2
Joined: Mon Jul 03, 2017 10:23 pm

Re: Get TextBox Value in Libre BASE

Postby Mr.Dandy » Sat Jul 22, 2017 9:24 pm

It depends on what is your form.
So, provide a sample ODB.
OpenOffice 4.1.3 - Windows 7
User avatar
Mr.Dandy
 
Posts: 264
Joined: Tue Dec 11, 2012 4:22 pm

Re: Get TextBox Value in Libre BASE

Postby cplmckenzie » Sat Jul 22, 2017 11:24 pm

Well, I have a form in BASE named "StartUp". On that form is textbox named "tbSwarmNum" with a value in it. I would like to get that value and assign it to a variable that can be used in an SQL query to access a table for record retrieval.

As soon as I figure how to up load I will upload a copy of my attempts.

Thanks

cplmckenzie
LibreOffice 5.3 on Linux Ubuntu
cplmckenzie
 
Posts: 2
Joined: Mon Jul 03, 2017 10:23 pm

Re: Get TextBox Value in Libre BASE

Postby robleyd » Sun Jul 23, 2017 10:39 am

[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1199
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to OpenOffice Basic, Python, BeanShell, JavaScript

Who is online

Users browsing this forum: No registered users and 3 guests