Senin, 07 Agustus 2017

Re: [MS_AccessPros] Trial screen

 

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 

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
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:


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: 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