<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
        BEHAVIOR: url(#default#VML)
}
o\:* {
        BEHAVIOR: url(#default#VML)
}
w\:* {
        BEHAVIOR: url(#default#VML)
}
.shape {
        BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="PostalCode"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="State"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>
st1\:*{behavior:url(#default#ieooui) }
</STYLE>
<![endif]-->
<STYLE>
<!--a:link
        {mso-style-priority: 99
;}
span.MSOHYPERLINK
        {mso-style-priority: 99
;}
a:visited
        {mso-style-priority: 99
;}
span.MSOHYPERLINKFOLLOWED
        {mso-style-priority: 99
;}
/* Font Definitions */
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:"Bradley Hand ITC";
        panose-1:3 7 4 2 5 3 2 3 2 3;}
@font-face
        {font-family:Calibri;}
@font-face
        {font-family:"Comic Sans MS";
        panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:Calibri;
        color:black;}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
        {mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";
        color:windowtext;}
p
        {mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";
        color:black;}
span.EmailStyle17
        {mso-style-type:personal;
        font-family:Calibri;
        color:windowtext;}
span.EmailStyle19
        {mso-style-type:personal-reply;
        font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
-->
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue bgColor=white>
<DIV><FONT face=Arial size=2>Check with Tremaine Parsons. I don't mind sharing,
but I'd be able to provide zero, nada, zip support, so I don't think we'd get
far.</FONT></DIV>
<DIV><FONT face=Arial size=2>Fenton</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=deanmay@pianorebuilders.com
href="mailto:deanmay@pianorebuilders.com">Dean May</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=pianotech@ptg.org
href="mailto:pianotech@ptg.org">'Pianotech List'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, April 12, 2008 11:14
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Customer Database</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Are any of you who’ve
developed these Access programs willing to share?
<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoAutoSig><B><FONT face="Bradley Hand ITC" color=navy size=6><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 22pt; COLOR: navy; FONT-FAMILY: 'Bradley Hand ITC'">Dean</SPAN></FONT></B><FONT
color=navy><SPAN style="COLOR: navy"><o:p></o:p></SPAN></FONT></P>
<P class=MsoAutoSig style="MARGIN: 0in 0in 0pt"><U1:PERSONNAME
u2:st="on"><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">Dean
May</U1:PERSONNAME>
cell 812.239.3359 <o:p></o:p></SPAN></FONT></P>
<P class=MsoAutoSig style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman"
color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">PianoRebuilders.com
812.235.5272 <o:p></o:p></SPAN></FONT></P>
<P class=MsoAutoSig style="MARGIN: 0in 0in 0pt"><U1:PLACE u2:st="on"><U1:CITY
u2:st="on"><st1:place w:st="on"><st1:City w:st="on"><FONT
face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><U3:PLACE u4:st="on"><U3:CITY
u4:st="on">Terre Haute</SPAN></FONT></st1:City><FONT color=navy><SPAN
style="COLOR: navy"></U3:PLACE></U1:CITY></U3:CITY> <U1:STATE
u2:st="on"><st1:State u5:st="on"><st1:State
w:st="on">IN</st1:State></U1:STATE></st1:State> <U1:POSTALCODE
u2:st="on"><st1:PostalCode u6:st="on"><st1:PostalCode
w:st="on">47802</st1:PostalCode></U1:POSTALCODE></st1:PostalCode></SPAN></FONT></st1:place></U1:PLACE><FONT
color=navy><SPAN style="COLOR: navy"><o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: windowtext; FONT-FAMILY: 'Times New Roman'">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Tahoma"> <A
href="mailto:pianotech-bounces@ptg.org">pianotech-bounces@ptg.org</A>
[mailto:pianotech-bounces@ptg.org] <B><SPAN style="FONT-WEIGHT: bold">On
Behalf Of </SPAN></B>Mark Dierauf<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Saturday, April 12, 2008 1:22
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Pianotech
List<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: Customer
Database</SPAN></FONT><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: windowtext; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt">I parted my MS Access tables over to SprintDb Pro for
the Pocket PC ( <A href="http://www.kaione.com/">http://www.kaione.com/</A> ).
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. <BR><BR>- Mark Dierauf<BR><BR>Fenton Murray wrote:
<o:p></o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->Michelle,</SPAN></FONT><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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.</SPAN></FONT><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Fenton</SPAN></FONT><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P></DIV>
<BLOCKQUOTE
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; MARGIN: 5pt 0in 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: medium none">
<DIV style="font-size-adjust: none; font-stretch: normal">
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----- Original Message -----
<o:p></o:p></SPAN></FONT></P></DIV>
<DIV
style="BACKGROUND-POSITION: 0% 50%; BACKGROUND-ATTACHMENT: scroll; font-size-adjust: none; font-stretch: normal; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial">
<P class=MsoNormal style="BACKGROUND: #e4e4e4"><B><FONT face=Arial
color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">From:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <A
title=l-bartlett@sbcglobal.net href="mailto:l-bartlett@sbcglobal.net"
moz-do-not-send="true">Leslie Bartlett</A>
<o:p></o:p></SPAN></FONT></P></DIV>
<DIV style="font-size-adjust: none; font-stretch: normal">
<P class=MsoNormal><B><FONT face=Arial color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">To:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <A
title=pianotech@ptg.org href="mailto:pianotech@ptg.org"
moz-do-not-send="true">'Pianotech List'</A>
<o:p></o:p></SPAN></FONT></P></DIV>
<DIV style="font-size-adjust: none; font-stretch: normal">
<P class=MsoNormal><B><FONT face=Arial color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sent:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
Saturday, April 12, 2008 7:42 AM<o:p></o:p></SPAN></FONT></P></DIV>
<DIV style="font-size-adjust: none; font-stretch: normal">
<P class=MsoNormal><B><FONT face=Arial color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Subject:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> RE:
Customer Database<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p> </o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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.</SPAN></FONT><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">les <st1:City
w:st="on"><st1:place
w:st="on">bartlett</st1:place></st1:City></SPAN></FONT><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p> </o:p></SPAN></FONT></P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><FONT face=Tahoma
color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <A
href="mailto:pianotech-bounces@ptg.org"
moz-do-not-send="true">pianotech-bounces@ptg.org</A> [<A
href="mailto:pianotech-bounces@ptg.org">mailto:pianotech-bounces@ptg.org</A>]
<B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Michelle
Smith<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Saturday, April
12, 2008 8:01 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
'Pianotech List'<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
Customer Database</SPAN></FONT><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt">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. <o:p></o:p></SPAN></FONT><U5:P></U5:P></P>
<P class=MsoNormal><U5:P><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt"> <o:p></o:p></SPAN></FONT></U5:P></P>
<P class=MsoNormal><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt">In addition to this, we’re working on a feature that
would automatically send e-mail reminders to customers.
<o:p></o:p></SPAN></FONT><U5:P></U5:P></P>
<P class=MsoNormal><U5:P><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt"> <o:p></o:p></SPAN></FONT></U5:P></P>
<P class=MsoNormal><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt">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. <o:p></o:p></SPAN></FONT><U5:P></U5:P></P>
<P class=MsoNormal><U5:P><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt"> <o:p></o:p></SPAN></FONT></U5:P></P>
<P class=MsoNormal><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt">Has anyone seen a piece of software like this?
I don’t want to reinvent the wheel.
<o:p></o:p></SPAN></FONT><U5:P></U5:P></P>
<P class=MsoNormal><U5:P><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt"> <o:p></o:p></SPAN></FONT></U5:P></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Comic Sans MS'">Michelle
Smith<U5:P></U5:P></SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Comic Sans MS'">Smith Piano
Service<U5:P></U5:P></SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><FONT
face="Comic Sans MS" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Comic Sans MS'">Bastrop</SPAN></FONT></st1:City><FONT
face="Comic Sans MS" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Comic Sans MS'">, <st1:State
w:st="on">Texas<U5:P></U5:P></st1:State></SPAN></FONT></st1:place><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><U5:P> </U5:P></SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><U5:P> </U5:P></SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><U5:P><FONT face=Calibri color=black size=2><SPAN
style="FONT-SIZE: 11pt"> <o:p></o:p></SPAN></FONT></U5:P></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face="Times New Roman" color=black size=2><SPAN
style="FONT-SIZE: 10pt">No virus found in this incoming message.<BR>Checked
by AVG.<BR>Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
04/11/2008 4:59 PM</SPAN></FONT><o:p></o:p></P></BLOCKQUOTE>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p> </o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>