Customer Database

[paul bruesch]

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.

Paul Bruesch
Stillwater, MN

On Sat, Apr 12, 2008 at 1:14 PM, Dean May <deanmay at pianorebuilders.com>
wrote:

>  Are any of you who've developed these Access programs willing to share?
>
>
>
> *Dean*
>
> Dean May             cell 812.239.3359
>
> PianoRebuilders.com   812.235.5272
>
> Terre Haute IN  47802
>
>
>  ------------------------------
>
> *From:* pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org] *On
> Behalf Of *Mark Dierauf
> *Sent:* Saturday, April 12, 2008 1:22 PM
> *To:* Pianotech List
> *Subject:* Re: Customer Database
>
>
>
> I parted my MS Access tables over to SprintDb Pro for the Pocket PC (
> http://www.kaione.com/ ). 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:
>
> Michelle,
>
> 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.
>
> Fenton
>
>  ----- Original Message -----
>
> *From:* Leslie Bartlett <l-bartlett at sbcglobal.net>
>
> *To:* 'Pianotech List' <pianotech at ptg.org>
>
> *Sent:* Saturday, April 12, 2008 7:42 AM
>
> *Subject:* RE: Customer Database
>
>
>
> 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.
>
> les bartlett
>
>
>  ------------------------------
>
> *From:* pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org<pianotech-bounces at ptg.org>]
> *On Behalf Of *Michelle Smith
> *Sent:* Saturday, April 12, 2008 8:01 AM
> *To:* 'Pianotech List'
> *Subject:* Customer Database
>
> 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.
>
>
>
> In addition to this, we're working on a feature that would automatically
> send e-mail reminders to customers.
>
>
>
> 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.
>
>
>
> Has anyone seen a piece of software like this?  I don't want to reinvent
> the wheel.
>
>
>
> Michelle Smith
>
> Smith Piano Service
>
> Bastrop, Texas
>
>
>
>
>
>
>
>
>
> 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://www.moypiano.com/ptg/pianotech.php/attachments/20080412/36d01798/attachment-0001.html