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

On Fri, 06 Apr 2007 19:44:50 +0200, RoyVidar
<roy_vidarNOSPAM@xxxxxxxx> wrote:

Good call, Roy!
Never underestimate the !@#$%^ some people will get themselves in by
going where they shouldn't.

-Tom.



"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

.

Relevant Pages

  • 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)
  • 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? ...
    (comp.databases.ms-access)
  • 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: Locking a database
    ... bar), including disabling Access Special Keys. ... also suggest you convert your *Frontend* database to an mdE ... this will protect form, reports, and standard modules from ...
    (microsoft.public.access.forms)
  • RE: I didnt think of this
    ... defined database properties to control it. ... When the user first opens the database, ... Private Sub Form_Open ... Dim myDate As Date ...
    (microsoft.public.access.formscoding)