When I set a breakpoint I (sometimes) get an error message just before the
!breakpointed! code should be executed. The error message is "The expression
On Exit you entered as the event property setting produced the following
error: can't execute code in break mode.". Actually, I'm not in break mode.
The error mesage pops up several times but I can easily step the code after
that.

What kind of problem is that?

TIA

Vlado

Sometimes uncompiled code becomes corrupted in the connection to the
uncompiled code that you see in the IDE. Try copying the text of your code
into a text file, then deleting the code behind that form. Compact the
database several times then reopen the form and paste the code back in. Make
sure it's all re-attached to [Event Procedure]s in the Event property sheet
and will recompile. It should then be OK.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> When I set a breakpoint I (sometimes) get an error message just before the
> !breakpointed! code should be executed. The error message is "The
> expression On Exit you entered as the event property setting produced the
> following error: can't execute code in break mode.". Actually, I'm not in
> break mode. The error mesage pops up several times but I can easily step
> the code after that.
>
> What kind of problem is that?
>
> TIA
>
> Vlado

TYVM for your respond, Arvin.

1) The trick didn't help.
2) It took >10 minutes to check all the [Event Procedure] are attached...
too complex form... I wouldn't like to do it quite often. ;-)
3) I'd like to point you to a non-answered post of mine @
http://groups.google.co.uk/group/microsoft.public.access/browse_thread/thread/73989b3f9ada1bcf/cec1df77c425e0a1?lnk=st&q=A+while+ago+we+had+a+discussion+about+A2002+(sub)form+which+changes&rnum=1&hl=en#cec1df77c425e0a1
which complains project corruption.

Vlado

P.S. Answer only in this newsgroup, please.

"Arvin Meyer [MVP]" <(E-Mail Removed)> píše v diskusním pøíspìvku
news:%(E-Mail Removed)...
> Sometimes uncompiled code becomes corrupted in the connection to the
> uncompiled code that you see in the IDE. Try copying the text of your code
> into a text file, then deleting the code behind that form. Compact the
> database several times then reopen the form and paste the code back in.
> Make sure it's all re-attached to [Event Procedure]s in the Event property
> sheet and will recompile. It should then be OK.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> When I set a breakpoint I (sometimes) get an error message just before
>> the !breakpointed! code should be executed. The error message is "The
>> expression On Exit you entered as the event property setting produced the
>> following error: can't execute code in break mode.". Actually, I'm not in
>> break mode. The error mesage pops up several times but I can easily step
>> the code after that.
>>
>> What kind of problem is that?
>>
>> TIA
>>
>> Vlado
>
>

Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 2) It took >10 minutes to check all the [Event Procedure] are attached...
> too complex form... I wouldn't like to do it quite often. ;-)

Thanx a million, Doug!

Vlado

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
pøíspìvku news:(E-Mail Removed)...
> Check my March, 2004 "Access Answers" column in Pinnacle Publication's
> "Smart Access" for code that automates this.
>
> You can download the column (and sample database) for free at
> http://www.accessmvp.com/DJSteele/SmartAccess.html
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 2) It took >10 minutes to check all the [Event Procedure] are attached...
>> too complex form... I wouldn't like to do it quite often. ;-)
>
>

Still having problems with "Can't execute code in break mode". Decompile &
compress didn't help... :-(

Vlado
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
pøíspìvku news:(E-Mail Removed)...
> Check my March, 2004 "Access Answers" column in Pinnacle Publication's
> "Smart Access" for code that automates this.
>
> You can download the column (and sample database) for free at
> http://www.accessmvp.com/DJSteele/SmartAccess.html
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 2) It took >10 minutes to check all the [Event Procedure] are attached...
>> too complex form... I wouldn't like to do it quite often. ;-)
>
>

While decompiling should have cleaned up corruptions, you might have to
create a new database and import all of the objects from your old database
into the new one.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Still having problems with "Can't execute code in break mode". Decompile &
> compress didn't help... :-(
>
> Vlado
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
> pøíspìvku news:(E-Mail Removed)...
>> Check my March, 2004 "Access Answers" column in Pinnacle Publication's
>> "Smart Access" for code that automates this.
>>
>> You can download the column (and sample database) for free at
>> http://www.accessmvp.com/DJSteele/SmartAccess.html
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 2) It took >10 minutes to check all the [Event Procedure] are
>>> attached... too complex form... I wouldn't like to do it quite often.
>>> ;-)
>>
>>
>

