Recent content by Cam D

  1. C

    searching for things of the same name

    is it possible for me to use an update query to find things of the same name, as i would like to use it to update the "current stock" field by finding out how many movies of the same name there are finding the and takintg that number away from the "in stock" field then using that as the data for...
  2. C

    how do you multiply fields

    i would like to know how to multiply fields well more to the point i would like to know why this sum comes up with the wrong answer i'm using an update query [in stock]-[current stock]*[overdue cost] for the first record it the sum would be 10-7*£5.00 which should equal £15.00 but instead it...
  3. C

    using multiple tables for mail merge

    is it possible to use multiple in mail merge ie. using forename from member details and also having vid name from video details.
  4. C

    Compile Error

    english is my native language, the reason i didn't post long sentences is because it wasn't required, i only posted what was needed. anyway this is my database open the "member details" form and click on the button that says "save and exit" and the error should appear.
  5. C

    Compile Error

    the code was pre-made when i created the relationship the error appeared when i tried to use a button i made on a form.
  6. C

    Compile Error

    the whole code was allrelationships=onetomany but the highlighjted code was just onetomany
  7. C

    Compile Error

    my problem is that when i try to make a button it comes up with the same error messages as the OP then when i use the button it closes the form and opens VBA but with relationships it highlights onetomany.
  8. C

    Invalid Field Definition - Unable to set up cascade update

    My database won't work when i try to make a relationship between 2 tables not only does it come up with that it is a one-one relationship but it also comes up with the error message "invalid field definition "vid ID" in definition of field or relationship" i do not understand what this means or...
Top Bottom