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 wOOdy-Soft 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: ncook12
  • Content: Threads
  • Order by date
  1. ncook12

    Convert Dates

    Can someone help me on this. I have some raw date in a csv format that I import into Access. The raw data has a dat format of MM/DD/YYYY hh:mm:ss but the field can not be specified as a date. When i import to access I have an update query that removes the extra information so that I can specifi...
  2. ncook12

    Performance Monitoring

    I have set up performance monitors on our windows 2000 servers, but when I open the log file (.csv)the date and time filed has an extra three digits... 02/18/2004 10:29:18.968 so i can not import the data into Access because it will not recognise the format. Does anyone know how to stop this or...
  3. ncook12

    Scatter Brain!

    I have had problems with a particular spreadsheet i have been developing using VBA. I have had lots of help. I was advised to go to Insert>Name>Define to name the title of the column. Then in 'refer to' i was given a line of code to enter - but i can't find it anywhere. It was because the range...
  4. ncook12

    Setting limits and changing text colour if limit is exceeded

    I have set up a spreadsheet which has lots of VBA code mainly because the data set is dynamic. I have got a calculation called Average at the end of each column. I want to set in that formula that if a limit is exceed or falls below a certain number that the text in the field changes colour. I...

Part and Inventory Search

Back
Top