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 TouchToneTommy 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. 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...

Part and Inventory Search

Back
Top