How to set the title on Tabs dynamically (programatically)
Hi, We are using LotusNotes 8.0 and we would like to know how to set the title on the Tabs dynamically i.e. depending on certain conditions. Grateful if somebody can help. Thanks a lot Dheeruj

Answer Question   |  July 15, 2009  6:42 AM
Conditional statements, Lotus development, Lotus Notes 8, LotusScript conditional statements

format cell based on contents using VB
i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 [...]

Answer Question   |  March 29, 2010  10:45 AM
Conditional statements, Excel VBA, VBA, Visual Basic for Applications

Subform based on conditional values?
Is it possible to add a computed subform with a condition based on the value supplied for a textfield at runtime?

Answer Question   |  February 4, 2009  10:20 AM
Conditional statements, Conditional values, Dynamic subform, RunTime, Text field

LotusScript to update or create new record in source database based on request number
How to code in LotusScript to query and collect data in one db based on a request number, if number found in current database, update fields, if request number not found, create new doc the request id.

Answer Question   |  December 22, 2008  9:38 AM
Conditional statements, Lotus development, LotusScript, LotusScript conditional statements

SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I’m trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the column names in [...]

Answer Question   |  November 3, 2009  8:13 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL

To re-populate a ListBox based on a condition
I am using a button(to check and repopulate) and a Listbox(Available options). Initially the Listbox uses Default values to Populate values. Then If the button is clicked; it creates a list of already used options through DBlookup(List2) and there is a list of default values(list1). i use @replace to create a list3 which if explode [...]

Answer Question   |  November 3, 2008  8:04 AM
Conditional statements, Formula Language, ListBox, Lotus development, Lotus Notes

Report -Conditional Format with multiple conditions: Access 2007
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()- 90=greenfont) [...]

Answer Question   |  June 24, 2008  10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access