<html 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" xmlns="http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 11 (filtered medium)"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PostalCode"/> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="State"/> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"/>  <style>  </style>  </head> <body bgcolor=white lang=EN-US link=blue vlink=purple> <div class=Section1> Are any of you who’ve developed these Access programs willing to share? <o:p></o:p> <o:p> </o:p> <div> Dean<o:p></o:p> <u1:PERSONNAME u2:st="on">Dean May</u1:PERSONNAME>             cell 812.239.3359 <o:p></o:p> PianoRebuilders.com   812.235.5272 <o:p></o:p> <u1:PLACE u2:st="on"><u1:CITY u2:st="on"><st1:place w:st="on"><st1:City w:st="on"><u3:place u4:st="on"><u3:City u4:st="on">Terre Haute</st1:City></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></st1:place></u1:PLACE><o:p></o:p> </div> <o:p> </o:p> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center tabindex=-1> </div> From: pianotech-bounces@ptg.org [mailto:pianotech-bounces@ptg.org] On Behalf Of Mark Dierauf Sent: Saturday, April 12, 2008 1:22 PM To: Pianotech List Subject: Re: Customer Database<o:p></o:p> </div> <o:p> </o:p> 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. - Mark Dierauf Fenton Murray wrote: <o:p></o:p> <div> Michelle,<o:p></o:p> </div> <div> 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.<o:p></o:p> </div> <div> Fenton<o:p></o:p> </div> <blockquote style='border:none;border-left:solid black 1.5pt;padding:0in 0in 0in 4.0pt; margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'> <div style='font-size-adjust: none;font-stretch: normal'> ----- Original Message ----- <o:p></o:p> </div> <div style='-moz-background-clip: -moz-initial;-moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;font-size-adjust: none;font-stretch: normal; background-attachment:scroll;background-position-x:0%;background-position-y: 50%'> From: <a href="mailto:l-bartlett@sbcglobal.net" title="l-bartlett@sbcglobal.net" moz-do-not-send=true>Leslie Bartlett</a> <o:p></o:p> </div> <div style='font-size-adjust: none;font-stretch: normal'> To: <a href="mailto:pianotech@ptg.org" title="pianotech@ptg.org" moz-do-not-send=true>'Pianotech List'</a> <o:p></o:p> </div> <div style='font-size-adjust: none;font-stretch: normal'> Sent: Saturday, April 12, 2008 7:42 AM<o:p></o:p> </div> <div style='font-size-adjust: none;font-stretch: normal'> Subject: RE: Customer Database<o:p></o:p> </div> <div> <o:p> </o:p> </div> 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.<o:p></o:p> les <st1:City w:st="on"><st1:place w:st="on">bartlett</st1:place></st1:City><o:p></o:p> <o:p> </o:p> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center tabindex=-1> </div> From: <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>] On Behalf Of Michelle Smith Sent: Saturday, April 12, 2008 8:01 AM To: 'Pianotech List' Subject: Customer Database<o:p></o:p> 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><u5:p></u5:p> <u5:p> <o:p></o:p></u5:p> In addition to this, we’re working on a feature that would automatically send e-mail reminders to customers.  <o:p></o:p><u5:p></u5:p> <u5:p> <o:p></o:p></u5:p> 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><u5:p></u5:p> <u5:p> <o:p></o:p></u5:p> Has anyone seen a piece of software like this?  I don’t want to reinvent the wheel.  <o:p></o:p><u5:p></u5:p> <u5:p> <o:p></o:p></u5:p> Michelle Smith<u5:p></u5:p><o:p></o:p> Smith Piano Service<u5:p></u5:p><o:p></o:p> <st1:place w:st="on"><st1:City w:st="on">Bastrop</st1:City>, <st1:State w:st="on">Texas<u5:p></u5:p></st1:State></st1:place><o:p></o:p> <u5:p> </u5:p><o:p></o:p> <u5:p> </u5:p><o:p></o:p> <u5:p> <o:p></o:p></u5:p> <o:p> </o:p> 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<o:p></o:p> </blockquote> <o:p> </o:p> </div> </body> </html>