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 strongm 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. croix18

    SQL Export

    Yarddy, To get every single field and record from a table use the following SQL: SELECT * FROM table_name (this case Stock_Rec)
  2. croix18

    Numeric Only Fields

    I was wondering, is there a way to tell if a field contains only numeric characters? I have to exclude numeric fields and keep alpha-numeric values for the select statment. I've looked into LIKE and NOT LIKE but do not think they will do the job. I am attempting this at first using Business...
  3. croix18

    Import from Excel Error

    Ok, got it to work on the Importing front, using acSpreadsheetTypeExcel5. Some documentation on what these mean would be GREAT, Microsoft. [mad] However, I still can't get the Excel process to release from RAM. The END method doesn't seem to be working from this forum Excel process still...
  4. croix18

    Import from Excel Error

    Might have missed one now that I'm looking at them, I think it was 4 or 5...going to try them both now, just in case.
  5. croix18

    Import from Excel Error

    Hey Everybody, I'm currently running Access 2002. What I am trying to accomplish is to "pass reporting off" to another person. I'm assuming they know very little of Access/Excel and therefore hope to automate 95% of the process. The problem is they have a report where it will always return...

Part and Inventory Search

Back
Top