Search results

  1. O

    Using VBA to check for Multiple Blank fields in a form

    I've provided the full code my form is based on, and figured out how to copy the code into the post so it didn't push it all to the left :). I was wondering if there's a way to apply this code to the 'on-click' command rather than the 'before-update' command. I basically want my users to fill in...
  2. O

    Using VBA to check for Multiple Blank fields in a form

    Here is my 'add' form's entire code module. I am thinking it has to do with the last bit of code which actually commits the record being added. any ideas? Option Compare Database ------------------------------------------------------------------------------------------ Private Sub...
  3. O

    Using VBA to check for Multiple Blank fields in a form

    Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control Dim strMsg As String 'Loop through every control on the form -------------------------------- For Each ctrl In Me.Controls 'Look for a Particular Tag If ctrl.Tag = "BlkChk" Then 'Create a List of empty questions...
  4. O

    Using VBA to check for Multiple Blank fields in a form

    Hey all, I am Fairly new to this forum, as well as VBA. I love the code discussed in the thread and I am currently implementing it into my form. However, when I do so, I am getting an error where: it will specify the records that are blank, and upon clicking the vbOK button, will then state...
Back
Top Bottom