Art-
In the Load event of the startup form, open the table and look at InstallDate. If it's empty, put Date() in it and then let the app run. If it has a value, test to see if is more than n days ago. If it is, use MsgBox to tell the user that the trial period has ended and then do Application.Quit.
If the user wants to bother, he can set his system date back temporarily to run the app.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Aug 7, 2017, at 7:49 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
I created a table called tblversion:
Columns
Name Type Size
Version Currency 8
VersionDate Date With Time 8
InstallDate Date With Time 8
InstallDateCount Long Integer 4
OpenCount Long Integer 4
InstallationTypeID Long Integer 4
InstallSubTypeID Long Integer 4
BuildNumber Short Text 255
BuildDate Short Text 255
DBAllowed Long Integer 4
GroupsAllowedID Long Integer 4
DocumentLimit Long Integer 4
InternalMachineID Short Text 255
Name Type Size
Version Currency 8
VersionDate Date With Time 8
InstallDate Date With Time 8
InstallDateCount Long Integer 4
OpenCount Long Integer 4
InstallationTypeID Long Integer 4
InstallSubTypeID Long Integer 4
BuildNumber Short Text 255
BuildDate Short Text 255
DBAllowed Long Integer 4
GroupsAllowedID Long Integer 4
DocumentLimit Long Integer 4
InternalMachineID Short Text 255
I have Install date and install date count, what would the next step be?
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, author
John Viescas, author
Effective 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:
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar