Search results

That worked. THANK YOU VERRY MUCH for all of your help and patience. It's not fun getting old!

I tried that and I can not get it to behave. Once I change a value, it keeps that value all the way through till I change it again. I am using No for the first value and default to do as you said and avoid blank records.

I decided to go back to the old way of entering the MARS from a listbox to eliminate being able to select multiple values. The only problem I am having with that is that when I select it for one person, it copie3 that value to other people. Not Good! Any Ideas? It used to work.:banghead: I...

Perfect, works like a champ. Only one problem. You can still select more than one value for MARS. A person can only belong to one MARS branch at a time.

OK, I have everything done except the MARS and Affiliations problems. You had said something about using something like: RosterID > 8 ~ AffiliateRef 1 RosterID > 8 ~ AffiliateRef 3 RosterID > 8 ~ AffiliateRef 4 RosterID > 8 ~ AffiliateRef 7 I don't follow what you are saying. I have the...

Ok, that is what was confusing me. I had too many questions going at onse. Will do but not sure how soon I will get to it. May be a couple of days.

I have that working. what I need now is the answer to my next question, the list length.

Never mind this. I got it working!! :) Now for the next problem. I need to limit the number of selections in the MARS and Affiliation boxes and prevent duplications in those boxes. There are three possible entries for MARS, and seven for Affiliations. I need the choice list to allow...

Both the report and the query. I don't care so much what is shown on the query, unless I have to have the info there for the report, but the report is what is important. The new license classes are Tech, General, and Extra (The FCC combined the old ones but some people still have the old...

Ok, I did and it sort of works. There are three problems left. The one that is keeping it from being usable is the License Class Report so let's look at it first. When I do the query or report, I am getting a number instead of the name of the class and the total count for that class. The total...

Ok, I created AffiliateIndex in the Affiliate table. Next step?

Ok, I'm missing something here. I created a field in the affiliate table called AffiliateIndex. Now I need to create a relationship to the roster table? I suggest we take this one a step at a time.

Never mind this one. My fault. I had the control Wizard on when I designed it. Mt Bad! I set 4 fields, No, Air Force, Army, and Navy. That way there are no blank fields.

Are you saying to add a new index or one that already exists?

tblRoster the tblMars line I added and the frmRoster has them listed too.

Like what and should I associate it with a field?

The max would be 7, none of which should appear more than once. ARRL, ARES, RACES, Skywarn, VE, EOC, and 92-2.

I tried that and only got 2 of the three. I used " ";"Air Force";"Army";"Navy" and it will only give me Air Force and Navy. I can't figure out why. I should also say that it is probable that most people will not be members of this affiliation, That is why I need the blank. I suppose I could...

I don't anticipate having to add any relationships at this point. Every thing is working with the exceptions which I will address later today. They are: 1. In MARS, T need to select only one of the three. That selection could be changed. As it stands, I tried a selection like I originally...

If the user goofs or the member ops out of a group, how do I record that without creating a blank record on a form? just have the report ignore blank fields? I probably won't be answering much today. We are baking. I have 1 pie in the oven and am about to start making cookies.