I get something like this a percentage of the time when
I open an A97 report by dbl-clicking it in the database
window. I can not remember seeing tnis when the
report is opened in code, I can not remember it
happening when the report is opened first into design
view and then into report view. But I can remember it
happening when first opening the report in design view.
Trouble is, this does not happen all the time. Lets just
say less than 10% of the time. Generally, it does not
happen AGAIN upon restarting Access after the error
shuts it down. This unpredictable behavior makes de-
bugging it a trial & error procedure. Using the word
"Description" anywhere for anything is a practice I'm
abandoning. After replacing all instances of that word
throughout my database, I find the anomoly still occurs.
I've spoke of this before in the NG, but the thread is
old and without concrete resolution. As long as this
tear in the time-space continuum persists, I'll raise the
flag a few times each year - just 2C what pops up in
your brilliant minds. 4 1441
MLH wrote: I get something like this a percentage of the time when I open an A97 report by dbl-clicking it in the database window.
In order, I'd try:
1) Compile and Save in a code window;
2) Compacting;
3) Proper Decompile;
4) Open an empty mdb and import all objects from the mdb in question
5) Reinstall A97
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
MLH wrote: I get something like this a percentage of the time when I open an A97 report by dbl-clicking it in the database window. I can not remember seeing tnis when the report is opened in code, I can not remember it happening when the report is opened first into design view and then into report view. But I can remember it happening when first opening the report in design view.
Trouble is, this does not happen all the time. Lets just say less than 10% of the time. Generally, it does not happen AGAIN upon restarting Access after the error shuts it down. This unpredictable behavior makes de- bugging it a trial & error procedure. Using the word "Description" anywhere for anything is a practice I'm abandoning. After replacing all instances of that word throughout my database, I find the anomoly still occurs.
I've spoke of this before in the NG, but the thread is old and without concrete resolution. As long as this tear in the time-space continuum persists, I'll raise the flag a few times each year - just 2C what pops up in your brilliant minds.
Do you have any code behind the report? Like in the OnOpen event,
OnClose, etc?
If so, you may want to put in some code that writes to a text file and
appends the messages. Open the text file (see Open in help) and write a
line and time to the file and close it. Ex:
Open "C:\TESTFILE.Txt" For Output As #1' Open file for output.
Print #1, Now() & " Passed this section" ' Print text to file.
Close #1
WHen it aborts, you can find out how far it got before collapsing.
MLH <CR**@NorthState.net> wrote in
news:af********************************@4ax.com: I get something like this a percentage of the time when I open an A97 report by dbl-clicking it in the database window. I can not remember seeing tnis when the report is opened in code, I can not remember it happening when the report is opened first into design view and then into report view. But I can remember it happening when first opening the report in design view.
Trouble is, this does not happen all the time. Lets just say less than 10% of the time. Generally, it does not happen AGAIN upon restarting Access after the error shuts it down. This unpredictable behavior makes de- bugging it a trial & error procedure. Using the word "Description" anywhere for anything is a practice I'm abandoning. After replacing all instances of that word throughout my database, I find the anomoly still occurs.
I've spoke of this before in the NG, but the thread is old and without concrete resolution. As long as this tear in the time-space continuum persists, I'll raise the flag a few times each year - just 2C what pops up in your brilliant minds.
Typically, this kind of problem is caused by something to do with
the printer driver for the printer that is saved with the report.
And printer drivers can be buggy because of dodgy video drivers
(Windows is designed so that printers use video drivers to do
certain kinds of rasterization in order to improve WYSIWYG), so I'd
try using a different printer driver and check to see if I had the
most up-to-date video drivers.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
All EXCELLENT suggestions. Am going to try
them one-by-one. Because of the intermittent
nature of the problem, it'll take me some time
to debug. This thing's like an STD - I wouldn't
wish it upon anyone. Once I've pretty well de-
termined that its been eradicated, I'll follow back
up with a report. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: J |
last post by:
Hi,
Ive got 3 forms, (a subform within a subform within a form) and when I
refresh the outermost form, Access closes and offers to send an error
report.
The forms worked fine a few weeks ago,...
|
by: p988 |
last post by:
using System;
using System.Windows.Forms;
using System.Drawing;
class MyForm : Form
{
MyForm ()
{
Text = "Windows Forms Demo";
}
|
by: Willem van Rumpt |
last post by:
Hi all,
coming from an unmanaged programming background, I took my time to
sort out the IDisposable and finalizer patterns. Just when I thought
I had it all conceptually neatly arranged, the...
|
by: Ron |
last post by:
Hi there,
We have a web application written in C# that need to deal with MS word
2003. it works fine on developer's machine but when I deployed it on
web server, we got error msg says "Access is...
|
by: bonhoeffer |
last post by:
Dear all,
I am writing a program in "Access XP", I would like to add two options for printing.
Here is my scripts as below:
Private Sub 275_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu,...
|
by: DFS |
last post by:
This is a phrase you'll see often if you build large-scale Access front-end
systems, which almost certainly will get corrupted at some time or another
if they contain large amounts of code and/or...
|
by: PW |
last post by:
Hi,
One of our clients is getting that error when they are trying to save
a record but I can not duplicate it here. The data is on another PC
and is linked to two workstations.
The code...
|
by: Dameon99 |
last post by:
Hi,
I have just spent many hours debugging my code and now when I run it I get the following error:
"An access violation (Segmentation fault) raised in your program"
I have researched on this...
|
by: Jeff Bigham |
last post by:
Hi,
I'm getting an "Access is denied" error in IE when I try to focus an
input box with node.focus()
My understanding is that should only happen when the domains are
different of the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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,...
|
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...
|
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...
| | |