Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Question Unanswered: Insert values query - No result

    Hi Everyone,

    I'm tweaking one of the applications on MS Access 2000. In VBA I'm creating SQL statement:

    INSERT INTO tbl_Temp values ('TT10-120100400003', '10/12/04', 'Inventory', "1.5'x10'", '', 180., 12, '', 120, 15)

    Run VB code, no error messages, no data in the table.
    Run sql statement in query window - no errors, no data. column count is ok. no restrictions on the table, no primary keys, table has only text fields. Original apps has no problem running code. The only changes that were made are added columns in the table and accordingly in the sql statement.

    I'm at the end of my wit here, so any ideas will be greatly appreciated.

    Thank you,
    Tanya.

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    You may want to publish your table design. That will us to see what you may be overlooking.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •