Me.InstallDateCount = DateDiff("d", Me.InstallDate, Date)
Me.RemainingDays = DateAdd("d", -InstallDateCount, Me.TrialEndDate)
With Warm Regards,
hi Art,
what you want to do, then is use DateAdd (not DateDiff, which gets difference between 2 dates)
respectfully,
crystal
~ have an awesome day ~
Could you help me with this code:
DayCount = DateDiff("d", Me.InstallDate, 60)
InstallDate is the date I start from and then I need DayCount to add one day each day that passes up to 60 days....
With Warm Regards,Arthur D. LorenziniIT System ManagerCheyenne River Housing AuthorityWk.(605)964-4265 Ext. 130Fax (605)964-1070
"Valar Dohaeris"
On Monday, August 7, 2017 11:02:16 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Art-
One technique is to put a "first used" date/time field in a hidden table. When your trial version starts up, check that field, and if it's Null, then set it to today's date. If it's not Null, then see if today is more than 60 days past the "first used" date, and if so, don't allow the application to start.
John Viescas, authorEffective SQLSQL Queries for Mere MortalsMicrosoft Office Access 2010 Inside OutMicrosoft Office Access 2007 Inside OutBuilding Access Applications
On Aug 7, 2017, at 07:46, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I am trying to create a trial information screen. We are making an evaluation version of our application and I would like to know if any one knows how to create a timer field that would decrease every 24 hours starting at 60 days and going to 0. The it would start locking the user out until they get a key or something? Any ideas?
Thank you, Art Lorenzini
Sioux Falls. SD
Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar