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!

Register Log in
  • Congratulations derfloh 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: timwilliams77
  • Order by date
  1. timwilliams77

    Conditional formatting based on two sets of criteria

    =AND($H2="",$F2=1,$O2="Open") tried it just in cell 2, but it only Applied the formatting to cell 2 so i highighted the whole row and entered the value and thats when i giot the results above Tim
  2. timwilliams77

    Conditional formatting based on two sets of criteria

    sorry to be a pain, I have applied what you said (i think i have done it correctly) however the result is not correct, I have filtred on cells with a red colour and the ones that are red are cells without a 1 in F and one with a value in H Tim
  3. timwilliams77

    Conditional formatting based on two sets of criteria

    sorry still struggling I am highlighting all of column H, then going to the conditional formatting option and then choose new rule and then use a formula to determine which cells to format and then i enter the below, this does nothing =formulais(AND($H$2="",$F$2=1,$O$2="Open"))
  4. timwilliams77

    Conditional formatting based on two sets of criteria

    Hi Geoff Thanks for your response, however where is the formula is option?, and how do I enter it for all rows?
  5. timwilliams77

    Conditional formatting based on two sets of criteria

    Hi i would like to format column H of my worksheet with a RED colour if the cell is blanc, however I also only wish to format it if column F has a value of 1 in it how can this be done? tim
  6. timwilliams77

    Batch File

    It will be each morning, so yes it will be unique and will be the one with yesterdays time stamp
  7. timwilliams77

    Batch File

    I have got it to copy the 2 files and add the date stamp onto the new ones, great.... How do I move the two original files to a different location? set timestamp=%DATE% set timestamp=%timestamp:/=-% copy aviva*ppsx Aviva Programme Daily Defect Statistics %timestamp%.ppsx copy aviva*pptx Aviva...
  8. timwilliams77

    Batch File

    Hi I have tried - cd\users\timw\desktop\trinity local\trinity\projects\admin re\development\alpha\stats and trend This works ok copy aviva*.ppsx This fails saying cannot find file specified
  9. timwilliams77

    Batch File

    Hi I have two files which I require a batch command to carry out the following: 1) Copy both files 2) Move to orignal files 3) Rename to copied files a) File location is users\timw\desktop\trinity local\trinity\projects\admin re\aviva\development\alpha\stats and trend b) files to be copied...
  10. timwilliams77

    only a local connection

    : I have just had a new Acer Desktop PC, it came with a free trial of Macafee Yesterday I decided to uninstall macafee and put my own symantec on, however as macafee was uninstalling the PC shutdown, when it came back up the internet connection only gets a local connection I have tried to reboot...
  11. timwilliams77

    Errors with Norton Ghost

    Hi I have got Norton Ghost 10.0 and Windows Vista When I try and define a new backup I get the following errors in order 1) Cannot retrieve Drive Properties 2) Cannot rescan disks -Info 6C8F1C25: Cannot rescan disks. --Cannot successfully reconcile changes since last session. ---Cannot...
  12. timwilliams77

    3 issues

    Hi there We have just upgraded from 5.5 to 2003, since then we have experienced 3 issues 1) A lower amount of incoming emails, usually each person would get around 100 emails over night, they are now getting between 4 and 15, this is really low as to usual, not sure where they might be going...
  13. timwilliams77

    OWA set up on 2003

    We have recently migrated to exchange 2003, I would like to set up OWA but it only works internally It seems as though I have to make the server a front end server, but it doesnt allow me to do it on this server Can anyone help? Thanks Tim
  14. timwilliams77

    Date Problems with SQL

    SELECT Applicants.FIRST_NAME as Apllicant_First_Name, Applicants.LAST_NAME as Apllicant_Last_Name, Companies.NAME as Company_Name, CVsSent.DATE_SENT as CV_Date_Sent, Requirements.JOB_TITLE, Interviews.DATE_TIME as Interview_Date, Employees.USER_NAME as Employee_User_Name, Interviews.NUM as...
  15. timwilliams77

    Date Problems with SQL

    Thanks ca8msm Can you show me how you would add the getdate() function and to return data for the past 30 days? Tim
  16. timwilliams77

    Date Problems with SQL

    This is the query, I need to run this automatically I want it to get todays date then pull back the data for the past 30 days up to todays date SELECT Applicants.FIRST_NAME as Apllicant_First_Name, Applicants.LAST_NAME as Apllicant_Last_Name, Companies.NAME as Company_Name, CVsSent.DATE_SENT as...
  17. timwilliams77

    Date Problems with SQL

    I am trying to run a query where it looks for todays date and then brings back date for the past 30 days Can any one help? Thanks Tim
  18. timwilliams77

    SQL Query problem

    hi guys i have tried both the above and the query runs but it is still running now it is too big as it is across different tables and has a lot of data, how can i speed it up? Tim
  19. timwilliams77

    SQL Query problem

    Hi I have wrote the following query but i get the error "Syntax error converting datetime from character string." use itrisdb1 select employees.user_name, companies.name, cvssent.date_sent, requirements.job_title, interviews.date_time, applicants.first_name, applicants.last_name...

Part and Inventory Search

Back
Top