OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[Solved] Help! Field calculation with Macro Basic code

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
master-plan
General User
General User


Joined: 29 Mar 2012
Posts: 8

PostPosted: Thu Mar 29, 2012 9:28 am    Post subject: [Solved] Help! Field calculation with Macro Basic code Reply with quote

Hi all,

I've started using LibreOffice a couple of months back and have some intermediate knowledge of MS Access.

I've been scratching my head for a few hours already and in desperation I'm submitting this post. (I've searched around but can't find an answer... though I'm sure someone must have posted a similar question before).

So here it goes:

How can a field be recalculated in a *form* after a record change?

For example, if we have

FIELD_01 = 10
FIELD_02 = 2 (update record)

then (after record update) FIELD_03 = FIELD_01 * FIELD_02

In access this sort of thing (maybe in an incorrectly structured way) was easy to do. But still struggling with LibreOffice...

*Note:* I'm aware that calculations should be done on a Table/ Query level, but what if it's something very complex and it needs to be done via a Macro in Basic and within the Form?

Any help much appreciated. Thanks in advance.


Last edited by master-plan on Mon Apr 30, 2012 11:04 pm; edited 1 time in total
Back to top
View user's profile Send private message
master-plan
General User
General User


Joined: 29 Mar 2012
Posts: 8

PostPosted: Mon Apr 30, 2012 10:08 pm    Post subject: Reply with quote

Solved. See my other post:

"Macro- Form, copy one record field to another table [Solved]"
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group