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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jimmperry

  1. jimmperry

    ODBC error, column has value exceeding max length?

    Im not sure what I can do to solve this problem. I dont think any values in my column exceed 40 characters, but I cant get rid of this error. Any ideas?
  2. jimmperry

    Left join limitation

    value exceeding its mas length error.I dont understand why Im getting this error when all info in this field is under 16 characters in the sting. Any ideas?
  3. jimmperry

    removing cetain data from report

    Yes...I got it. Thanks alot
  4. jimmperry

    Win 2000 Prof. install

    Thanks all, I got it. You all work wonders!!
  5. jimmperry

    removing cetain data from report

    I have a report that list all members in my company. It list the pesonal within departments. However, some people are not in a department and their name shows up in the begining of the report. I want to remove all personal that do not belong to a department. Any ideas?
  6. jimmperry

    Win 2000 Prof. install

    I Installed Windows 2000 upgrade professional over Windows NT. Everything worked fine for about 5 days. All of the sudden I get a inaccessible boot device error. I wanted to try and reinstall Windows, but I cant get the machine to boot off the CD drive. I took out the hard drive and reinstalled...
  7. jimmperry

    phone number field, convert to set format?

    This was great guys, thanks for the fast response. I got it and Im outa here!
  8. jimmperry

    phone number field, convert to set format?

    I have a field with phone numbers in it. Howerver, some numbers are 4 digits(xxxx), some 7 (xxxxxxx) and others 10 (xxxxxxxxxx). I would like to put parenthesis around the numbers that have area codes, and dashes (-) between the other goups of numbers (I.E. xxx-xxxx). Any ideas?

Part and Inventory Search

Back
Top