Before anyone you goes forward developing M$Access to sync to Windows Mobile, I'd recommend checking on what the latest non-plan is by M$ for the "future" of M$Access on WinMob. Last I heard (a couple years ago when I was considering developing something really cool like this) they planned to discontinue such support, or even such capability.<br>
<br>Paul Bruesch<br>Stillwater, MN<br><br><div class="gmail_quote">On Sat, Apr 12, 2008 at 1:14 PM, Dean May <<a href="mailto:deanmay@pianorebuilders.com">deanmay@pianorebuilders.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="white" link="blue" vlink="purple" lang="EN-US">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Are any of you who've developed
these Access programs willing to share? </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<p><b><font color="navy" face="Bradley Hand ITC" size="6"><span style="font-size: 22pt; color: navy; font-weight: bold;">Dean</span></font></b><font color="navy"><span style="color: navy;"></span></font></p>
<p style="margin: 0in 0in 0.0001pt;"><font color="navy" face="Times New Roman" size="3"><span style="font-size: 12pt; color: navy;">Dean May
cell 812.239.3359 </span></font></p>
<p style="margin: 0in 0in 0.0001pt;"><font color="navy" face="Times New Roman" size="3"><span style="font-size: 12pt; color: navy;">PianoRebuilders.com
812.235.5272 </span></font></p>
<p style="margin: 0in 0in 0.0001pt;"><font color="navy" face="Times New Roman" size="3"><span style="font-size: 12pt; color: navy;">Terre
Haute</span></font><font color="navy"><span style="color: navy;">
IN
47802</span></font><font color="navy"><span style="color: navy;"></span></font></p>
</div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt; color: windowtext;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font color="black" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: windowtext; font-weight: bold;">From:</span></font></b><font color="black" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: windowtext;"> <a href="mailto:pianotech-bounces@ptg.org" target="_blank">pianotech-bounces@ptg.org</a> [mailto:<a href="mailto:pianotech-bounces@ptg.org" target="_blank">pianotech-bounces@ptg.org</a>]
<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 color="black" face="Times New Roman" size="3"><span style="font-size: 12pt; color: windowtext;"></span></font></p>
</div><div><div></div><div class="Wj3C7c">
<p><font color="black" face="Calibri" size="2"><span style="font-size: 11pt;"> </span></font></p>
<p><font color="black" face="Calibri" 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/" target="_blank">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: </span></font></p>
<div>
<p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Michelle,</span></font><font face="Times New Roman" size="3"><span style="font-size: 12pt;"></span></font></p>
</div>
<div>
<p><font color="black" face="Arial" 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;"></span></font></p>
</div>
<div>
<p><font color="black" face="Arial" 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;"></span></font></p>
</div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color black; border-width: medium medium medium 1.5pt; margin: 5pt 0in 5pt 3.75pt; padding: 0in 0in 0in 4pt;">
<div style="font-size-adjust: none; font-stretch: normal;">
<p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">----- Original Message ----- </span></font></p>
</div>
<div style="font-size-adjust: none; font-stretch: normal;">
<p style="background: rgb(228, 228, 228) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><b><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">From:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> <a href="mailto:l-bartlett@sbcglobal.net" title="l-bartlett@sbcglobal.net" target="_blank">Leslie Bartlett</a> </span></font></p>
</div>
<div style="font-size-adjust: none; font-stretch: normal;">
<p><b><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">To:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> <a href="mailto:pianotech@ptg.org" title="pianotech@ptg.org" target="_blank">'Pianotech
List'</a> </span></font></p>
</div>
<div style="font-size-adjust: none; font-stretch: normal;">
<p><b><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">Sent:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Saturday,
April 12, 2008 7:42 AM</span></font></p>
</div>
<div style="font-size-adjust: none; font-stretch: normal;">
<p><b><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">Subject:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> RE:
Customer Database</span></font></p>
</div>
<div>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
<p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;">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;"></span></font></p>
<p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;">les bartlett</span></font><font face="Times New Roman" size="3"><span style="font-size: 12pt;"></span></font></p>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<div style="text-align: center;" align="center"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p style="margin-bottom: 12pt;"><b><font color="black" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> <a href="mailto:pianotech-bounces@ptg.org" target="_blank">pianotech-bounces@ptg.org</a>
[<a href="mailto:pianotech-bounces@ptg.org" target="_blank">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;"></span></font></p>
<p><font color="black" face="Calibri" 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. </span></font></p>
<p><font color="black" face="Calibri" size="2"><span style="font-size: 11pt;"> </span></font></p>
<p><font color="black" face="Calibri" 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. </span></font></p>
<p><font color="black" face="Calibri" size="2"><span style="font-size: 11pt;"> </span></font></p>
<p><font color="black" face="Calibri" 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.
</span></font></p>
<p><font color="black" face="Calibri" size="2"><span style="font-size: 11pt;"> </span></font></p>
<p><font color="black" face="Calibri" size="2"><span style="font-size: 11pt;">Has anyone seen a piece of software like this? I
don't want to reinvent the wheel. </span></font></p>
<p><font color="black" face="Calibri" size="2"><span style="font-size: 11pt;"> </span></font></p>
<p><font color="black" face="Comic Sans MS" size="3"><span style="font-size: 12pt;">Michelle Smith</span></font></p>
<p><font color="black" face="Comic Sans MS" size="3"><span style="font-size: 12pt;">Smith Piano Service</span></font></p>
<p><font color="black" face="Comic Sans MS" size="3"><span style="font-size: 12pt;">Bastrop</span></font><font face="Comic Sans MS" size="3"><span style="font-size: 12pt;">,
Texas</span></font></p>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p><font color="black" face="Calibri" size="2"><span style="font-size: 11pt;"> </span></font></p>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p><font color="black" face="Times New Roman" 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></p>
</blockquote>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div></div></div>
</div>
</blockquote></div><br>