Recent content by Therese

Okay - I have searched, but can't quite find the answer. Please direct me to a post if this has been answered a million times. I have used the above code for adding multiple new records. When I used "gemma-the-husky"'s code, I got the records added, but unfortunately the wrong items selected...

Thanks. I think I get it. I will give it a try and let you all know how it works. Thanks again. I would have wasted a lot of time. Therese

Thanks. I am not sure I understand completely. I do have a mainform with many fields, but then the subform has the team. I have tried to have the position1, position2, etc... be combo boxes that have the dog names as their control, but when I choose a name for position1, it fills that name into...

Hi all - I am not sure if this is even possible, but I know if it is someone here will know how to do it. I have a table with a list of dogs names. The dogs run in a team so I have another table with their run record. Currently, the form would have a text box where you select the dog's name and...

I think it works if you have it grouping on quarterly but indicate the interval to be 2. It seems kind of simple, I don't know why I didn't think of it earlier. Now I just have to get the text to work with it. For example for the first grouping (first two quarters) I want it to say Semi-Annual...

I would like my report to be grouped on a semiannual basis. I can see the option for quarterly, but I am not sure how to define my own intervals. I am sure I have to do some kind of public function defining the semiannual interval, but I am not sure how to do that or where to put that. Please...

Thank you very much for this code, it worked great. However, I wanted to change the color and maybe I didn't grab the right code list (I think it might be from Excel?). For example, I wanted to replace the HCOCOCO with CCCCFF (Pale weak blue) and it give me an error. It doesn't seem to like the...

I am trying to update information for multiple clients. For example, I may give 10 dogs a vaccine on the same day. I would like to enter the vaccination information (type, date given, expiration, etc...) and then select the 10 dogs names to update those records so that I only have to enter the...

What was the answer?

Thank You Crosstab query worked GREAT! Thanks for your help. I had never done a crosstab query before. You learn something new all the time.......

Good Question That is a very good question. I have a similar problem, so if anyone has any suggestions PLEASE HELP. In my case, I want the report to almost mimic a spreadsheet. But the layout described by musesshadow illustrates it very well.

Thanks for your replies - I was afraid of that! Therese

Hi All - I tried to do a search, but did not really find what I was looking for. I am creating a form and I cannot increase the length of the form. I know how to drag down the "Detail" border etc....I also have tried to go into the properties and increase the height, but it will only allow me to...

Thank you!!!

I want to build a query for a report consisting of the pedigree of a dog. I have two tables set up as such: tbldogname: nameid dogname dogdob dogsex breederID...