ldebondt

Willie's dead!!! The Texas flag will forever fly at half-staff...

I would suggest go to Russ Baker's - "Handy Bits" and download attachment. Russ has given many excellent examples of change font colors along with other examples.

Great work Russ.

Restructured as a Case statement and works fine.

I am getting the following error when trying to do a calculation in a field. Can anybody explain what this means? FILEMAKER PRO caused an invalid page fault in module FMFC10.DLL at 017f:006ed28e. Registers: EAX=00000070 CS=017f EIP=006ed28e EFLGS=00010202 EBX=5f401901 SS=0187 ESP=009ab9c8 EBP=009aba3c ECX=00fee9f4 DS=0187 ESI=00fec2f0 FS=67f7 EDX=00fec2f0 ES=0187 EDI=bff555a7 GS=0000 Bytes at CS:EIP: 3b 50 04 74 09 8b 00 85 c0 75 f5 c2 04 00 50 ff Stack dump: 006fccfe 00fec2f0 bff555a7 00fec2f0 00fec2f0 00fec2f0 009abab0 007051ce 00000001 006fcca2 00fec2f0 5f4019fa 006fcd5b 00000001 5f4056c7 00fec2f0 The calculation is a Case/If Statement: Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B25 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B25 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B22 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B22 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B20 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B20 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B18 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B18 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B16 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B16 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B14 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B14 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B12 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B12 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B10 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B10 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B07 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B07 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B05 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B05 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B03 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B03 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") + Case(Benefit = "Non-Benefit" , "" , If(not IsEmpty(B01 Time Sheet) and VacationCalculation <2 , (7 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) , If(not IsEmpty(B01 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") Could it be that this is just to busy for FileMaker to handle in one field???

Andy, Was unable to open attachment. Is this a file strictly for MAC?? Could you include as a ZIP file? Thanks,

In a thread from another forum Russ Baker and CobaltSky discuss how to use leading zeros. Go here... http://www.maclane.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=20;t=000196

If you use numbers to sort items you have to use leading zeros. This way a sort would produce -- 01, 02, 03, 04, etc... Depending on the number of items to sort you may want to use two leading zeros.

Thanks for including the tips --- Sounds exactly what I'm wanting. Will play around with it later today.

Operating system - Windows. Is there a way to script the "x" (close window). I have many related files to a main window. Would like to be able to script the "x" on main window, if user clicks on "x" that all files close. I do not want users to access directly to related files. Currently have related files opened minimized. Does this make any sense???

Shift + "LeftClick" will also clear a radio button so that no entry has been made.

JMO has a tip for this on his web page: databasepros.com The tip is titled "NewRows". I'm assuming you want users to be able to create new related records. I think this tip is what you are looking for. NewRows.zip

Yes, both relationships "allow creation of related records".

Have Parent file (Faculty) pulling info via portal from Child file (Commitments). Parent file has two (2) portals - one portal for Commitment Amounts using relationship "commitments" key field ID# and one portal for Expenditures using relationship "commitments paid" key field ID#. Both portals allow entry in related file. All data entry is into Parent file. My problem is when I create a new entry in "commitments" portal a blank portal row is placed in "commitments paid" and vice-versa. Is there a way to correct this. I don't want blank portal rows created in the other portal. Could this be due to using the same Child file?:?

Guess Windows doesn't allow for text wrap in this situation. Have you tried to use a "carriage return" to put cut-off text on next line of error message???

Found the following calc to be quite useful from JMO: Involves two fields: (a) Phone Number ( Phone Filter Field (: is transparent and overlayed field (a). No entry allowed on field (: also take out of tab order. "(" & Left(Abs(TextToNum(Phone Number)),3) & ") " & Middle(Abs(TextToNum(Phone Number)),4,3) & "-" & Right(Abs(TextToNum(Phone Number)),4) Users type 8001234567 and (800) 123-4567 is displayed. Will always display leading zeros.

How can this be converted to show 0800 as "8:00 am" or 1435 as "2:35 pm"

May be way off base...but what about using a Case statement to determine which "Help" to use??? This would be only one script that could be used on all fields.

Not exactly what I was looking for but points the mind in a different direction...thanks.

I have a layout with 2 different portals. In portal "A" I want to select specific row to show information in portal "B". I can get this to happen however the row in portal "A" that I select should remain hightlighted. Have seen post in the past covering this but am unable to locate. Any help would be appreciated...

Think a "summary" field would do the trick. When defined you are given the option to have a "running balance"...

No button next to field. When you select the "year" it goes to that years layout (uses the "IF" statement to determine which layout) and performs the sub-script.

I have a field "zBIO Fac" that is formated as a drop down menu. User has option of 4 fiscal years. The user selects "2002" and a script is automatically run. Goto Field (Select/perform, "zBIO Fac") Pause/Resume Script ("0:00:01") If ("zBIO Fac = "2002"") Goto Layout ("Fac 02 Rpt") Perform Script (Sub-Scripts, "Bio Fac 02") Else If( "zBIO Fac = "2003"") Goto Layout ("Fac 03 Rpt") Perform Script (Sub-Scripts, "Bio Fac 02") End If

If you use auto-enter "select sport" - you select "sport" and field now shows "baseball", "football", "whatever". Suppose you want to clear that field - should "select sport" reappear? Maybe I didn't do correctly because now all that shows is a blank field.