I'm having problems with Reports and I'm seeking some help, or advice on how to solve this problem. Any help will be much appriciated!
It’s hard to explain but I will try to do my best:
In my Database I have about 6 to 7 reports that show me all the data from different tables. When I open any Report in 'Print Preview' Mode everything looks fine and the Reports open just fine. But once in a while, for some strange reason and I don't know why, the report doesn't want to open........
I keep clicking on the Report but nothing happens, even when I try to open the same report in design view mode, the application won't allow me to open it........ Also once this problem occurs it lock up some of the other reports, and it doesn't allow me to open any of the other reports (not all of them, but some of them, the problem occurs at random, not always happens on the same report). When I close down the entire application and re-open it, the report that was locked up, opens up just fine.
Another thing I have noticed was… when I keep clicking and trying to open any of the reports after the error has occurred, the report that was locked up, all the sudden works again. I can go even 2 min before the problems occurs (2 min worth of clicking every report and not getting any problems) but there are times that the problem occurs every 30 sec or so).
Things I have done so far:
-I have deleted all the tables and all the reports, and created them from the beginning.
-I wasn't running any filters, or queries to modify the tables.
-I have used wizard to create all the reports
-Control Source looks fine..... No expr 1 fields
-While running the reports I didn't get any err messages
-Once I close the entire app, and re-open it (the reports that was locked up works fine)
-I was running the application in MDE, Compact and Repair Database, and Design View Mode
-This problem occurs random not always on the same report.
-Each report is closed before the next report is opened.
-Relationship between the tables looks good ...... no problems there. (I have linked all the necessary tables together with 'primary key' ID Fields)
At the moment I don’t know what to do anymore or where to look for the bug ……….. If any one can help me out .......... that would be great ....... any info, any advice will be welcome........ Thank You!
I'm running MS Access 2000 (9.0.8959 SP-3) on Windows XP SP2 with Updates up to date.
3  2472  MMcCarthy 14,534
Recognized Expert Moderator MVP
I would suggest you look at your printer drivers as this sounds more like a printer problem than an Access one. Access will not let you open a report even in design view if it cannot find a printer. The random nature of this problem and the fact that it also affects design view lead me to believe it is the printer. Talk to your network people maybe your printer is dropping in and out.
I just wanted to thank you, for your advice. Looks like you were right about the problem. But I still have to find a way around it, or fix it. This is the only printer I can use to view the data or print the data. Do you know by any chance where to look for the problem, and what things to look for? Any help would be much appreciated. Thank you once again!
I'm using HP LaserJet 4240N Printer.
I was thinking to change the default printer to Cute PDF Writer when ever the user wants to view the report and use the default printer HP LaserJet 4240N Printer to print the data. But that would complicate things more, and cause more problems along the way. Do you have any other suggestions??
MMcCarthy 14,534
Recognized Expert Moderator MVP
I just wanted to thank you, for your advice. Looks like you were right about the problem. But I still have to find a way around it, or fix it. This is the only printer I can use to view the data or print the data. Do you know by any chance where to look for the problem, and what things to look for? Any help would be much appreciated. Thank you once again!
I'm using HP LaserJet 4240N Printer.
I was thinking to change the default printer to Cute PDF Writer when ever the user wants to view the report and use the default printer HP LaserJet 4240N Printer to print the data. But that would complicate things more, and cause more problems along the way. Do you have any other suggestions??
I'm afraid I'm no expert on printer drivers. I think using a virtual printer like Cute PDF may be your best bet.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Teri Welch |
last post by:
Hello,
We maintain a VB6 front-end application using an Access 2000 database. All
code and forms are in VB6. The program also uses several queries/reports
defined in Access. For corporate reasons we must move to SQL Server right
away. Based on our configuration, we're hoping someone can give us a feel
for what's involved here. Since we're only using Access for the data we're
not sure what an "upsizing" would entail. Can someone point us...
|
by: John |
last post by:
Hi,
I've recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet 4 to Service Pack 7
2) Set Subdatasheet Name to from
3) Shortened the file name of the .MDB file
4) Made sure the Track name AutoCorrect info is off
|
by: jdola |
last post by:
I have a customer that is using Access to create reports from FoxPro
tables. We started noticing problems with the indexes on the FoxPro
tables. It is to the point where we have to delete and rebuild the
indexes on a nightly basis. We cannot determine if Access is the
culprit and I have not been able to look at the Access reports and
determine how he is linking to the tables. I realize this is not much
to go on, but does anyone see any...
|
by: intl04 |
last post by:
I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message that says:
'There was a problem retrieving printer information for this object.
The object may have been sent to a printer that was unavailable.'
When I choose 'report wizard', I can go through all of the steps but
then I get an error message...
|
by: Dave Smithz |
last post by:
Hi There,
Having last developed an Access DB for a client about a year ago I have
today received a specification that I need to (today ideally) give an
indication of how much I would charge and what technology I would use etc.
The spec. is well laid out but there are two things it does note:
Remote access for employees
Remote access for resellers
| | |
by: Mell via AccessMonster.com |
last post by:
Is there a way to find out where an application was created from?
i.e. - work or home
i.e. - if application sits on a (work) server/network, the IT people know the
application is sitting there, but is there a way they can find out if that
application was put there from a CD or email or created at work?
Hint: It's not on a client/server database, just native jet database mdb
created on Access 2003 (default 2000)...
|
by: jasmith |
last post by:
How will Access fair in a year? Two years? .... The new version of
Access seems to service non programmers as a wizard interface to
quickly create databases via a fancy wizard. Furthermore, why would
you even continue to use Access as a backend when you have a much
superior option in SQL express?
What about as a future front-end development tool? Let's get serious.
Microsoft continues to publish numerous articles and videos on how you...
|
by: JoeW |
last post by:
I'm utilizing a database that I created within MS Access within a
program I've created in VB.NET. I am using the VB front end to
navigate the information, but want to be able to print a report, that
I've also created within MS Access. I've attempted using the
Access.Application instance, but I get errors when it tries to load the
database. Just wondering if anyone has any experience with this, and
what I should do.
Thanks for any...
|
by: DeniseY |
last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet. Again, I have this part working. But the fields in the resulting spreadsheet are in a different order than the Access report. (Example: The fields in the Access report might go FirstName, LastName,Address,City--in the Excel spreadsheet, they come up...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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...
| | |
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...
|
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,...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
