Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 27th, 2003, 01:31 PM
Registered User
Join Date: Jul 2003
Location: San Antonio, Texas, .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Locking down my Form to prevent close or break

I have the need to create a Kiosk workstation for a convention.
It has single form but I need to prevent "Ctrl/Alt/Del" and remove to close form in the upper right hand corner. I have been able to prevent Ctrl/Break, but not the 3-finger salute ("Crtl/Alt/Del").

Also I need to know how to capture the function keys (like F7).

Any help would be appreciated


  #2 (permalink)  
Old July 27th, 2003, 09:37 PM
Friend of Wrox
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

To get rid of the close button, just make your forms maximized, popup,modal, and the Border style=None

To trap function keys, that's a little trickier, but not much.

On the KeyDown event of all your objects (including the form itself), check if the keys are the ones you want - for example:
If KeyCode = vbKeyF7 Then MsgBox "F7 was pressed"
Not too sure about CtrlAltDel, but another thing you might want to trap is CtrlShiftEsc - which brings up task manager, and from which you can do most anything.

I think the best option, considering it's a kiosk, is that you set up a Windows User Profile that can't do anything.
I can't tell you exactly how to do it - since I haven't played around with Windows security in a long time - but I'm sure many people reading this will have experienced paranoid moron sysadmins who don't even let their users open up the time on the workstation


I am a loud man with a very large hat. This means I am in charge

Similar Threads
Thread Thread Starter Forum Replies Last Post
Close all MdiChield form from open one form/Button salman .NET Framework 2.0 6 December 10th, 2007 03:21 AM
Calculate running total on form and prevent text Hughesie78 ASP.NET 2.0 Basics 0 November 27th, 2007 10:35 AM
Close all MdiChield form from open one form salman .NET Framework 1.x 0 November 8th, 2007 12:32 AM
Prevent accidental update from a form donevco Access 11 January 18th, 2007 11:30 AM
Form Locking dancook Access VBA 2 November 7th, 2006 11:38 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.