Syntax for retrieving textbox value

Creating and using forms

Syntax for retrieving textbox value

Postby weaverman55 » Sat Mar 02, 2019 2:36 am

I have a table set up with entry for Amount set at decimal.
I have a textbox (Amount) on a form set up for a dollar amount entry, what is the correct syntax to retrieve the value that was entered to use in a Macro?
I have very very limited coding experience.
OpenOffice 4.1.6
OS X 10.14.3
Posts: 5
Joined: Fri Mar 01, 2019 1:20 am

Re: Syntax for retrieving textbox value

Postby RPG » Sat Mar 02, 2019 1:10 pm

I think you have to forget macro coding and have to start a little study so you can understand the answer of Villeroy. Villeroy did give you a good answer in the other thread which you started.

For forms you have to understand the SQL language. With the SQL language it is much more easy to have the result you want have. It is true you do not get most time the result in the way you want have but this is also not possible with macro's and you can not code. The reason is other people do not your coding.

For working with forms it was for me important to understand that forms are a coding system in combination with SQL code. This is working not working with a lot of little details. There we have not a lot of little details it is not so difficult to learn as macro's.

LibreOffice on openSUSE Leap 15
Posts: 2159
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest