Recent content by matttsch

  1. M

    Style question: Sharing code between forms

    I am new to Access programming and was giving the job of cleaning up the code of an old project. In this project, there a lot of forms that provide similar functionality using copy-and-paste coding, which I dislike. What is the normal way to handle such cases in Access? To make things more...
  2. M

    "Key column information is insufficient..." error even with a PK

    Thanks for the links RoyVidar!
  3. M

    "Key column information is insufficient..." error even with a PK

    RoyVidar: Good guess, there is a trigger on the table and adding "SET NOCOUNT ON" in the trigger fixes the problem. The VB codes does not, however. Adding the code without the Requery, causes no error to be displayed, but you still can't navigate away from the current record. Including the...
  4. M

    "Key column information is insufficient..." error even with a PK

    I am using an .adp Access file and I am having trouble editing records through it. My form displays the contains of a table one record at a time. When I try to edit one of the fields of the record, I get the following error after selecting Records>>Refresh or when I try to navigate to the next...
Back
Top Bottom