F9 crashes database

[kt2902]

I have a form (with a subform) that has worked fine until last week. Now if
it is open, and the user presses F9 then the database shuts down and wants to
send error reports to Microsoft.

I've checked that AutoCorrect is off, I have decompiled, compacted and
repaired. I've even tried importing everything into a new blank database, but
the error still occurs.

The only workaround I have been able to come up with is to add {f9} to my
autokeys macro and set it to call Requery. This appears to have fixed the
problem, although I'm not sure that this won't have wider ramifications.

Does anyone have any ideas?

Thanks in advance

Katie

 

[Peter Hibbs]

Katie,

You are right, it does the same on my database (Access 2003) although
it doesn't crash out completely, it just plays havoc with some
totalling fields.

According to the Help file this key normally executes a Requery for
any Combo box or List box that has the focus but why it should crash
your database, I don't know. Look up "Keyboard Shortcuts -> Global
Access shortcut keys" in the Help file for more information.

If you don't need this facility then your solution would be OK except
that I would not execute a Requery when the key is pressed, I normally
just leave the Action column blank in the AutoKeys Macro so that the
key has no effect.

Incidentally, have you also done the same for some other keys which
can cause problems for novice users such as CNTL + N, CNTL + O, CNTL +
S, CNTL + P, CNTL + W, CNTL + G, etc.

Peter Hibbs.

 

[Jerry Whittle]

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

 

[Jerry Whittle]

I recommend taking the database file to another computer and see if it does
the same thing there. It may not be the database; rather it could be Access
or Office that is the problem. Maybe an auto update is causing a new bug.

 

[kt2902]

Thanks Peter and Jerry for your advice.

The front end is installed on a couple of computers and they all cause the
same crash, so I don't think it can be that (unless we've all installed the
same updates).

And yes Peter, I learned the hard way to turn the other keys off, after
users were complaining that my database was doing weird things - nothing to
do with the keys they were pressing obviously