Parent Report With 8 Sub-Reports - Microsoft Access / VBA

Fred Zuckerman

I have 8 reports that I want to run. Each report is only about 6-7 lines
long. I'd like to get them all on a single page.
So I created a parent report and made each of the 8 desired reports a
sub-report. That part all works fine.

My problem is that each of the 8 sub-reports is based on a different query.
Each of the 8 queries has 2 parameters. However, the 2 parameters are the
same for all 8 queries. When I run the parent report I am prompted for the 2
parameters 8 different times (one for each query). How can I prompt the user
for the 2 parameters just one time and then use them for all 8 queries?

Thanks In Advance,
Fred

Nov 13 '05 #1

Subscribe Reply

2072

PC Datasheet

Create a pop-up form where the user can enter the two parameters. Add an OK
button on the form and put the foloowing code in the Click event:
Me.Visible = False

Put the following code in the Open event of the parent report:
On Error Resume Next
DoCmd.OpenForm "NameOfPopupFor m",,,,,acDia log
If Not IsLoaded("NameO fPopupForm") Then
Cancel = True
Exit Sub
End If

You'll find the IsLoaded function in a standard module in the sample
NorthWind database. You need to copy it and put it in a standard module in
your application.

Put the following code in the Close event of the parent report:
DoCmd.Close acForm, "NameOfPopupFor m"

Change the two parameters in your queries to:
Forms!NameOfPop upForm!NameOfCo ntrolForFirstPa rameter
Forms!NameOfPop upForm!NameOfCo ntrolForSecondP arameter

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com

"Fred Zuckerman" <Zu********@sbc global.net> wrote in message
news:tV******** ********@newssv r14.news.prodig y.com...

I have 8 reports that I want to run. Each report is only about 6-7 lines
long. I'd like to get them all on a single page.
So I created a parent report and made each of the 8 desired reports a
sub-report. That part all works fine.

My problem is that each of the 8 sub-reports is based on a different query. Each of the 8 queries has 2 parameters. However, the 2 parameters are the
same for all 8 queries. When I run the parent report I am prompted for the 2 parameters 8 different times (one for each query). How can I prompt the user for the 2 parameters just one time and then use them for all 8 queries?

Thanks In Advance,
Fred

Nov 13 '05 #2

Similar topics

2497

events -- child/parent

by: Dayne | last post by:

Can a Parent thread catch a event send by a child thread? Dayne

.NET Framework

2638

Main Report / Sub Report Relationship

by: Becky | last post by:

Hi: I have a main report that calls a sub-report which contains several pages of data. One of the column headings in my sub-report is called "Funds". If several records contain the same Fund Name then only the Fund Name of the first record is printed. If the Fund Name changes, then only the New Fund Name of the first record is printed and so on. I put the codes to do this in the Fund Name Header section of the sub-report. But now,...

Microsoft Access / VBA

8068

tabbing out of a subform without knowing about the parent

by: Michael Fay | last post by:

There have been threads in this newsgroup explaining how to tab out of a subform to the parent form -- without having to use ctrl-tab (of which users might be unaware -- and at any rate, they shouldn't have to know that part of a form is a "subform"). I use a common subform among two main forms, so those solutions won't work -- because the "next control" depends on who the parent is. And even if I write fancy code to detect which...

Microsoft Access / VBA

23506

Refresh Parent from iframe Page_Load

by: Jeronimo Bertran | last post by:

Hi, I have a page with a very data intensive grid which needs to be automatically refreshed constantly if a change is detected. In order to not refresh the complete page so often, I created an iframe on my page whose html has the refresh meta as follows : <meta http-equiv="refresh" content="10"> The iframe is effectivelyh refreshed every 10 seconds without having the

ASP.NET

2319

How do you call a child objects method from the parent

by: jw56578 | last post by:

Is it possible to call a method from a parent object, but have the childs overriden method called instead of the base method? I want several children objects to all call a certain method when they are initialized, but they all have different implementations of that method. thanks

Visual Basic .NET

2039

How to execute parent class functions and then child's

by: msxkim | last post by:

How to execute functions in the parent class first and then functions in the child class? For example, I have a parent class with functions 'ONE' and 'TWO' and child class has a function 'THREE'. How should I declare classes so that all three functions are executed when child class is called? Class Parent public function ONE 'code end fuction

Visual Basic .NET

2812

Sub Form Getting Values from the Parent Form

by: eBob.com | last post by:

I have a "parent" form (if that's the right terminology), Form1. I declare two public values in the parent form : Public Class Form1 Inherits System.Windows.Forms.Form Public CurDir As String = Directory.GetCurrentDirectory() 'used by FormGetJobOutput Public PubUser As String 'tbxUser.text value for subForms In the "child" form, I call it FormGetJobOutput, I reference these two public values ...

Visual Basic .NET

19624

How does child class access parent's variables

by: Goran Djuranovic | last post by:

Hi all, Does anyone know how to declare a variable in a class to be accessible ONLY from a classes instantiated within that class? For example: ************* CODE ***************** Public Class Parent '*** HOW TO DECLARE IT *** Dim Age As String = "1/1/2000"

Visual Basic .NET

1797

Changing parent properties

by: Yuk Tang | last post by:

Leading on from a recent topic, "How does child class access parent's variables", I would like to ask, what's the most elegant way of changing a parent/grandparent/great-grandparent's property? The class Nest has a subclass SubNest. Within SubNest I want to work with Title. I think if I can pass Title ByRef to the children and grandchildren, it would work, but VB doesn't do so by default, and indeed warns me against it: "Reference to a...

Visual Basic .NET

7858

Dynamic Crosstab Report only displays 1 row of data

by: ollyb303 | last post by:

Hi, I am trying to create a dynamic crosstab report which will display number of calls handled (I work for a call centre) per day grouped by supervisor. I have one crosstab query (Query1) which has the following fields: SPID (supervisor ID), total:group by, as row heading Date, total:group by, as column heading Calls handled, total:sum, as value Date, total:where, criteria between and - this is taken from a form,

Microsoft Access / VBA

9271

Changing the language in Windows 10

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10031

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9869

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9838

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8709

AI Job Threat for Devs

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7242

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6534

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5140

Trying to create a lan-to-lan vpn between two differents networks

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2665

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General