Report will not open

mcolson

I have a report that I have been working on. It depends upon a query,
which depends upon two other queries. Everything was working fine, I
verified the report worked, saved my work and exited. I later came
back, and now I can not even open up the report in Design View. Any
suggestions?

Dec 22 '07 #1

Subscribe Reply

1872

Phil Stanton

Sounds like a corrupt database. Assuming you have tried to repair it with no
success, try creating a new database and import all the objects into it
other than the duff report.. Make a copy of your new database, then try
importing the duff report.

Phil

"mcolson" <mc*********@gmail.comwrote in message
news:85**********************************@l1g2000h sa.googlegroups.com...

>I have a report that I have been working on. It depends upon a query,
which depends upon two other queries. Everything was working fine, I
verified the report worked, saved my work and exited. I later came
back, and now I can not even open up the report in Design View. Any
suggestions?

Dec 23 '07 #2

mcolson

On Dec 22, 6:20 pm, "Phil Stanton" <p...@stantonfamily.co.ukwrote:

Sounds like a corrupt database. Assuming you have tried to repair it with no
success, try creating a new database and import all the objects into it
other than the duff report.. Make a copy of your new database, then try
importing the duff report.

Phil

"mcolson" <mcolson1...@gmail.comwrote in message

news:85**********************************@l1g2000h sa.googlegroups.com...

I have a report that I have been working on. It depends upon a query,
which depends upon two other queries. Everything was working fine, I
verified the report worked, saved my work and exited. I later came
back, and now I can not even open up the report in Design View. Any
suggestions?

Something must be really wrong with that report. It will not even
import along with the others. I just went ahead and recreated it in
the new database. Thanks for your help.

Dec 23 '07 #3

by: deko | last post by:

I can't move a multi-page report to the last record unless I keep the popup form (that defined it's subreports) open. DoCmd.OpenReport "rptStandard", acViewNormal DoCmd.Close acForm,...

Microsoft Access / VBA

Change the recordset of an Access report on Open

by: lauren quantrell | last post by:

When I open an Access form I can have no recordset specified, then in the form's OnOpen event I can do something like: Me.paramaters = "@SomeColumn = 22)" Me.recordsource = "dbo.sproc123" But I...

Microsoft Access / VBA

Add Filter to Report

by: lorirobn | last post by:

Hi, I have a report that works just fine. Now I would like to add the capability to choose selection criteria to limit what is displayed. I created several reports that do this, but they used...

Microsoft Access / VBA

Reuse Report and Query and OutputTo - Must be a Way!

by: sara | last post by:

I have reports that run from a form where the user can choose a date range, or they run automatically for a week in the "Weekly Reports" option. I created 2 queries and 2 reports - one query...

Microsoft Access / VBA

Text box showing error on report

by: john | last post by:

My report is based on a query with user input . In my report I have a text box with the following code: =. This works when the query outcome is 1 or more records. But when the query output is zero...

Microsoft Access / VBA

Open Report by looking for the Report name on a table

by: Orchid | last post by:

Hello all, I have different version of reports which used for different months. For example, I am using report version 1 up to September, but we have some design changes on the report for October,...

Microsoft Access / VBA

Create Dynamic Report : with Parent Child Command

by: creative1 | last post by:

Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...

Visual Basic 4 / 5 / 6

HELP QUERY to return email add in REPORT when combo box is selected in a FORM

by: jambonjamasb | last post by:

Hi I have two tables: email_tbl Data_table Data table is is used to create a Form Data_form

Microsoft Access / VBA

Report will only open in design view

by: littlbit755 | last post by:

I am using Access 2003 at work and had created a summary report showing the financial information for year to date. As of last week the report ran great. Today I was asked to make a change in the...

Microsoft Access / VBA

emailing report as attachment

by: didacticone | last post by:

i have a database where i am trying to email a report as an attachment, it works fine but since it is an .rtf file the conversion is messy... i was wondering if i can do it as a pdf or some other...

Microsoft Access / VBA

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

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

Online Marketing

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

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

Career Advice

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

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

Networking - Hardware / Configuration

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

Similar topics