Search results for query: *

What a dumb question for me to ask but I wasn't sure if they had changed the .scr or not with XP. Thanks so much.

Does anyone know where these are stored (folder-path) in Windows XP?

Does anyone know if there is a way to pull email back sent via Web Outlook? I'm desparate. Thanks.

Works perfectly. Thank you.

Hi. Currently trying to concatenate several text and date cells but when I finish the date comes out as a number so I need to format in my formula but can't figure out how. Here's my formula: =CONCATENATE("CB:",A5,": ",D5,"") Cell A5 is the date field that needs the formatting around it...

Wow. Thank you so much. Worked like a charm. I really appreciate your help here. Thanks again.

...I have so far is: UPDATE EmpBen LEFT JOIN Eml ON EmpBen.Emp= Eml.Emp Set EmpCov=(Case when Eml.AnnlFrzSal>=50000 then (35000+(Eml.AnnlFrzSal-50000)*.50) Else Eml.AnnlFrzSal*.70 End) Where EmpBen.Ben='BasicLTD 07' AND Eml.EmlEfdDt Is Null The issue seems to be how to join a table in an...

Correct. Thanks for your help and direction.

Hey PHV. I guess I should have told you I'm working on an SQL server in SQL and not JetSQL. Still having probs. Thanks for the quick response though.

...I have so far is: UPDATE EmpBen LEFT JOIN Eml ON EmpBen.Emp= Eml.Emp Set EmpCov=(Case when Eml.AnnlFrzSal>=50000 then (35000+(Eml.AnnlFrzSal-50000)*.50) Else Eml.AnnlFrzSal*.70 End) Where EmpBen.Ben='BasicLTD 07' AND Eml.EmlEfdDt Is Null The issue seems to be how to join a table in an...

...but can't get it to work. Here's what I have so far: Update EmpBen Set EmpCov=(Case when Eml.AnnlFrzSal>=50000 then (35000+(Eml.AnnlFrzSal-50000)*.50) Else Eml.AnnlFrzSal*.70 End) Where EmpBen.Ben='BasicLTD 07' AND EmpBen.Emp In(Select Eml.Emp,Eml.AnnlFrzSal,EmpBen.Ben From Emp left join...

Hi There. This is super basic. I was wondering how to format this statement: If({Organization.Work Status}In["HrlyFT","HrlyPT"]) then "H" Else "S" Won't let me save it. Any ideas and sorry for being so lame.

Hey there. I do appreciate your help but I'm creating a new field in an SQL query called EligDt (eligibility date). Basically if a person is of one status or another I want the case statement to alter their hire date. I'm working with more than one status, hence the need for a nested CASE...

Hi there. Does anyone know the syntax that allows for nested CASE Stmts?

Hi there. I'm currently running Windows XP and I'm trying to reformat my hard drive. I want to wipe everything out and start fresh but when I go to the cmd prompt and type format c it says the volume is still in use. How do I stop all items from using the volume?

Oh thank you. Works perfectly. Thanks again. Excellent!

Hi there. I’m trying to update one field on a sub-form once the value of another field on the same sub-form is selected from a combo box. I wrote a macro using the SetValue command. In the ITEM area of the macro I have: [Forms]![frmDataEntry-Main]![frmEntry Detail Subform].[Form]![IntName]...

Thanks everyone. These suggestions seem to really help.

Yes I've tried that and it didn't seem to make any difference but perhaps I need to reboot. Thanks.

Has anyone notice speed reductions since installing IE 7? It seems to take way long to load than IE 6. If anyone has experienced this is there any current fix? I have a super powerful computer with tons of memory. I also have no viruses, etc. Thanks.