Search results

  1. C

    Findfirst w/ date field

    I am trying to match several fields from one table to another table with findfirst. I can see that the data is correct, but a match is not found. I think this is because the last of the 3 concantenated fields is a date field. Is it possible to use findfirst w/ a date criteria to find a match...
  2. C

    Problem Updating Table

    I could sure use some help! This code will write new records to the table, but when it encounters a record already in the file, the .nomatch statement has a "true" value so that when the .Update statement is run an error is displayed telling me that a duplicate key (SHIPTO and PARTNO) is not...
  3. C

    Problem Updating Table

    I could sure use some help! This code will write new records to the table, but when it encounters a record already in the file, the .nomatch statement has a "true" value so that when the .Update statement is run an error is displayed telling me that a duplicate key (SHIPTO and PARTNO) is not...
  4. C

    combo box w/ subform

    I am new to Access... I have a form which consists of 1) a combo box (field is the key to the single table in the db); and 2) a subform which displays fields w/in the table. It does what it is supposed to do -- which is to display the fields of the selected key -- except that when it is exited...
Back
Top Bottom