Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Scooby62
  • Content: Threads
  • Order by date
  1. Scooby62

    Screen Savers

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

    Web Outlook and Pulling Back Sent Email

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

    Concatenation Involving Dates

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

    Updating using the Set command

    Hi there. I'm having a problem updating a field for everyone in one of my tables. The query 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...
  5. Scooby62

    Update, Set AND Join Query

    Hi there. I'm having a problem updating a field for everyone in one of my tables. The query 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...
  6. Scooby62

    If Statement In Crystal

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

    CASE Statements

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

    Formatting Hard Drive

    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?
  9. Scooby62

    DLOOKUP and Forms

    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]...
  10. Scooby62

    IE 7 and Speed

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

    SASERVICE error message

    Does anyone know what this error message is about or how to fix it. It could also be a virus. Any insight on this would be appreciated. Thank you.
  12. Scooby62

    Auto Reply Setup In Outlook Express - Possible?

    Hey there Everyone. Is it possible to set up an auto reply for my outlook express email account? I want to do this as I'm going on vacation and would like everyone to get an auto reply message. I would also like all my emails during my holiday to go into a vaction folder. That's probably asking...
  13. Scooby62

    How to keep Chart Range Fixed In Excel

    Hi there. I have a situation where on a weekly basis I am updating a data source (spreadsheet) by adding a column on the right side and deleting a column on the left side. This creates a rolling type of chart for dates. Problem is that the chart based upon the data source keeps changing and...
  14. Scooby62

    Dynamically refer to a worksheet name in a formula

    Hi there. I'm currently writing a macro that inserts a column and give it a title 7 days from the title of the last column. I then want to copy the forumlas from the original column and just add 7 days to the sheet reference in the formula. So one formula might be: ='June 9'!I7/'June 9'!H7 and...
  15. Scooby62

    Anyone know how to get rid of MSN Toolbar?

    This is a really pervasive 'virus'. I can't get rid of the MSN Toolbar. Has anyone come up with a method of blowing this thing away? Regular removal techniques are not working. Thanks.
  16. Scooby62

    Backgrounds and Hyperlinks

    Hi There. I'm designing some stationary in for email messages. In Outlook stationary uses the background feature as the main area to reference your images, colours, etc. I want to put a picture as my 'non-repeating' background and also make it a hyperlink so when the person receives my email...
  17. Scooby62

    Hover Buttons & Viewing in Internet Explorer

    Hi Gang. I'm having the weirdest problem. I've used hover buttons in the design of my website working in Microsoft Frontpage. When I upload (FTP) my site to my ISP some people can see the hover buttons and some can't. It seems different computers handle these differently. Is there anyway to...
  18. Scooby62

    IIS and Windows XP Home Edition

    Hi. I just wondered if there is easy way to get IIS working on Windows XP Home Edition. Specific instructions/files/etc would be helpful. Thanks.
  19. Scooby62

    Obtaining old field value based on antother old field value

    Hi there. I have a situation where I want to pull back a person's previous cost centre (department) only if they have had a department transfer. So the logic is something like if person A has a change reason of department transfer go back to the record before this and get me their cost centre...
  20. Scooby62

    Find Weekend Days In A Date Range

    Does anyone know how to find weekend days in a date range. These would be Saturdays and Sundays. I have a date range of July 29/04 to July 29/05 in which I want to deleted data entry for any Saturday or Sunday. If anyone can help I would be ver greatful. Thanks so much.

Part and Inventory Search

Back
Top