ACCESS FEED: [MS_AccessPros] Re: Login Form

Minggu, 05 Juni 2011

[MS_AccessPros] Re: Login Form

JOHN-
Thanks for your prompt response. The BeforeUpdate event procedure as suggested by you, gives message after password in entered. However, I want the warning when the focus is on the password field and even before the user presses any key. What is the ASCII key for caps lock key?

Thanks and Regards,
Kumar

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Kumar-
>
> I'm not sure if KeyPress or KeyDown will give you that info. You could check
> the entered data in the password control's BeforeUpdate event to see if they
> entered all caps and warn them then.
>
> Use the StrComp function to do a case-sensitive compare:
>
> If StrComp(Me.Pswd, UCase(Me.Pswd), vbBinaryCompare) = 0 Then
> MsgBox "You might have Caps Lock turned on."
> End If
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
> Sent: Sunday, June 05, 2011 6:00 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Login Form
>
> Dear all,
> I have a log-in form, which has case-sensitive password field. I want a
> warning to be displayed in a label when the CAPS Lock is on similar to when it
> is displayed when we log-on to windows. Can you suggest how I can accomplish
> this.
>
> Thanks and regards,
> Kumar
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>