Is there any way how to recognize corrupt database?

Vlado
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
pøíspìvku news:(E-Mail Removed)...
> While decompiling should have cleaned up corruptions, you might have to
> create a new database and import all of the objects from your old database
> into the new one.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Still having problems with "Can't execute code in break mode". Decompile
>> & compress didn't help... :-(
>>
>> Vlado
>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
>> pøíspìvku news:(E-Mail Removed)...
>>> Check my March, 2004 "Access Answers" column in Pinnacle Publication's
>>> "Smart Access" for code that automates this.
>>>
>>> You can download the column (and sample database) for free at
>>> http://www.accessmvp.com/DJSteele/SmartAccess.html
>>>
>>> --
>>> Doug Steele, Microsoft Access MVP
>>> http://I.Am/DougSteele
>>> (no private e-mails, please)
>>>
>>>
>>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 2) It took >10 minutes to check all the [Event Procedure] are
>>>> attached... too complex form... I wouldn't like to do it quite often.
>>>> ;-)
>>>
>>>
>>
>
>

Have you read the Corrupt Microsoft Access MDBs FAQ that Tony Toews has at
http://www.granite.ab.ca/access/corruptmdbs.htm?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Is there any way how to recognize corrupt database?
>
> Vlado
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
> pøíspìvku news:(E-Mail Removed)...
>> While decompiling should have cleaned up corruptions, you might have to
>> create a new database and import all of the objects from your old
>> database into the new one.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Still having problems with "Can't execute code in break mode". Decompile
>>> & compress didn't help... :-(
>>>
>>> Vlado
>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
>>> pøíspìvku news:(E-Mail Removed)...
>>>> Check my March, 2004 "Access Answers" column in Pinnacle Publication's
>>>> "Smart Access" for code that automates this.
>>>>
>>>> You can download the column (and sample database) for free at
>>>> http://www.accessmvp.com/DJSteele/SmartAccess.html
>>>>
>>>> --
>>>> Doug Steele, Microsoft Access MVP
>>>> http://I.Am/DougSteele
>>>> (no private e-mails, please)
>>>>
>>>>
>>>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> 2) It took >10 minutes to check all the [Event Procedure] are
>>>>> attached... too complex form... I wouldn't like to do it quite often.
>>>>> ;-)
>>>>
>>>>
>>>
>>
>>
>

Have been there earlier today... ;-)
MS guys & gals shoud visit that site, too. :-)

Vlado

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
pøíspìvku news:(E-Mail Removed)...
> Have you read the Corrupt Microsoft Access MDBs FAQ that Tony Toews has at
> http://www.granite.ab.ca/access/corruptmdbs.htm?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Is there any way how to recognize corrupt database?
>>
>> Vlado
>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
>> pøíspìvku news:(E-Mail Removed)...
>>> While decompiling should have cleaned up corruptions, you might have to
>>> create a new database and import all of the objects from your old
>>> database into the new one.
>>>
>>> --
>>> Doug Steele, Microsoft Access MVP
>>> http://I.Am/DougSteele
>>> (no e-mails, please!)
>>>
>>>
>>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Still having problems with "Can't execute code in break mode".
>>>> Decompile & compress didn't help... :-(
>>>>
>>>> Vlado
>>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v
>>>> diskusním pøíspìvku news:(E-Mail Removed)...
>>>>> Check my March, 2004 "Access Answers" column in Pinnacle Publication's
>>>>> "Smart Access" for code that automates this.
>>>>>
>>>>> You can download the column (and sample database) for free at
>>>>> http://www.accessmvp.com/DJSteele/SmartAccess.html
>>>>>
>>>>> --
>>>>> Doug Steele, Microsoft Access MVP
>>>>> http://I.Am/DougSteele
>>>>> (no private e-mails, please)
>>>>>
>>>>>
>>>>> "Vladimír Cvajniga" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>> 2) It took >10 minutes to check all the [Event Procedure] are
>>>>>> attached... too complex form... I wouldn't like to do it quite often.
>>>>>> ;-)
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>