Search results

  1. M

    Keep form from closing

    I have a form that has some fields with validation rules, which are Not Is Null. I have a private function to validate records (here is a snipet) Private Function ValidateRecord() As Boolean ValidateRecord = False Select Case Outcome Case "Interpretation" If IsNull(Me.[Date...
  2. M

    Form_BeforeUpdate(Cancel As Integer)

    Hello, I have this code If IsNull(Me.Providers) Then Cancel = True MsgBox "Enter a Provider!" End If in the beforeupdate event. I don't think it is working properly because it is a combo box, as I have the exact same code for a textbox that works fine. Even if I choose a name from...
  3. M

    change required property in vba

    Hello, I have a form that has some controls whose properties are already listed as required in the table. However, it also has a combo box labeled "Outcome" that changes what textboxes are enabled depending on what is chosen in that combobox. What I would like to do, is make sure that whatever...
  4. M

    recordset error

    I am trying to add a recordset to my button to see if a client exists. A client exists in the table Clients if all three fields (First Name, Last Name and DOB) are identical to what the user is typing into the text boxes (named the same) to add a client. My recordset comes up with the error...
  5. M

    form button and error handling

    Hello, I have a few questions that tie in together. I have a Main form, that when I click a button, a new Client form opens. On the Client form, I have 3 text boxes that users use to create a new client, first name, last name, and date of birth. I also have 2 invisible text boxes named Client...
  6. M

    Filter listbox via 2 text boxes

    Hello, I am really new to Access, so I don't know much about coding except what I have read in a coding for dummies book ;D I have also tried to google this but can't get what I have found to work. I have a listbox where the rowsource is a SQL statement. I didn't know if I should try that or...
  7. M

    Please Help with Coding!

    Hello. I am very new to Access (just opened the program for the first time on 5/21/14). I am creating a project for work, which is coming along pretty well. I am stuck though on populating form1 from form2 after selecting an item in a listbox as well as getting the listbox to filter correctly. I...
Back
Top Bottom