Search results

  1. V

    If vs If Not (One works the other doesn't)

    Why don't both of these pieces of code work, when I enter No into the combo box? :banghead: This code works. If Me.ComboBillable = "Yes" Or Me.ComboBillable = "No" Then Else MsgBox "You must choose an Appropriate Billing Option" Me.ComboBillable.BorderColor = RGB(255, 0, 0)...
  2. V

    Query Criteria -- iif Function

    I want the Query Criteria to pull its value from a control on a form. The form control either has data or is null. (My problems occur when the form control is Null) The field in the table either has data, is null or is blank. This is what im trying to get to work...
  3. V

    Adding an Attachment Error '3251' Operation is not Supported for this Data Type of Ob

    I'm trying to add an attachment to a field "SDS" in my table "ChemicalLibrary" When I'm adding a completely new record to the table it works perfectly (the first half of the code below). My problem arises when I'm trying to update a record in the table and add an attachment. Below I'm trying to...
Top Bottom