Search results

  1. A

    error message

    Hello, I have the following code in a form with a dropdown menu -- Private Sub Combo0_AfterUpdate() Dim stDocName As String Dim stLinkCriteria As String stDocName = "MaleFrm" stLinkCriteria = "[MaleAnimalCode]=" & Me![Combo0] DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub -- When I run...
  2. A

    data to tables

    When filling a form, can the entered data be stored in more than one tables? How?
  3. A

    insert query

    I have the following query: -- INSERT INTO GoatPerformance ( FemaleAnimalCode ) SELECT FemaleAnimalCode FROM Matings; -- it does not insert the values of FemaleAnimalCode from Matings to GoatPerformance. It gives me the following error message: "Farm Management set 0 fields to Null due to a type...
  4. A

    DateDiff

    I want to calculate the difference between two date which are stored in two different tables and have the result shown in a form text-field. I tried using the DateDiff function with no success - errors missing operands or operator etc. Can anybody help?
  5. A

    Retrieving data from table(s)

    I have two tables A and B, and I want to create a form where, using a combo box to select a value from a field in table A and then, using that value, to display in text box, values from a field in Table B that match the values of Table A. Example: Select the date from Table A and display in a...
  6. A

    OpenForm problem

    Hello, I have the following piece of code where basically I am trying to choose from a combo box a value and based on that open the corresponding form to fill in other data. The errormessage is as follows: Run-Time Error 2501 the OpenForm action was cancelled. Can anyone help please? '-----...
Back
Top Bottom