login form with password expiration in 30 days (1 Viewer)

[isladogs]

Not quite correct.
There are two universal date formats that can be used in VBA: mm/dd/yyyy and yyyy-mm-dd

In the UK we use dd/mm/yyyy which has to be converted in VBA for reliable results.
Dates like 17/02/2020 cannot be misinterpreted as anything other than 17 Feb 2020
However a date like 10/02/2020 could be 10 Feb or 2 Oct.
Access will assume the latter which in the UK will cause issues

Good luck with the rest of your project

 

[theDBguy]

thanks for your advice, nice guy Isladogs resolve the problem.

Hi Elena. That's good! Good luck with your project.

 

[lacampeona]

thank you

if i will have problems with my ideas

can I ask here for some help again ?

Best regards
Elena

 

[theDBguy]

thank you

if i will have problems with my ideas

can I ask here for some help again ?

Best regards
Elena

Hi Elena. Probably better to start a new thread for your next question(s). You could get more help that way. Cheers!

 

[lacampeona]

Ok I will start new threads
thank you
Elena

 

[theDBguy]

Ok I will start new threads
thank you
Elena

You're welcome. Good luck!