Search results

I had the blank lines there incase someone goofed and put a value in that field that didn't belong there or dropped out of something. I noticed that you can just delete what is written in the box by highlighting the data and hitting Delete.

Ok, I replaced everything and have some of it working. I may have gotten a slight reprieve on the deadline also. In the interest of keeping this discussion shorter, maybe we should use email. dave.alexander1947@gmail.com

In the Affiliate Query we only want the names of the people that are affiliated with that category as well as the summary. This is to track who is trained for certain positions. Will do on the "tlkpInfo" We don't do PayPal and credit cards, that's why I took those out. What I sent you...

I also fixed the Affiliate members report, the Affiliate Summery, and added totals to report by Call sign and Last Name. Check out the Switch Board too.

I did it and it worked. Do you want me to send a sample to you?

The only thing I copied was the data from the old Roster table. I did not copy the structures or anything else. I renamed the old fields so the copy and paste would accept them. I pasted that into the tblRoster table. I'll do that again to be sure.

First I made a copy of the old database. Then I deleted the columns that I did not want. I then renamed the columns I wanted to the same as the new form. Then I did a copy and paste from the old form to the new form. I got no errors.

First of all, I probably goofed. There are 3 choices. Air force, Army, and Navy. They should have been in the example but one may have gotten away. I am trying to add the MARS list box to the tblRoster as you suggested. When I add a list box to the frmRoster with the following, I am getting...

Yes, I made that correction. The join is from the tblRoster, RosterID field to tblMARS,MarsMARS field.

That option is not available.

It is already and still allows you to select all the possible items and keep on adding dupes.

In the query qryashUP the design view has SELECT tlkpInfo.tlkpInfoDesc, Sum(qryPaid.DuesAmount) AS SumOfDuesAmount FROM tlkpInfo INNER JOIN qryPaid ON tlkpInfo.tlkpInfoID=qryPaid.DuesMethod GROUP BY tlkpInfo.tlkpInfoDesc; In the qryCashUpTotal the design view has SELECT Sum(qryPaid.DuesAmount)...

Windows 7 Access 2007: For rptCountOfRosterClass I get a window that says CountOfRosterID , Gives me a blank to type something, and an OK or Cancel Option. For rptMARSMembers I get no data when there should be something listed. For sfmCashUp I get Forms!frmPaid!cboYear a box to put...

The fields are: MARSRosterID, MarsMARS, and Marsindex. MARSRosterID is set to Number with Required set to Yes and Indexed set to Yes duplicates OK. MarsMARS is set to Number with Required set to No and Indexed set to No. MarsIndex is set to Number with Required set to No and Indexed set to...

OK, The government will not permit a ham to belong to more than one MARS group at a time. Therefore if you are a MARS operator you either have to be Air Force, Army, or Navy. You do not have to be in the military now or ever. I think they eliminated Navy, but just incase there are some Navy...

Uncle Gizmo, I found the following reports are not working: rptCountOfRosterClass rptMARSMembers The following forms are not working: sfmCashUp sfmCashUpTotal sfmPaid Any Ideas? Other than that I think it is ready to go. I put the Switch Board in and have the layouts the way we...

I fixed the caps issue by putting a > in the format under the format tab in the layout. I'm just not thinking. Too much to do and too little time.

I need to make a few fields all caps. the > in the table isn't working. Any ideas?

Two Questions: 1. How do I prevent the * line from showing in the affiliate and MARS sub forms? 2. Where do I put the index for the MARS selection? The class selection would work for MARS but I can't figure out how you did that one. I guess those strokes I had did more damage than I...

OK, Will do. Thanks.