Creating Searchable Database

[Shari]

I am new to creating an Access database, but have worked in Access when there
has already been a database completed.

I am trying to create a database in which I can create a new record for each
of my customers. I would like to be able to search by each of the fields in
my record. I also want to be able to input dates underneath each of the
records(for each date we service them). I worked for a company who had a
database like this set up, but never looked into it to see exactly how it was
set up.

Any advice would be appriciated!

 

[Daniel Pineault]

Shari,

You have a couple of very distinct issues.

As for creating a searcheable form to retrieve your client records, take a
look at http://allenbrowne.com/ser-62.html it illustrates the principle. You
can then customize it further to suit your exacting needs.

As for inputing dates (underneath?) your records.... This is a question of
table setup. You need to have a field in your table to add in the date.
Then add the field onto your data entry form. Also, for enetering date you
should use a calendar/date picker to facilitate data entry. For this look at

http://allenbrowne.com/ser-51.html
or
http://www.lebans.com/monthcalendar.htm

both are very good.

 

[Albert D. Kallal]

Have you tried the built in filter by form feature?

When you use the filter by form, you simply look at your current form and
type in the values for each field to match. Whack the filter utton and
access off goes and gets the records.

in addition to using your current familiar form, some of the fields actually
get automatic converted into drop down boxes for you.

before you go off and do a bunch of work to build a custom search screen,
you might wanna give the above feature try

go records->filter->filter by form.....

 

[Shari]

Thank you Albert. That could work, although it is not what I am looking for.

What I was able to do at the previous company were click on buttons, already
placed on each form, that would allow me to search by the individual fields.
I cannot for the life of me figure out how to add those buttons.

I also used to do a mailing with a merge to Word. There was a box on each
form I could check, and it would add it to a list to merge into Word. Any
idea how to get that?

 

[Daniel Pineault]

Shari,

Albert is the right person to ask questions about MailMerge. Take a look at
his sample solution at

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

about half way down the page entitled 'Super Easy Word Merge'. You will
have to do some programming to get it to behave in the exact manner that you
describe but this is the way to go.
--
Hope this helps,

Daniel Pineault