D Giles
Last Activity: Feb 18 '08, 02:51 PM
Joined: Jan 25 '08
Location:
-
Could not find an On Current event on the subreport, so tried slotting the code into On Open event of the subreport: keep getting compile error on RecordSetClone. Don't have any temp tables, main report and subreport based on two seperate queries. Thanks for help.... -
I placed the referenced control in the Detail section of the main report (same as where the subreport sits), and again it just duplicated the amount under each amount instead of giving one field with one total....Leave a comment:
-
Thanks dima69, in one respect I'm relieved if what you say it true about reports, as I cannot understand why I havent been able to find a solution to this sooner, but in another respect I'm concerned about find an alternative solution....Leave a comment:
-
ps: mshmyob : I couldn't see anything beneath your post "for example.."Leave a comment:
-
Hi thanks. The subreport is in the detail section of the main report. The subreport is pulling two records with amounts R1,500 and R1,000 respectively. If I open the subreport on its own the sum (which is in the report footer of the subreport) adds the two amounts and gets R2,500 correctly. I have referenced a textbox in the main report's group footer to the summed total in the subreport footer =[Leases Test 2 subreport].Report![Subreport Total],...Leave a comment:
-
Referencing Subreport Control in Main Report Footer
Access 2003: A subreport control (sum total calculated textbox located in the subreport report footer) does not show total of all records when referenced as a total in the main report footer - only shows one record amount. When I open the subreport alone, it totals the sum of all the records which the query pulls - which is what I want. The referenced textbox in the main report footer only shows one record amount. Why is the total in the main report... -
Not sure of the protocol on this forum - may I post a reply to this thread a month later, or must I start a new one? Its just that I've been reading this thread over and over again, as I'm having the same problem with referencing a subreport total in the main report footer. The total in the main report only picks up one record amount, but the total in the subreport which it is referenced to reflects the actual total of all the records. Why is the...Leave a comment:
-
I take it back! Thanks! It works! Maybe took a while to get right because 17 different reminders! Thanks again.Leave a comment:
-
Thanks pelicanstuff for your prompt response, but I still cant get this to work. I've tried re-arranging the opening order of the Expiry form DoCmds in the main form code, to see where it hangs, and I think it has to do with the Exit or Error handler on the SendObject email sender in the Reminder form code:
...Code:Private Sub Form_Load() On Error GoTo Err_Form_Load DoCmd.SendObject acSendForm, "Reminder Body Corp Levy", acFormatRTF,
Leave a comment:
-
Thanks pelicanstuff for prompt response.
Just doesn't want to work though - stops short each time after first two forms.Leave a comment:
-
Open many forms from one form
Have found many solutions on this forum to get to this point so finally registered.
I have a form which should load 17 forms.
...Code:Private Sub Form_Load() On Error GoTo Err_Form_Load DoCmd.Minimize DoCmd.OpenForm "Reminder Lease Expiry 6mth", acNormal DoCmd.OpenForm "Reminder Lease Expiry 2mth", acNormal DoCmd.OpenForm "Reminder Renewal 6mth", acNormal DoCmd.OpenForm
No activity results to display
Leave a comment: