capturing F11 press, possible? (1 Viewer)

mattkorguk

Registered User.

Local time

Today, 06:43

Joined

Jun 26, 2007

Messages

301

• Sep 18, 2007

• #1

Hi,
I've read a few posts regarding removing the facility of the F11, open Db window, but is there a way to capture if someone presses F11?
I have a few people (users) who think they know a thing or two about Access and I'd like to know if/ when they're accessing the Db window.

I was hoping for the ASCI code or similar for the F11 key!?
Thanks
Matt

 

Guus2005

AWF VIP

Local time

Today, 07:43

Joined

Jun 26, 2007

Messages

2,645

• Sep 18, 2007

• #2

Create a macro named AutoKeys.
See the attached picture
It catches F11 and redefines ^F12 to impersonate F11.

They don't know that shift also stops execution of the AutoExec macro?

 

Attachments

• MacroAutoKeys.zip

  8.5 KB · Views: 141

mattkorguk

Registered User.

Local time

Today, 06:43

Joined

Jun 26, 2007

Messages

301

• Sep 18, 2007

• #3

Nice one, I shall try that in the morning.
Thank you.

 

O

odin1701

Registered User.

Local time

Yesterday, 23:43

Joined

Dec 6, 2006

Messages

526

• Sep 18, 2007

• #4

Why do they have access to the database window? Why don't you disable that and disable the shift bypass key?

 

mattkorguk

Registered User.

Local time

Today, 06:43

Joined

Jun 26, 2007

Messages

301

• Sep 19, 2007

• #5

Guus2005 - Thanks, works a treat.

Odin1701 - I'd like to record who is using the Db window to create their own queries etc before locking the system down. This can then raise questions regarding the current reporting functionality we offer and the future development areas. We are trying to more everyone to Runtime version which will also stop this, but as we have some other developers users our Dbs they will always have a full version.