Need a report based on the valve of list boxes
- Thread starter ka3pmw
- Start date
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 need them.
It still needs to have the MARS either/or problem fixed. I didn't figure out where you wanted me to put that index to fix that and what it gets related to.
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 need them.
It still needs to have the MARS either/or problem fixed. I didn't figure out where you wanted me to put that index to fix that and what it gets related to.
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
All the reports and forms work fine in my version.
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
This is wrong.......
Set the forms data entry property to no.
this is Right........
The property that needs changing is called "Allow Additions" however if you set this to false you will no longer be able to add records.
Last edited:
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
I think there's a table called tblMars set the index in there.
I think there's a field rosterID and marsdesc, set the index to unique on these two fields.
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
I will need an explanation of this problem.
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 operators in the club it's best to keep the field.
Last edited:
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 Yes Duplicates OK.
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 something in and OK or Cancel options.
For sfmCashUpTotal I get Forms!frmPaid!cboYear a box to put something in and OK or Cancel options.
For sfmPaid I get Forms!frmPaid!cboYear a box to put something in and OK or Cancel options.
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) AS SumOfDuesAmount
FROM tlkpInfo INNER JOIN qryPaid ON tlkpInfo.tlkpInfoID=qryPaid.DuesMethod;
This looks like an SQL statement and we are not using SQL.
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) AS SumOfDuesAmount
FROM tlkpInfo INNER JOIN qryPaid ON tlkpInfo.tlkpInfoID=qryPaid.DuesMethod;
This looks like an SQL statement and we are not using SQL.
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
Strange! It was working OK when I posted it. Have you changed something?
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
In that case I put it back in the main table and choose from a combobox.
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
Have you added Marsindex?
It is already and still allows you to select all the possible items and keep on adding dupes.
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
I meant the subform.
- Local time
- Today, 09:56
- Joined
- Jul 9, 2003
- Messages
- 17,110
The example db you provided has two records.
However I gather from your comments that this is an existing concern.
That leads me to ask, how are you going to add the records from your existing system to the new system!
However I gather from your comments that this is an existing concern.
That leads me to ask, how are you going to add the records from your existing system to the new system!
That option is not available.
Yes, I made that correction.
The join is from the tblRoster, RosterID field to tblMARS,MarsMARS field.
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 two options in the box on the form, Air Force and Navy.
Control Source RosterMARS
Row Source " ";"Air Force";"Army";"Navy"
Row Type Value List
Bound Column 1
Allow Value List Edits Yes
This is the same as I did for the list boxes on my old form. I can't figure this one out!
Similar threads
