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 Mike Lewis 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. wutang26

    insert

    I get this now String or binary data would be truncated The statement has been terminated Any suggestions
  2. wutang26

    insert

    yes, I concatenate them. and placing that value in index column
  3. wutang26

    insert

    did not work. pidm key is numeric term_code_ket varchar crn_key varchar. index varchar in access it works great
  4. wutang26

    insert

    this is where I think the problem is but I'm not sure how to fix it AS_STUDENT_REGISTRATION_DETAIL.[PIDM_KEY] & [TERM_CODE_KEY] & [CRN_KEY] AS INDEX1
  5. wutang26

    insert

    I made those changes but I get an error still. Invalid operator for data type. Operator equals boolean AND, type equals numeric
  6. wutang26

    insert

    no luck
  7. wutang26

    insert

    I get an error with my script: saying: Invalid Column name 'Y' Invalid column name '200710' Does someone know why this is any help would be appreciated. INSERT INTO eval_master ( PIDM, REGISTERED_IND, RSTS_CODE, TERM, RSTS_DESC, TERM_DESC, CRN, [LAST], DEGC_DESC, MAJR_DESC1, SSN...
  8. wutang26

    update table

    I'm trying to update a table from another table. here is my code I get an error saying Incorrect syntax nera the keyword 'INNER' any suggestion would be appreciated UPDATE eval_master INNER JOIN dbo_AS_STUDENT_REGISTRATION_DETAIL ON (eval_master.PIDM =...
  9. wutang26

    string parapraph

    I'm creating this string and its like a paragraph but for some reason I can't create a new line in it. I tried using the <BR> but I can't get it to work. Can some please help me with this any help is appreciated here is my code objEmail.TextBody = "Professor:" & lastname & "," & firstname &...

Part and Inventory Search

Back
Top