Setting a trial version of my database

[Emmanuel]

I have a database which i will like to set a trial version for users to use after which they will not able to use the database when the time is over .
i googled and found these codes which i have tried and still not working.

i applied them on the onload event of the login form

"If Now() - 10 > CDate("2/7/2021") Then
MsgBox "Yo!"


DoCmd.Close acForm, Me.frm_login, acSaveNo
End If"


What didnt i do right. Kindly help.

[Welshgasman]

Have you tried debug.print on those values to see what it produces?

? Now() - 10
22/06/2021 12:39:59 
? CDate("2/7/2021")
02/07/2021

[Emmanuel]

Have you tried debug.print on those values to see what it produces?

? Now() - 10
22/06/2021 12:39:59 
? CDate("2/7/2021")
02/07/2021

how do i do that?

[Welshgasman]

Go into the Immediate window (Ctrl + G)
then type in ? and whatever variables you are using?

You can see from the above where I have done that, and the result is on the next line.

That shows you what those values are?

[ranman256]

use date math: DateAdd() or DateDiff()

or just say
if DAte() > #12/1/2021# then docmd.quit

[Micron]

It is difficult to enforce trial versions of Access because it's so hackable. Not saying I'm great at it, but if you get this working and want someone to test whether or not your efforts can be overcome, post an expired version and we'll see if it can be opened and used.

[Emmanuel]

use date math: DateAdd() or DateDiff()

or just say
if DAte() > #12/1/2021# then docmd.quit

Interesting code
Let me try it out and see

[Welshgasman]

There is nothing wrong with your approach if you get your logic correct?

[CJ_London]

Be aware that dates need to be in us format . 2/7 could be interpreted as 7th feb

[isladogs]

If you are going to do this, I suggest you also check for anyone changing the system date using the code provided in an earlier thread of yours Correct system date before database can start successfully (accessforums.net)

[Welshgasman]

If you are going to do this, I suggest you also check for anyone changing the system date using the code provided in an earlier thread of yours Correct system date before database can start successfully (accessforums.net)

I was going to suggest that to test the o/p's code logic.

[Emmanuel]

Well noted guys. Thanks for your suggestions