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 bkrike 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: ibjolley
  • Content: Threads
  • Order by date
  1. ibjolley

    update new field with sequential number

    I have a 100k record table in Access 2002 with a new field which needs to be updated with a sequential number. Basically, I need to insert the rownum into this new field. I do not want to do this manually. I'm hoping for an update query or script to do this. Any ideas? Thanks in advance! -Andrew
  2. ibjolley

    Pegged processor

    The processor on my Win 2k laptop is completely pegged at 100% at start up sometimes. It appears to be random, but about half the time I boot up, my processor is floored. The work-around is to simply reboot. This works almost every time. I have checked all Startup folders as well as the run key...
  3. ibjolley

    Update subquery error

    Hello everyone. I know this has been discussed previously, but I'm have having issues with the following update statement: UPDATE CPES_AllItems SET ItemTypeID = (SELECT basicinfo.BasicInfoItemtypeID FROM basicinfo, CPES_Allitems WHERE basicinfo.basicinfoid =...

Part and Inventory Search

Back
Top