Info For All Forum Members

[statsman]

Just for the hell of it, I took on 3 Access projects during 2006 that people were looking to pay for here on the forum. I was pretty sure what the outcome would be but I did the projects anyway just to make sure. None of them were difficult and I certainly didn't charge that much.

All 3 of the cheap so & sos stiffed me (I just wrote off the the last one this weekend).

 

[boblarson]

Probably a good thing not to take work from people here then. Maybe you should post their usernames in this thread so that others can be warned and/or they can be shamed into paying (odds of that are probably 2,000,000,000 to 1).

 

[statsman]

Actually, I've never seen a second post from any of them.

I assume they'e now on another Access forum looking for more suckers.

 

[davidlk]

Dear Friends,
I have designed a database which is similar to Northwind Sample db.

My problem is : I want to have the unit price in variable currencies (USD , Euro & YER) in the order form, after selecting the product. I have inserted an option to select the currency type on the main form. How could I achieve this function to print the report in multiple currencies (converted values) whenever needed. Of course, ex-rates should be updated time to time.

If you wish to see my sample db, I will forward a copy of it with required objects only.

Thanking you very much for your prompt action and response.
*David Ganesh*

 

[KalelGmoon]

Dear Friends,
I have designed a database which is similar to Northwind Sample db.

My problem is : I want to have the unit price in variable currencies (USD , Euro & YER) in the order form, after selecting the product. I have inserted an option to select the currency type on the main form. How could I achieve this function to print the report in multiple currencies (converted values) whenever needed. Of course, ex-rates should be updated time to time.

If you wish to see my sample db, I will forward a copy of it with required objects only.

Thanking you very much for your prompt action and response.
*David Ganesh*

this should be in one of the ACCESS threads not the cooler

 

[pono1]

All 3 of the cheap so & sos stiffed me (I just wrote off the the last one this weekend).

Did they approach you, offering X amount of dollars for Y amount of work? What happened? (I hope you don't mind me asking...)

 

[statsman]

Essentially their posts said they needed a database and were willing to pay. We haggled over price by Email. They agreed and I did the work.

 

[dan-cat]

I do mostly web work now, so can make sure that no work is uploaded to theor location until they pay up. I still keep the FTP details to myself unless they insist on them.

With Access, I always put a 'trial expiry date' system into the code and hid it the best I could in VBA. Once payment was made, I gave them a code to bypass it. Might be an interesting exercise for you to try this out next time.

 

[GaryPanic]

I hope they get Scurvey, Suvery,Sucvery ...ah bugger . Warts !
and the trail thing was something i was going to recommend
G

 

[pono1]

Agree with others, the trial period and scurvy. Also, asking for a 25-50% down payment -- before work commences -- is not always a bad thing to do.

 

[Fifty2One]

i have been screwed over on the net and not just with making apps on the puter for folks...

once you get good and fed up the best solution is to code in a self destruct so when you deliver a product with net 30 days on the billing they will contact you at the latest 31 days later

and if they say the check is in the mail tell them the solution will be coming via return mail

 

[Lister]

Expanding on this. And I know this is not really the place for this but. Since it dose suck that you can opt to do work for persons and then have them u turn once the product is delivered.
There has been comment here in putting locking code and destructive code into an app.
I have seen and played with security code. But what would be lock or destructive code? Just wondering.
Or should this be moved to the open forum.

 

[Timtropolis]

couple ways to get around getting stiffed...

I've been in this same situation on a couple of occasions over my years as an Access consultant. Here are a couple things that may help others in the future.

1. agree on a $$$ amount, then, set it up where you get 1/2 up front, other half upon delivery. Good idea to have a solid set of agreed on spec before proceeding as well.

2. Only deliver an MDE instead of an mdb file. That way your work is protected and if they need to do more work, they have to come back to you.
Once you are paid in full, release the MDB file to the customer

3. staying on the same theme as #2, deliver an MDE but place code inside of the mde that causes the database to shutdown after a certain date/so many uses. While this may sound cheesy, I have found this to be a VERY effective motivator when dealing with companies/people who refuse to pay. Again, once payment is received, deliver the MDB file.