473,544 Members | 2,458 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

On Format Property of a Subreport

44 New Member
I'm having difficulty initializing and incrementing a counter on a subreport that includes another sub report example:

PRIMARY REPORT
1: Child Report
Grandchild Report
Grandchild Report
2: Child Report
Grandchild Report
Grandchild Report
3: Child Report
Grandchild Report
Grandchild Report

the incrementer behind Child Report is continuing to increment beyond the point when I'm trying to initialize it for a new pass.

I can make a change in my application to accomodate this, but I'd rather keep the app as is and format this numbering when I generate the report.

TIA for any support.
Aug 28 '07 #1
1 1508
MMcCarthy
14,534 Recognized Expert Moderator MVP
We would need to see the code you are using in the on format event.
Sep 2 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
4124
by: Steve Edwards | last post by:
I am trying to use an existing report as a subreport in another report. I have the subreport added to the main report, but the only thing that shows up where the subreport should be is the name of the subreport. In reading the Access help files, it sounds like there should be LinkChildFields and LinkMasterFields proprties in the propert...
3
12105
by: Melissa | last post by:
What specifically causes the Format event of a report's section to fire? Thanks! Melissa
2
2464
by: Galina | last post by:
Hello All of a sudden I started getting error 13, type mismatch in a command, which was running happily for years. Here is a code: Option Compare Database Option Explicit Dim CmdClose1_Clicked As Boolean, CmdClose_Clicked As Boolean Private Sub CmdClose_Click() On Error GoTo Err_CmdClose_Click 'Check, if there are any messages marked to...
3
7442
by: kmacon | last post by:
I have a form that contains a command button. The command button's OnClick event builds a report using the CreateReport and CreateReportControl functions and then opens the main report. I set the OnFormat property of the detail section in the subreport to a function which is located in a standard module. I am not able to access the...
5
10699
by: ken | last post by:
Hi, Why can't I do this in the report activate section of my main report? I have a main report, and a subreport on it. The idea is that if the subreport has a certain value in a control within it, I want to hide the subreport. I get an error(runtime 2101 the setting you entered isn't valid for this property) for the line of code below ...
3
1869
by: David W. Fenton | last post by:
I ran into a weird problem with a subreport with an OnFormat event of the subreport detail. When I view the field list in report design view, all the aliased fields in the recordsource are available. But when the report runs, the aliased fields are inaccessible. Of course, this is causing a problem with the report running, and I can't figure...
0
4263
by: C | last post by:
Hi, I have a main Report which has a SubReport. This SubReport also has a SubReport. I set the data of my main Report and Subreport through code DataSet dsMainReport = daLayer.GetMainReportData();
4
6498
by: olseni | last post by:
Hi, i am trying to make a report which consists of many subreports, and I need to make the subreports moveable and not show when the subreport has no data. I use an event procedure in the 'On no data' property: Private Sub Report_NoData(Cancel As Integer) Cancel = True End Sub but when i try to set the 'moveable' property...
3
9374
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
0
7373
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7717
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5928
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5306
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3427
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3421
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
993
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
677
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.