Re: Time bomb a DB

I guess I was not expecting this to be this controversial. Because is it - let me explain my reasoning.
My Proposals with this client have been "Final Payment due upon Delivery"
That is our standard proposal.
However that is more to cover my ass.
My policy has always been to ask the client when the relationship first starts - what is their payment practices?
With this client they said if I invoice before a Wed then the invoice will be processed on Wed and Check will be mailed on Friday.
We have worked on those terms for about a year now.
I presented an invoice on Monday Jan 12th for work done in Dec.
Should have gotten a check the following week.
On Tue the 27th she emailed me that she would like me to come in and train her staff on Fri the 30th.
I email back saying I would be glad to and - Oh By the way, I have not received my check yet can I just pick it up when I am at her office.
She replied that they had changed venders for the new year and that all checks would take 30 days to process.
I believe she is completely with in her right to change payment policies (and 30 days is a not un common practice)
However a change in policy should have been mentioned before requesting new work and at least when presenting the invoice.
I went in to her office as I agreed on the 27th and trained her staff but she continentally did not have time to talk with me. I also learned on the 27th from one of her staff members that my invoice had not even been presented to the vendor yet - so the 30 day clock is not yet ticking.

That's my story.

I did time bomb the frmMain navigation form) and set it at 60 days
I do like Danny's suggestion and I am using his verbiage word for word.
I was going to say something like (Your Trial Period has expired.blah, blah, blah)

also I am not damaging/deleting their data. Only closing the application after the message box pops up.

She has been shown (Although probably does not remember) to use the Shift key to get to the tables. This also means they could bypass the opening form and do everything the DB is designed for. I doubt they will realize that.

Thanks for all the replies and insight

dave


"Dave" <dave@accessdatapros> wrote in message news:1334F4E4-615E-49E2-A920-D731688C27EE@xxxxxxxxxxxxxxxx
Access 2007

How difficult is it to time bomb a DB.

Can I do something as simple as the onload event of frmMain checks the date and if the date is greater then some hard coded date then a message box pops up saying "trial period is over" and then closes the program after 30 seconds?

comments on that approach or other suggestions appreciated

dave

.

Relevant Pages

  • RE: Dynamic Creation of Invoice number
    ... which is the table of proposals ID ... The macro could take care of unlocking, ... VAT tax - generated when cost is entered ... Take the output of the client ID file, wrap the P/ before it, and add the 3 ...
    (microsoft.public.excel.programming)
  • Re: Multiple Records from Access Query
    ... invoice records using the mergefield method outlined in the tutorial. ... client concerned - too many or too few and everything will get out of synch. ... You can use Word's Catalogue/Directory Mailmerge facility for this. ... records in Access for the same [Vendor], ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Dynamic Creation of Invoice number
    ... I assume that I would have one sheet per year. ... My real accounting data is in my accounting program, ... based by client. ... the reason that I don't want clients knowing how many proposals I generate). ...
    (microsoft.public.excel.programming)
  • Re: Duplicate entries
    ... Client details ... have done one piece of work for one client, invoice 2 and this remains unique. ... you are seeing multiples in a query or in a form based on the query? ... I have developed duplicate duplicate entries. ...
    (microsoft.public.access.queries)
  • Re: Doc always seems to be on vacation on previously proposed paydays
    ... I would email and complain and now they say that their other "vendors" have net 45 days. ... The sad thing is that my client is a multibillion dollar audiovisual production company and I happen to know that they are always late paying bills such as their Earthlink internet account. ... I let go a client a couple of years ago because she was a doc signing her own checks, would never stiff me on an invoice, but I always had to send the invoice, wait X number of days, call/email to inquire if the dang thing had been paid, and I just got sick of it, so I gave her 30 days' notice. ...
    (sci.med.transcription)
Loading