Conditional Statements Questions and Answers

Recent IT Questions

1 - 7 of 7
<<PREVIOUS 1 NEXT>>

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

asked by Dheeruj

  5 pts.

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 variables i need a script or other that...

View Answer   |  Jul 14 2009  10:45 AM GMT
VBA, Excel VBA, Conditional statements
asked by Voicetec

  15 pts.

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?

asked by Jomypgeorge

  5 pts.

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.

asked by KTTeam

  5 pts.

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...

View Answer   |  Dec 4 2008  8:13 AM GMT
SQL, JOIN statement, Conditional statements
asked by Bchat

  5 pts.

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...

View Answer   |  Oct 31 2008  8:04 AM GMT
Lotus Notes, Lotus development, ListBox
asked by ServGuy

  20 pts.

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...

Answer Question   |  Jun 24 2008  10:39 AM GMT
Database, Microsoft Access, Access
asked by Nichalos82

  5 pts.

1 - 7 of 7
<<PREVIOUS 1 NEXT>>