Search results

  1. C

    Findfirst w/ date field

    Wayne, That's perfect! Thank you very much. This is a great site for access support and you are one of the reason's why.
  2. C

    Findfirst w/ date field

    Thanks for the reply ScottN, Here are the statements: sSQL2 = "DEPARTMENT = " & Chr$(34) & rstTemp!Department & Chr$(34) & " And PARTNUMBER = " & Chr$(34) & rstTemp!PartNumber & Chr$(34) & " And ShipDate = " & Chr$(34) & rstTemp!shipdate & Chr$(34) rstArchive.FindFirst sSQL2 I have placed...
  3. 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...
  4. C

    Problem Updating Table

    I didn't get much interest in my problem, but since I found the solution, I thought I'd post it for someone else who may be looking for a solution to a similar problem. The sSQL2= statement works if it looks like this: sSQL2 = "SHIPTO = " & Chr$(34) & SV_Shipto & Chr$(34) & " AND PARTNO = " &...
  5. C

    Problem Updating Table

    Thanks for responding Jack. This code is run from a form button the purpose of which is simply to update the Dock table with new data -- either to add new Dock info, or update an existing record. Could you be more explicit concerning the need to do field or control validation. I don't know...
  6. 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...
  7. 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...
  8. 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