Search results

  1. C

    Update in form

    I have a form called 'movements', the fields are AnimalID, Eartagnumber, Entered Herd, Restriction Period, Eligible to leave herd) I want to type in the date they entered the herd and the restriction period and i want the Eligible to leave herd field to update automatically?
  2. C

    Button

    I want to create a button on my main menu which will allow the user to switch back to the database window?
  3. C

    Form Open

    I would like to know how to get my main form to show automatically on startup? its called "Main Switchboard" any ideas?
  4. C

    Command button wizard

    In office XP, when i go 2 design my forms and i want to put a command button in, i want the wizard to run and enable me to add reports etc but now instead i have to create a macro to open a report because i dont know the code. any1 know how to enable the wizard?
  5. C

    Access Database

    Anyone want to take a look at my database and give me some ideas for what to do on it or you can work a bit on it for i am lost with all my queries etc.
  6. C

    Append Query

    I have two tables which i want to use in my query. tbl_herd (AnimalID, EarTagNumber, EarofTagging, Colour, Breed, Sex, DOB, Deceased, Status) tbl_deceased/moved (AnimalID, EarTagNumber, EarofTagging, Colour, Breed, Sex, DOB, Deceased, Status) I want my query to search through table herd and...
  7. C

    Query on Switchboard

    I wish to be able to add one of my queries to the switchboard and simply click on a command button and it will run, i did it last year so i know its possible i just cant remember how to do it?
  8. C

    Problem opening .mdb

    when i go to open my database from a floppy disk it says 'network or disk error' any help?
  9. C

    Update Query

    in my table 'tbl_herd' it stores records for each animal in a herd. each animal has an Animal ID and Animal Ear Tag Number, it also has a mother and each mother has a DAM ID and a DAM ear Tag Number, every mother also has a record in this table. i want to build a query that will by looking at...
  10. C

    Make-Table Query

    I have a main table: Tbl_herd (Ear_tagNumber, Breed, Sex, DOB, DAM's Ear Tag Number, Deceased) DAM=Mother Each mother has a record in this table as well. I want the query to search through allthe DAM's and from this, search through all the Ear-Tag Numbers and pull out their record, so at the...
  11. C

    Query Problem

    I have two tables; Tbl_herd Tbl_dams (dams=mother of animals) tbl_herd(EarTagNumber,Breed,Colour,DOB,Dam's EarTagNumber) tbl_dams(EarTagNumber,Breed,Colour,DOB) In my tbl_herd i enter all information regarding a new born animal, this includes its mothers eartag number which i use to identify...
  12. C

    Query (Date)

    I have posted this before and have got help with it before but it wasnt what i wanted. I have a table with information with animals tbl_herd (EarTagNumber,DateofBirth,Sex,EarofTagging,Deceased) I now want a query to extract all the animals in this table which are older than 18 months, can...
  13. C

    Date Query

    I would like to know how to create a query which will allow me to select people who are over 18months old on the current date.
Back
Top Bottom