Form Locking

Hot Topic

Adding a command button to the toolbar or menu bar in Excel?
Need to detect whether Access subform currently shows vertical scrollbar (urgent??!)
Text file search, return data from line other than search string line
Inserting additional chars into a string....
LBound and UBound functions
Excel2003 VBA - Application.quit not stopping code
Post-Empower ISV Options
Edit DataLabel in Excel charts
Elegance (and performance) Problem
ASP .NET 1.1 fails at install, but not .NET Framework 1.1

Microsoft ISV

key in date and filter the data in a week
OPC and C#
Can't open regedit
[ADO Excel] How to use ADO retrieve Excel Worksheet name and some information
"How to" Programatically hide or display pivot items of pivot field
VBA registry interface
Dynamics decrease performance
iexplore.exe - Application Error
Vlookup from various files
API (HLLAPI) errors when accessed from VBA.

Form Locking

Hi,

I am creating an EPOS system in access/vba, with an SQL 2005 connection.

Learning as I go I have managed to create a login keypad which checks your code input against the database to see if the login is valid.

The way I see this keypad being used, is everytime the application is flagged as locked, the keypad appears and locks out other open forms until the correct code is entered.

Am I thinking about this the right way is this the way that access would work, IF i knew code to do it

Thanks, Dan

Answer this question

Form Locking

  • Michael Herman - Parallelspace

    Moving to the VBA forum:

    When you want to lock your application show the keyboard form modally and don't dismiss the keyboard form until the correct code is input. When you show a form modally it will maintain the focus and no other form or control in the application can be selected until the form is closed



  • ClemensT

    Perfect :) thanks..
  • Form Locking
Answer this question