<!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=us-ascii"> <META content=Word.Document name=ProgId> <META content="MSHTML 6.00.2800.1226" name=GENERATOR> <META content="Microsoft Word 10" name=Originator><LINK href="cid:filelist.xml@01C45159.98043BD0" = rel=File-List><o:SmartTagType name="time" namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT= ype><o:SmartTagType name="date" namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT= ype> <STYLE>@font-face { font-family: Tahoma; } @font-face { font-family: Comic Sans MS; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; = mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } A:visited { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlinkFollowed { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } P.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } LI.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } DIV.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: = "Times New Roman"; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; = mso-margin-bottom-alt: auto } SPAN.EmailStyle19 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal; = mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: = 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial } SPAN.EmailStyle20 { COLOR: #993366; FONT-FAMILY: Arial; mso-style-type: personal; = mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; = mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial } SPAN.EmailStyle21 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal; = mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: = 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial } SPAN.EmailStyle22 { COLOR: #003300; FONT-FAMILY: Arial; mso-style-type: personal; = mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; = mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial } SPAN.EmailStyle23 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply; = mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: = 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=EN-US style="tab-interval: .5in" vLink=blue = link=blue> <DIV>Mark,</DIV> <DIV> </DIV> <DIV> This is incredibly generous of you, I know how many hours = it takes to put a DB like this together!</DIV> <DIV> </DIV> <DIV>Thank you,</DIV> <DIV> </DIV> <DIV>Mike McCoy</DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: = pianotech-bounces@ptg.org [mailto:pianotech-bounces@ptg.org]On Behalf Of Mark Dierauf Sent: Sunday, June 13, 2004 3:18 PM To: pianotech@ptg.org Subject: RE: Pocket PC w/TL & Customer = DB </DIV> <DIV class=Section1> I’ve = posted a copy with one sample customer at <A = href="http://www.nhpianos.com/ptdb_download_page.htm">www.nhpianos.com/= ptdb_download_page.htm</A> I’ve included some tips in the comments textbox that list some = of the less obvious features. You’d need to replace the data in the = tblCities table with info for your own area. I was able to turn up a text listing for this = online to save keying all of this data in. Let me know if you have any = specific questions. Feel free to use or modify this as you wish, but if you = make any meaningful changes I’d love to hear about = them.<o:p></o:p> <o:p> </o:p> - Mark<o:p></o:p> <o:p> </o:p> -----Original Message----- From: = Dean May [mailto:deanmay@pianorebuilders.com] Sent: <st1:date = Year="2004" Day="12" Month="6">Saturday, June 12, 2004</st1:date> = <st1:time Minute="48" Hour="21">9:48 PM</st1:time> To: Pianotech Subject: RE: Pocket PC w/TL = & Customer DB <o:p> </o:p> So are you = willing to put it out there as shareware for your piano tech brothers?  ;-)<o:p></o:p> <o:p> </o:p> Dean<o:p></o:p> <o:p> </o:p> Dean May           &n= bsp; cell 812.239.3359<o:p></o:p> PianoRebuilders.com   812.235.5272<o:p></o:p> Terre Haute IN  47802<o:p></o:p> <o:p> </o:p> -----Original Message----- From: pianotech-bounces@ptg.org [mailto:pianotech-bounces@ptg.org]On Behalf Of Mark = Dierauf Sent: <st1:date = Year="2004" Day="12" Month="6">Saturday, = June 12, 2004</st1:date> <st1:time Minute="57" Hour="19">7:57 PM</st1:time> To: = pianotech@ptg.org Subject: RE: Pocket PC w/TL = & Customer DB<o:p></o:p> <o:p> </o:p> Yep – rolled my own over the course of several years. Started small with = Access ver 1.0 and added on as I gained experience. There are many sample = DB’s available via Microsoft and on the web to use as a starting point.<o:p></o:p>  <o:p></o:p> - Mark<o:p></o:p>  <o:p></o:p> -----Original Message----- From: = Dean May [mailto:deanmay@pianorebuilders.com] Sent: <st1:date = Year="2004" Day="12" Month="6">Saturday, = June 12, 2004</st1:date> <st1:time Minute="43" Hour="16">4:43 PM</st1:time> To: Pianotech Subject: RE: Pocket PC w/TL = & Customer DB<o:p></o:p>  <o:p></o:p> >>SprintDB reads and writes Microsoft Access database files, and since my desktop = DB is in Access it was a logical choice. <o:p></o:p>  <o:p></o:p> So is your = desktop DB something you developed or a package you got somewhere? <o:p></o:p>  <o:p></o:p> Dean<o:p></o:p>  <o:p></o:p> Dean May           &n= bsp; cell 812.239.3359<o:p></o:p> PianoRebuilders.com   812.235.5272<o:p></o:p> Terre Haute IN  47802<o:p></o:p>  <o:p></o:p></DIV></BLOCKQUOTE></BODY>= </HTML>