<!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:m = "http://schemas.microsoft.com/office/2004/12/omml"><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.6000.16640" name=GENERATOR> <STYLE>@font-face { font-family: Cambria Math; } @font-face { font-family: Calibri; } @font-face { font-family: Comic Sans MS; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; } P.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif" } LI.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif" } DIV.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif" } A:link { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } A:visited { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.EmailStyle17 { COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose } .MsoChpDefault { mso-style-type: export-only } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=EN-US vLink=purple link=blue bgColor=#ffffff> <DIV><FONT face=Arial size=2>Michelle,</FONT></DIV> <DIV><FONT face=Arial size=2>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.</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=l-bartlett@sbcglobal.net href="mailto:l-bartlett@sbcglobal.net">Leslie Bartlett</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 7:42 AM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Customer Database</DIV> <DIV><BR></DIV> <DIV dir=ltr align=left><SPAN class=346564114-12042008><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=346564114-12042008><FONT face=Arial color=#0000ff size=2>les bartlett</FONT></SPAN></DIV><BR> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> <A href="mailto:pianotech-bounces@ptg.org">pianotech-bounces@ptg.org</A> [mailto:pianotech-bounces@ptg.org] <B>On Behalf Of </B>Michelle Smith<BR><B>Sent:</B> Saturday, April 12, 2008 8:01 AM<BR><B>To:</B> 'Pianotech List'<BR><B>Subject:</B> Customer Database<BR></FONT><BR></DIV> <DIV></DIV> <DIV class=Section1> <P class=MsoNormal>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></P> <P class=MsoNormal><o:p> </o:p></P> <P class=MsoNormal>In addition to this, we’re working on a feature that would automatically send e-mail reminders to customers.  <o:p></o:p></P> <P class=MsoNormal><o:p> </o:p></P> <P class=MsoNormal>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></P> <P class=MsoNormal><o:p> </o:p></P> <P class=MsoNormal>Has anyone seen a piece of software like this?  I don’t want to reinvent the wheel.  <o:p></o:p></P> <P class=MsoNormal><o:p> </o:p></P> <P class=MsoNormal><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Michelle Smith<o:p></o:p></SPAN></P> <P class=MsoNormal><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Smith Piano Service<o:p></o:p></SPAN></P> <P class=MsoNormal><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Bastrop, Texas<o:p></o:p></SPAN></P> <P class=MsoNormal><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P> <P class=MsoNormal><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P> <P class=MsoNormal><o:p> </o:p></P></DIV><BR> <P><FONT size=2>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<BR></FONT></P></BLOCKQUOTE></BODY></HTML>