How can I convert todays date to hex for use as password validation??
For example, todays date 11202006 = AAEDD6
If password entered = AAEDD6, and today's date = November202006, then allow
access, else exit sub.
I was given the following to try, but I am not quite clear on the syntax to
use in a IF Then Else statement:
Hex(CLng(Format(Date(), "mmddyyyy")))
Thanx in advance
Walter
Rick Brandt - 20 Nov 2006 15:44 GMT
> How can I convert todays date to hex for use as password validation??
> For example, todays date 11202006 = AAEDD6
[quoted text clipped - 4 lines]
> use in a IF Then Else statement:
> Hex(CLng(Format(Date(), "mmddyyyy")))
If PasswordEnteredByUser = Hex(CLng(Format(Date(), "mmddyyyy"))) Then...

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com