Search results

  1. B

    Delete confirmation dialog box

    Hi, Is there a way in a form's BeforeDelConfirm or AfterDelConfirm event to detect the response to the confirmation dialog box Access displays when a user deletes a record? I'd like to force a subform to requery if "yes" is chosen in the dialog box. Thanks!
  2. B

    Append query in VBA gets key violation

    Hi I'm trying to run an "insert into" query as a before update event in a form. The code is the following: DoCmd.RunSQL "INSERT INTO tblProjectEntityLocation ( ProjectEntityID, EntityLocationID ) VALUES (" & Me![txtProjectEntityID] & "," & y & ");" I get a key violation error when this...
  3. B

    For Each Loop and Locking Problem

    Hi, this is the first question I've posted. If I'm not using the right forum, please let me know. I've created a For Each loop in the before update event of a subform to check whether any text box in the detail section contains data. If at least one text box is not null or empty, the record is...
  4. B

    Greetings from sunny Massachusetts!

    Hi, All! I'm a new member, but a long time user of this site. I've been using Access on and off for years, but have never become proficient at programming. You're my primary source of help whenever I'm stuck, and this forum has saved me many times. Thanks!
Back
Top Bottom