With Warm Regards,
Hi Art
Me.InstallDateCount is the number of days since installation, so to get the remaining days you simply subtract this from 60:
Me.RemainingDays = 60 - Me.InstallDateCount
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 10 August 2017 09:46
To: crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Trial screen
OK. So I did that and I am right there...
Me.TrialEndDate = DateAdd("d", 60, Me.InstallDate)
Me.InstallDateCount = DateDiff("d", Me.InstallDate, Date)
Me.RemainingDays = DateAdd("d", -InstallDateCount, Me.TrialEndDate)
But I need the number of days returned in Me.RemainingDays but right now its returning a date,
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Valar Dohaeris"
On Wednesday, August 9, 2017 04:10:34 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
hi Art,
what you want to do, then is use DateAdd (not DateDiff, which gets difference between 2 dates)
DateAdd( interval, number, date )
respectfully,
crystal
~ have an awesome day ~
On 8/9/17 3:15 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:
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. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (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 SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building 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 (16) |
Tidak ada komentar:
Posting Komentar