Search results

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...

For question 1. Where in the query do you reference the combo box. I have tried that, but it just asks me to enter the parameter. I am obviously doing something wrong, I just can't figure out what. Thanks in advance.

Thank you for your help. This forum is really a big help!!!!

I have a general form, frmInfo, on this form are several different distinct areas of information. For example, the first part of this form is dealing with case information that includes officer name which is a lookup list. If the officer is not in the list I have a command button to open a...