Search results

  1. K

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

    That option is not available.
  11. K

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

    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)...
  13. K

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

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

    Need a report based on the valve of list boxes

    OK, Will do. Thanks.
Back
Top Bottom