Search results

Is the relationship between the pairing's hard to work out. I just entered what i thought was right. One problem I just noticed is that the date i pass into GetSeason(Year(Date)) comes back as 1905. Should i format the date to YYMMDD instead of ours DDMMYYY.

@MajP: I studied it a little and like what you done. You have explained it well. I have done a new pairing and seems ok.:) @isladogs and Uncle Gizmo: if MajP is helping some one like me that is not a expert then you shouldn't make awful remarks that you made. I am ashamed.:banghead:

MajP. When a egg is not hatched or a chick dies before it fledge's should i run a unmatched query and delete the records from the Pedigree table.

OMG what a lot of work you have done for me. How can i ever thank you. It is going to take some time to go through it and understand it but i will. Question What is the Pathkey and does the code work it out. Thank you so much. I hope you enjoyed doing it. It quickly show the inbreeding that has...

Yes, now i see why it is wrong, also it could be 8 or 9 generations. I was just trying things. I will probably not use that query, it is to big and slow. I also moved the AVK and Inbreeding to the Bird Table. Sometimes i do things to make it easy for me even if it is the wrong way of doing it.

Hi I wrote this. Is it correct I split the qry_Pedigree into 2 query's Mothers Side and Fathers Side ( qry_Pedigree_Father & qry_Pedigree_Mother ) and then made another (qry_Pedgree) query joining the 2. Created a table with 1 field (RingNumber) Could i have done it with an array...

Hi Make all the changes you like as i have stopped work on it while you are working on it. I will spend time on it to understand what you are doing for me. If you remove or change field names i will sort it out later on the forms etc I finished that qry_Pedgree query and it now takes 1 minute...

Thank you very much. I do have some doubling up which i can fix. The season is the breeding season which here in NZ goes from October to February. Birds breed in February 2019 is still Season 2018 which is the same year on the rings. All birds after fledging go in aviary's so cage number only...

No i'm not doing any code on AVK, Relationship or inbreeding yet. still working on it. A lot to do.

Thanks very much. Have a look at the query qry_Pedigee I am only a beginner at coding so any comments would be great.

Hope this helps

The birds all have ring numbers, none the same. Each pairing has a unique ID with a separate record for each chick.

Thanks. I found that one to. Hard to get the head around it all. There is also a path system as well but don't know how to implement it.

It is the algorithm that i am not sure about.

AVK: This value is 100% when all ancestors are different. The more similar ancestors are, the lower this value will be.

Hi. I am building a database for bird breeding. Does anyone know of any code / Function to calculate inbreeding and AVK. Cheers

Thanks MajP. Works a treat. No problems at all.

Thanks to every one. I am going to have fun today trying these out. Cheers

They are spinners as in pic (6 of them). I want use one for the season. They are easy to add.

Hi all Does anyone know anything about an ActiveX Control ciaXPSpin30.XPSpin30 I find them good except that you can't change some of the values. ie Max, Min etc The max is set at 10 and i would like to set it to 3000 and the Min to 2000 Any idea's Thanks