Display new report when chosen one contains no data...

I have a complicated report with numerous parameters which will on occasion return no records.

What i want to do is have a new report display when this happens which includes the company logo etc. stating something like "The parameters you have entered have returned no data, please try again."

I don't want to achieve this using a message box or any pop ups at all, due to the way my users are accessing the reports it will have to be a report which gives them the message.

I currently have in the no data property...

Expand|Select|Wrap|Line Numbers

DoCmd.OpenReport "BWRptNO_DATA", acViewPreview

which will open the new report but it does so behind the report with no data in.
Every time i try to insert a Close somewhere in the code....

Expand|Select|Wrap|Line Numbers

 DoCmd.OpenReport "BWRptNO_DATA", acViewPreview

DoCmd.Close acReport, "BWrptAnalysisOfEnrolmentsByPostCode"

i get an error message saying "This action can't be carried out while processing a form or report event.

Can anyone help me?

Mar 10 '08 #1

Subscribe Post Reply

1061

Lewe22

Fixed it.

Expand|Select|Wrap|Line Numbers

 Private Sub Report_NoData(Cancel As Integer)

    DoCmd.OpenReport "BWRptNO_DATA", acViewPrevie

    DoCmd.CancelEvent

End Sub

Mar 11 '08 #2

by: stewart | last post by:

I'm writing an app that requires a 3-level optionMenu display. Basically I'm showing the contents of a 3-dimensional matrix. You choose the first level in the first optionMenu, the 2nd level in...

Python

Dialog Form for Report Not Working

by: Dalan | last post by:

I designed a dialog box with a combo to select individual vendors from a form and its related data for print ouput. Though the dialog box seems to work okay, I apparently do not have the filtering...

Microsoft Access / VBA

Ambitious report idea......... "Favorites"

by: Dennis Ruppert | last post by:

Greetings This is rather ambitious: I have a split database that contains many different reports. I have a form that the end user launches the reports from. They select the report criteria...

Microsoft Access / VBA

Sending selected items from listbox to report

by: Geir Baardsen | last post by:

Hi! To Darryll Kerkeslager: Sorry..Something seems to happen when trying to answer your comment. U did understand it right. Of course I'll have an underlying query with the same fields. ...

Microsoft Access / VBA

How to display multiple pictures per record in an Access database?

by: Wadim Grasza | last post by:

I want to store and display (on a form or a report) multiple pictures per record in an access database. The pictures are not stored within the database. They are stored as files and the database...

Microsoft Access / VBA

Unlinked subreport (as TOC) won't display

by: Beowulf | last post by:

I'm having some difficulty and I can't for the life of me figure out why. I have a main report, rptMain, that contains a report header (displays the AppTitle), 3 group headers (one is a header...

Microsoft Access / VBA

using Crystal Reports to display data in my dataset correctly (display the data I selected instead of all the data in table)

by: JK | last post by:

In my win form, I'm trying to display a Crystal report with the data in my dataset only but, if I follow the steps in this msdn page: ...

C# / C Sharp

Create a report using a parameter from a combo box

by: fieldja | last post by:

I have a form called OwnerForm. It contains a combo box called Owner. The combo box looks up names from a table called OwnerName. It contains fields called OwnerID and Owner. I also have a main...

Microsoft Access / VBA

DataReport - How to display expression

by: GROG | last post by:

Hi all... i have a set of record to display in my data report.. and i would like to use the "Select count (*) fromm XXXX " statement to count number of record that i've chosen.. The problem is.....

Visual Basic 4 / 5 / 6

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

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

C / C++

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

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

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

Microsoft Access / VBA

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

C# / C Sharp

Display new report when chosen one contains no data...

Similar topics