(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Running Total for subform lines
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 2 [3]  Send Topic Send Topic Print Print
Very Hot Topic (More than 25 Replies) Running Total for subform lines (Read 4383 times)
charliebrown
Junior Member
Members
**
Offline


Beware...novice at large

Posts: 97
Location: Sacramento, CA
Joined: Apr 19th, 2006
Re: Running Total for subform lines
Reply #30 - Mar 16th, 2007 at 3:32pm
Print Post Print Post  
Hammer wrote on Mar 14th, 2007 at 5:52pm:
charliebrown wrote on Mar 14th, 2007 at 5:33pm:
This is the line I was trying to add to my above code:

TotalRepairs \#$#,#0.00

Is there something I'm missing?


The line you show above will do something if you enter it as a switch in a mergefield in a Microsoft Word document. Sesame, however, considers it to be gobbledygook! (That's the technical term.)

Get rid of that line and just format your element as Money with 2 decimal places.


In my last post, everything runs fine...what I must have not figured out is when I add a NEW repair record, do I have to do a mass update every time in order for the "RepairTotal" to re-calculate?...or can something be placed in the Global Code that will do that automatically?

Thanks again Erika...I'll get better at programming...or else! Smiley
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Running Total for subform lines
Reply #31 - Mar 16th, 2007 at 5:26pm
Print Post Print Post  
Use an element (the element that you are totaling is probably best) in the subform to call the subroutine that is in global code.  Call subroutine from On Element Exit/Change, or OnFormExit.  Do not need to do a Mass Update.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
charliebrown
Junior Member
Members
**
Offline


Beware...novice at large

Posts: 97
Location: Sacramento, CA
Joined: Apr 19th, 2006
Re: Running Total for subform lines
Reply #32 - Mar 16th, 2007 at 6:06pm
Print Post Print Post  
Bob_Hansen wrote on Mar 16th, 2007 at 5:26pm:
Use an element (the element that you are totaling is probably best) in the subform to call the subroutine that is in global code.  Call subroutine from On Element Exit/Change, or OnFormExit.  Do not need to do a Mass Update.  



I'm on it...thank you again Robert.  I need to take a 90 day leave of absence just to concentrate on Sesame...I do love this program...the possibilites are virtually endless.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Running Total for subform lines
Reply #33 - Mar 16th, 2007 at 9:24pm
Print Post Print Post  
Quote:
I'm on it...thank you again Robert.


Bob Hansen says you are welcome.
Robert (Scott) also deserves thanks too, along with Erika , Ben, CapitalG, (got em all?)

Quite a resemblance between you and Robert Scott, are you twins?
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
charliebrown
Junior Member
Members
**
Offline


Beware...novice at large

Posts: 97
Location: Sacramento, CA
Joined: Apr 19th, 2006
Re: Running Total for subform lines
Reply #34 - Mar 16th, 2007 at 10:50pm
Print Post Print Post  
Bob_Hansen wrote on Mar 16th, 2007 at 9:24pm:
Quote:
I'm on it...thank you again Robert.


Bob Hansen says you are welcome.
Robert (Scott) also deserves thanks too, along with Erika , Ben, CapitalG, (got em all?)

Quite a resemblance between you and Robert Scott, are you twins?



How could I possibly get you two mixed up?...I'm just sitting here editing code, replying to emails, Nextel 2-way in one hand, land line in the other...Tongue...Sorry Robert...

Thanks Bob!!! Smiley)))))))))))))))
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1 2 [3] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge