Syntax for retrieving textbox value

Creating and using forms
Post Reply
weaverman55
Posts: 5
Joined: Fri Mar 01, 2019 1:20 am

Syntax for retrieving textbox value

Post by weaverman55 »

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.
Thanks
OpenOffice 4.1.6
OS X 10.14.3
RPG
Volunteer
Posts: 2250
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Syntax for retrieving textbox value

Post by RPG »

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.

Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Post Reply