Ever Changing Passwords

[Carly]

I'm not sure where this post should be so I thought I would try General.

What I want to do is this:

Click a button on a form which opens some kind of password entry form or textbox

On entry of the correct password a certain report runs but if the password is incorrect or blank then another report runs.

The password however, if possible, needs to be ever changing, so that it is todays date backwards or something along those lines (i.e. 30028011,etc)

Is this possible??
Regards
Carly

 

[namliam]

It certainly is easy enough to turnaround todays date/time/hour
format(now(),"yyyymmddhh")
will give you 2003081112

Checking this against input given should then be easy enough

Regards

The Mailman

 

[Carly]

I have got a textbox on a form called [password] and in this textbox is a calculated number (todays date backwards).

I want this number to be the basis for a password, but how do I lookup this number to check whether a user has entered the correct password.

I have tried DLookup but it doesn't recognise the name of the textbox?

Regards
Carly

 

[Mile-O]

Here:

 

[namliam]

supposing that (I asume to be a hidden textbox) is on the current form:
me.Password = me.passwordGiven

You can reverence it like any control...

Regards