Personal address Book ad hoc query

[Steve]

I just installed Access's template Personal Address Book.

It does not have a last name query so I can look up a
name, and then get all the data I have for that name.

Is there a way I can get the code to create a query that
will do a lookup by last and/or first name, and put it in
my self, as well as add it to the switchboard.

Another options is that I have only 20 or so accounts so
far. I am actually transferring data from my Sharp
Organizer (manually, as I do not have a link). The
template appears to not have all I want (additional
telephone numbers fields, area for directions, etc.) I
there a better Address/Contact template I should
consider. Since Personal address book does have the
above ad hoc query, maybe I need a better one.

thanks.

 

[Al Camp]

Steve,
Do yourself a favor... when it comes to Personal Address Books... grow
your own!
This is a great starter application that you could use to learn Access,
and... when it's done,
it will be just the way you want it.
I have designed a Personal Address Database in JimButton's PCFile (20
years ago), RBase, DBase, Paradox, Alpha4, Access, yada-yada-yada. An
Address Book is just a great "meat and potatoes" learning project...

Here's how it worked with me...
First I built a "flat" database that had all my names and addresses.
Then I realized I had names with multiple telephone numbers (or children
or business contacts, etc...), so I learned how to create a One to Many
telephone number table and subform to hold/display multiple phone numbers
associated with that name.
Then I got tired of browsing to find a name, and learned to use code to
Find a record quickly via a combo box.
Then I added a Christmas Card Listing... then an envelope printing
function... and on and on and on.

Sounds like the Sharp organizer isn't doing what you want... so build
your own app just the way you want...
You'll learn how to create tables, design data entry forms, query your
data, and report on that data.
hth
Al Camp