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!

Recent content by bigtbone

  1. bigtbone

    How to separate an address field into three fields access query

    I have received an access 2000 database that has a table with the city, state and zip in one field. I need to break the field up into a separate fields for city, state and zip using a query. The data is not consistant. Here are examples of the data I have. I understand I may have to manually...
  2. bigtbone

    How to parse name field into first,middle,last and suffix fields

    How am I supposed to use the code in the FAQ in access?
  3. bigtbone

    How to parse name field into first,middle,last and suffix fields

    I have an imported table with several thousand records into an ms access database that has a table with only fullname in it. I need to build a new table using a make table query that separates fullname into first name, middle initial, last name, and suffix. Here is what I have and need: Full...
  4. bigtbone

    Help! Object Invalid or No Longer Set Error

    I just converted to Access 2000 from 97 and I can't some queries to run. I get "Object Invalid or No Longer Set" error. It appears to be a problem with DAO and ADO settings. I'm not sure what I need to do to get it to run in 2000, worked perfectly in 97. I have a table that is...
See more

Part and Inventory Search

Back
Top