Search results

Yes indeed - we started just recording mastitis but the scope widened... I have attached my new forms. The main form is based on the treatments table (drug name is a dlookup) and shows every cow who is in the treatment herd, whether the treatments are finished or not (there is witholding period...

Have uploaded the tables showing relationship and an example of the data. Hoping it helps

I've changed direction - my main form has a button that brings up a form from a related table. There are three fields in the related table - autonumber (primary id) mastitisid and trtmntdate. I have set the second form to open with default values in masitisid (equal to the field of the same name...

Its just the cow number in the cow field. I see what you mean now - I was trying to get away from having to select cows in the list box one by one, but rather have the whole list as continuous forms - worst case scenario is maybe 30 animals, but mostly less. For your interest, the treatment form...

I have a number of treatment dates attached to one treatment event. I didn't wish to repeat information attached to an event every time the cow is treated, hence the 2 tables. One has: id, cow, firstdate, drugid (link to drug info), amount, reason, memo, daystreatmentrequired, lastdate, and...

The slow issue is that the user has to select each cow and then enter the date of treatment. Use of the keyboard and mouse puts other constraints on use, as staff are usually wet/dirty. It would be so much quicker if they could look at the cow list in its entirety and activate the appropriate...

However, I need to see all the cows being treated today - and so I cannot have continuous forms with subforms? The form I currently have is as you describe more or less, but I am looking to make it quicker, and also suitable for a touch screen, so users with dirty hands can simply tap the button...

Cows have a 3,4 or 5 day treatment cycle for infection. The main table on which the form is based holds information concerning the cow, drug, illness, date of first treatment etc and mid is the mastitisid - the id record for these treatment details. She may have had previous treatments with a...

I have a form based on a table which includes the mid field. I want to have a macro that takes the value of the current mid, and makes a new record in a 1-many related table (consisting of record id (auto), mid and trmntdate), paste the mid and insert the current date.For the life of me I cannot...

Thats it in a nutshell!

Its not as complicated (or well done) as that John! I've simply made the large arrows combo boxes and large buttons! The plan was originally to have 2 screens - one in the office for data entry (mouse and keyboard) and the other in the dairy shed for quick data retrieval and/or simple checkoff...

Thank you Paul. Our youngest daughter also lives in Wellington and I was there for a conference last week. About 7 hours driving from here... We certainly have a diversity of scenery and experience to offer down here and I hope you will get to see more of it on the next visit.

Hello all I've been dabbling in Access for years, but at a very basic level. Currently working on a dairy farm daily management system on an 800 cow farm. Its working well, but could work a lot better! Its about to be trialled on two other farms, before hopefully going to a professional db...