Recent content by adamides

  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

    OK, I got it to run basically some fields were required in the other table and I fixed that. Now my problem is that I want to call a query from a form and when the user enters the KiddingDate to append that value in another table, also. How can I do that? How can I specify only the specific form...
  4. 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...
  5. A

    DateDiff

    Thanks for the replies but I still did not figure it out. I have two tables Performance and Matings. In Performance I have a field GestationLenght which basically I want to have the difference (in days) between mating and birth. The matingdate is in the Matings tables and the birthdate is in the...
  6. 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?
  7. 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...
  8. 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? '-----...
See more
Back
Top Bottom