Customer Database

[Dean May]

Are any of you who've developed these Access programs willing to share? 

 

Dean

Dean May             cell 812.239.3359 

PianoRebuilders.com   812.235.5272 

Terre Haute IN  47802

 

  _____  

From: pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org] On Behalf
Of Mark Dierauf
Sent: Saturday, April 12, 2008 1:22 PM
To: Pianotech List
Subject: Re: Customer Database

 

I parted my MS Access tables over to SprintDb Pro for the Pocket PC (
http://www.kaione.com/ ). It involved redesigning the data-entry forms, but
uses the same data as my desktop, and is synced every time I drop the PPC
into its cradle. The biggest disadvantage with Access on the PPC is that you
can's update queries that use data from multiple tables, but it's possible
to use backdoor workarounds to overcome this limitation. Other than that,
SprintDb is a very robust program, with full subform capabilities, so one
can design pretty much anything you'd want. 

- Mark Dierauf

Fenton Murray wrote: 

Michelle,

I paid someone to customize Access for me. It took a while of working
together and was money very well spent, before that I used a DOS flat data
base. I enter/update a reminder date for each tuning manually. Let me know
what you're able to do with Pocket PC, I worked long and hard on that and to
date I'm only able to view Excel spread sheets of different tables, like
names and phone numbers, no relational capabilities. Anyway, I'm no computer
expert so I just pay people to do it.

Fenton

----- Original Message ----- 

From: Leslie Bartlett <mailto:l-bartlett at sbcglobal.net>  

To: 'Pianotech <mailto:pianotech at ptg.org>  List' 

Sent: Saturday, April 12, 2008 7:42 AM

Subject: RE: Customer Database

 

I don't know if Time and Chaos will do this......  It's a dumbed down
OUTLOOK, but it is more than adequate for me. Don't know if it will email
from particular fields, but their help people could give you that info.

les bartlett

 


  _____  


From: pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org] On Behalf
Of Michelle Smith
Sent: Saturday, April 12, 2008 8:01 AM
To: 'Pianotech List'
Subject: Customer Database

Hi guys.  I've been talking to my brother-in-law (who is a programmer) about
creating a customer database for my business.  It would of course have all
the usual fields concerning customer information, piano information and date
the piano was last tuned.  The thing I'm really wanting that I haven't seen
in other software programs is for it to send me reminders based on when the
piano was last tuned instead of when it should have been tuned.  For
example, I have a customer set up for reminders every 6 months.  If they
wait a couple of months to have their piano tuned, I want the program to
automatically shift future reminders based on their most recent tuning date.


 

In addition to this, we're working on a feature that would automatically
send e-mail reminders to customers.  

 

This information would hopefully be transferrable to a spreadsheet on my
PocketPC then I could also conceivably enter the info at the customer's home
and then sync it with the main database when I get home.  

 

Has anyone seen a piece of software like this?  I don't want to reinvent the
wheel.  

 

Michelle Smith

Smith Piano Service

Bastrop, Texas

 

 

 

 

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date: 04/11/2008
4:59 PM

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://www.moypiano.com/ptg/pianotech.php/attachments/20080412/1b355124/attachment.html