I have an application that I will be sending out, and expect people to send
me a check within 30 days. How do I program an application "kill" feature if
I don't email them the proper code upon payment?

My initial thought is to have a startup form that shuts down the application
on the open statement is the current date exceeds the kill date, and they
have not entered a valid code which will be stored in a table.

Is this a valid method? How is it normally done? I distribute Accress
2000 runtime versions of the application.

Any help would be appreciated

Frank Wagner


--
Frank Wagner
(E-Mail Removed)

Hi,
yes you can use the first forms on load or on open event e.g.:

If DCount("[SerialField]","TableName") = 0 AND Date()>#YourDate# Then
MsgBox("Sorry...past 30 days and no serial yet!")
Application.Quit
End If

You could also limit the amount of records they can input if you wanted that
instead (would be a similar approach with the dcount function).
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de


"Frank Wagner" wrote:

> I have an application that I will be sending out, and expect people to send
> me a check within 30 days. How do I program an application "kill" feature if
> I don't email them the proper code upon payment?
>
> My initial thought is to have a startup form that shuts down the application
> on the open statement is the current date exceeds the kill date, and they
> have not entered a valid code which will be stored in a table.
>
> Is this a valid method? How is it normally done? I distribute Accress
> 2000 runtime versions of the application.
>
> Any help would be appreciated
>
> Frank Wagner
>
>
> --
> Frank Wagner
> (E-Mail Removed)

See this page on my site for several options:

http://home.bendbroadband.com/conrad...odatabase.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"Frank Wagner" wrote in message:
news:47AE588B-55E1-491E-A16D-(E-Mail Removed)...

> I have an application that I will be sending out, and expect people to send
> me a check within 30 days. How do I program an application "kill" feature if
> I don't email them the proper code upon payment?
>
> My initial thought is to have a startup form that shuts down the application
> on the open statement is the current date exceeds the kill date, and they
> have not entered a valid code which will be stored in a table.
>
> Is this a valid method? How is it normally done? I distribute Accress
> 2000 runtime versions of the application.
>
> Any help would be appreciated