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 SkipVought 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: *

  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 just tried that and the field will not accept the changes. I have also tried that in the import aswell. It does not accept the changes there either. I have noticied that on previous performance monitor reports that I have created (although on a different server) do not have the...
  3. 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...
  4. 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...
  5. ncook12

    Setting limits and changing text colour if limit is exceeded

    Thankyou both for your help it works. Thankyou.
  6. ncook12

    Setting limits and changing text colour if limit is exceeded

    I haven't been able to get it to work. VBA won't accept the lastrow part. And i have looked around and the only other thing i could find was Lastinrow - which is don't want. IS there anything else i should do? Thankyou
  7. 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...
  8. ncook12

    Hide/collapse space for empty fields in report

    Help! I have got the same problem as what was first posted, i have tried all the responses. The CanGrow function removes the corresponding field labels and i can't get them back. And the CanShrink function does not shrink anything. Nothing changes with it, and i have tried all the properties. Is...

Part and Inventory Search

Back
Top