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

What are you asking? If you set the form to Pop Up = Yes and Modal = Yes, you can lock the app until something is done on the form.

How is the application "flagged as locked?"


mmcdonal

Thanks for the response,

I wouldn't worry about the 'flagged as locked' comment, the first part of your response has given me something to look at - and sounds like it could be the answer.

Cheers, Dan