Connecting Tech Pros Worldwide Help | Site Map

Error with MDB but not with MDE in Runtime

sj
Guest
 
Posts: n/a
#1: May 25 '07
I am using Access 03 to develop a Quotation system and has this
strange enconter.

On computer with Full Access Ver.
---------------------------------------------------
The MDB program works well, and also when simulated of /runtime.

On computer runntion on Runtime
-------------------------------------------------
Error occur with MDB but not with converted MDE.

Detail of error:
--------------------
"Execution of this application has stopped due to a run-time error.
This application can't continue and will be shut down."

Happens after this code:
----------------------------------
DoCmd.Close acReport, stPubDocName

Situation when it happens:
--------------------------------------
When there is more than one QuotationDetails in the Quotation report.


Please help.

ARC
Guest
 
Posts: n/a
#2: May 25 '07

re: Error with MDB but not with MDE in Runtime


You might want to put an error handling routine in the On_Close event of the
report in question. That way, when it hits in the error in the on_close,
your message will come up, and the system will continue on without erroring
all the way out...

"sj" <sengjin.sia@gmail.comwrote in message
news:1180056260.487227.4360@z28g2000prd.googlegrou ps.com...
Quote:
>I am using Access 03 to develop a Quotation system and has this
strange enconter.
>
On computer with Full Access Ver.
---------------------------------------------------
The MDB program works well, and also when simulated of /runtime.
>
On computer runntion on Runtime
-------------------------------------------------
Error occur with MDB but not with converted MDE.
>
Detail of error:
--------------------
"Execution of this application has stopped due to a run-time error.
This application can't continue and will be shut down."
>
Happens after this code:
----------------------------------
DoCmd.Close acReport, stPubDocName
>
Situation when it happens:
--------------------------------------
When there is more than one QuotationDetails in the Quotation report.
>
>
Please help.
>

Barry Edmund Wright
Guest
 
Posts: n/a
#3: May 31 '07

re: Error with MDB but not with MDE in Runtime


On May 25, 8:13 am, "ARC" <a...@andyc.comwrote:
Quote:
You might want to put an error handling routine in the On_Close event of the
report in question. That way, when it hits in the error in the on_close,
your message will come up, and the system will continue on without erroring
all the way out...
>
"sj" <sengjin....@gmail.comwrote in message
>
news:1180056260.487227.4360@z28g2000prd.googlegrou ps.com...
>
>
>
Quote:
I am using Access 03 to develop a Quotation system and has this
strange enconter.
>
Quote:
On computer with Full Access Ver.
---------------------------------------------------
The MDB program works well, and also when simulated of /runtime.
>
Quote:
On computer runntion on Runtime
-------------------------------------------------
Error occur with MDB but not with converted MDE.
>
Quote:
Detail of error:
--------------------
"Execution of this application has stopped due to a run-time error.
This application can't continue and will be shut down."
>
Quote:
Happens after this code:
----------------------------------
DoCmd.Close acReport, stPubDocName
>
Quote:
Situation when it happens:
--------------------------------------
When there is more than one QuotationDetails in the Quotation report.
>
Quote:
Please help.- Hide quoted text -
>
- Show quoted text -
It sound like a corrupt form to me. Anyway, you should rule out a
corrupt form by setting the /decompile switch as a command line
startup option as below:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\CTDDT
\CTD.mdb" /wrkgrp "C:\CTDDT\CTD.mdw" /user "Administrator" /Excl /
decompile
If that doesn't work create another form and see if the code runs OK
from it.

As a last ditch measure create a new empty .mdb file and import all
the objects from your current .mdb into it.

Good Luck,
Barry
www.witstoronto.ca



Closed Thread