Re: Access ignores my request for a code break - why?

"ManningFan" <manningfan@xxxxxxxxx> wrote in message
<1175866067.372131.82070@xxxxxxxxxxxxxxxxxxxxxxxxxxx>:
You know in the VBA Editor when you can click in the column to the
left of the code and you get that little red dot? Access is SUPPOSED
to break the code at that point so you can troubleshoot what you're
doing.

This works in all of my databases but one. Is there a switch
somewhere to turn it on, or is the database phuxored? Is there a way
to prevent this behavior? I've seen this happen before but I don't
think I've ever found a solution to it. Anyone got any ideas?

Been playing with the database properties, have we? In particular the
Use Access Special Keys from Tools | Startup? When unchecking that
setting, I think also the AllowBreakIntoCode property is also set to
false in some versions.

Try checking the special key thingie, close and reopen, or if necessary
do something along the lines of the following air code

with currentdb
.Properties("AllowSpecialKeys") = true
.Properties("AllowBreakIntoCode") = true
end with

--
Roy-Vidar


.

Relevant Pages

  • Re: Access ignores my request for a code break - why?
    ... to break the code at that point so you can troubleshoot what you're ... Been playing with the database properties, ... Use Access Special Keys from Tools | Startup? ... When unchecking that ...
    (comp.databases.ms-access)
  • Re: Access ignores my request for a code break - why?
    ... Been playing with the database properties, ... Use Access Special Keys from Tools | Startup? ...
    (comp.databases.ms-access)
  • Re: Access XP >> 2000 >> 97
    ... database) to AccXP, instead you only opened it as the Acc2000 format. ... database to Acc97 using AccXP, ... For more methods to troubleshoot the database corruption issue, ...
    (microsoft.public.access.conversion)
  • RE: I didnt think of this
    ... Private Sub Form_Open ... Dim myDB As DAO.Database ... defined database properties to control it. ... When the user first opens the database, ...
    (microsoft.public.access.formscoding)
  • Re: Access module does not continue past the Filter Method
    ... Special Keys will prevent the interruption of the code. ... So, in the orignal database, when I turned "Use Access Special Keys" back ... I verified that in this state I still do not receive runtime error ...
    (microsoft.public.access.modulesdaovba)