Re: Access module does not continue past the Filter Method

Tech-Archive recommends: Speed Up your PC by fixing your registry

Yes, of course. Special Keys will prevent the interruption of the code.

Thanks for sharing the solution. I must remember to suggest that as a
possible cause of this odd behavior.

Regards

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dalbin" <dalbin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C066B451-A386-4081-9FAE-EF7D8E6A2C1A@xxxxxxxxxxxxxxxx
I fixed the problem, without recreating the database.

The problem is that when you turn off "Use Access Special Keys" in the
Startup Dialog Box, Access 2003 no longer gives any indication of runtime
errors.

I verified this by trying it on a totally different, and very simple
database. It caused the same problem.

So, in the orignal database, when I turned "Use Access Special Keys" back
on, I started getting runtime error messages. I opened my form, and
received
two "Invalid Use of Null" Errors in seemingly-unrelated fields. I fixed
those problems, and now everything works!

I then turned off "Use Access Special Keys", and the subroutine still
works.
I verified that in this state I still do not receive runtime error
messages.

Finally, I don't know why the two seemingly-unrelated errors caused the
subroutine to now fully execute. In this case, though, I am content to
"leave well-enough alone."

Allen, thank you for all of your help. The troubleshooting steps that
your
suggested helped to uncover the root of the problem.



"Allen Browne" wrote:

Just to be clear, we are talking about getting Access to rebuild the
database, not coding the whole thing again.

The steps for the first symptom in this article explains how:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html

"dalbin" <dalbin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:107A4926-F2F7-45C3-AB71-84233C9D0C42@xxxxxxxxxxxxxxxx
I have only seen the problem of "no runtime error messages" in this
database.
So, I guess the next step is to rebuild the database. This may take
some
time, but I'll post again once it is complete.


.

Relevant Pages

  • 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: 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: Get missing menu bar back
    ... "special keys", then type Ctrl+G to open the immediate window. ... You should get the Startup Options dialog box. ... reopen the database. ...
    (microsoft.public.access.forms)
  • RE: suppress SHIFT key
    ... untick allow access special keys. ... shift bypass the opening database though and you should retain a master copy ...
    (microsoft.public.access.formscoding)
  • Re: suppress SHIFT key
    ... You know something Douglas, you are absolutely right, I tried it on a spare ... I have thought that not allowing Special Keys prevented the ... To suppress the shift key bypass, you need to create a database property ...
    (microsoft.public.access.formscoding)