(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Mass update. (Read 329 times)
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Mass update.
Aug 28th, 2007 at 10:15am
Print Post Print Post  
I have a subform, with some Mass update code within it,

If @Date <= Date Due Out then Status ="On Schedule"
Else {
If @Date >Date Due Out then Status = "Over Due"
}

I would like this code, to run each time the subform opens.


Thanks

Drastixnz
  
Back to top
WWW WWW  
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: Mass update.
Reply #1 - Aug 28th, 2007 at 6:19pm
Print Post Print Post  
Put the code in the subform, Status element, OnFormEntry

This assumes that the elements in the program are on the subform.
  


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
 
Page Index Toggle Pages: 1
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