Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-18-2007, 06:23 AM   #1
mattkorguk
Newly Registered User
 
mattkorguk's Avatar
 
Join Date: Jun 2007
Location: Surrey, England
Posts: 299
Thanks: 7
Thanked 6 Times in 5 Posts
mattkorguk is on a distinguished road
Unhappy capturing F11 press, possible?

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

mattkorguk is offline   Reply With Quote
Old 09-18-2007, 06:59 AM   #2
Guus2005
AWF VIP
 
Guus2005's Avatar
 
Join Date: Jun 2007
Location: The Netherlands
Posts: 2,480
Thanks: 39
Thanked 78 Times in 74 Posts
Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about
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?
Attached Files
File Type: zip MacroAutoKeys.zip (8.5 KB, 109 views)
Guus2005 is offline   Reply With Quote
Old 09-18-2007, 07:16 AM   #3
mattkorguk
Newly Registered User
 
mattkorguk's Avatar
 
Join Date: Jun 2007
Location: Surrey, England
Posts: 299
Thanks: 7
Thanked 6 Times in 5 Posts
mattkorguk is on a distinguished road
Nice one, I shall try that in the morning.
Thank you.

mattkorguk is offline   Reply With Quote
Old 09-18-2007, 07:19 AM   #4
odin1701
Newly Registered User
 
Join Date: Dec 2006
Posts: 526
Thanks: 1
Thanked 3 Times in 3 Posts
odin1701 is on a distinguished road
Why do they have access to the database window? Why don't you disable that and disable the shift bypass key?
odin1701 is offline   Reply With Quote
Old 09-19-2007, 12:37 AM   #5
mattkorguk
Newly Registered User
 
mattkorguk's Avatar
 
Join Date: Jun 2007
Location: Surrey, England
Posts: 299
Thanks: 7
Thanked 6 Times in 5 Posts
mattkorguk is on a distinguished road
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.

mattkorguk is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Automated Press adverts - via the use of a database? budgy General 1 01-31-2006 11:59 AM
DB Window has disapeared and f11 and holding shift will not bypass....HELP! JSDART!! General 5 03-15-2004 06:34 AM
Select start and end dates AND press Enter for all macherie Queries 9 11-13-2003 05:29 PM
Make an asterisk appear in a text box when I press enter? Jenny Peters Forms 0 01-07-2003 08:30 PM
F11 Key Hayley Baxter General 2 08-14-2002 04:09 AM




All times are GMT -8. The time now is 05:21 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World