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

    Text field size defaults to 255

    In Access 2000 I am doing the following: 1) Running 3 separate select queries that pull different records from one table. 2) Running a union query to combine the results of #1 3) Running a make table query to transform #2 into a real table, not just a query. The text fields in the resulting...
  2. TheStateRuled

    Error message: Field will not fit in record

    Thanks to WildHare for suggesting I check my record length. A query I was running, that combined fields from two tables, was setting all my text fields to 255 characters in length. Truncating them to their appropriate sizes allowed the table to export correctly. Thanks again, TSR
  3. TheStateRuled

    Error message: Field will not fit in record

    I'm trying to export an Access 2000 table (30 fields by 30,000 records) to dBase IV format. I receive the error message "Field will not fit in record". I have checked to make sure that no field names begin with numbers, and that no field names will be identical if the dBase format...

Part and Inventory Search

Back
Top