Rolodex Template for Access 2002

[RKraus]

I am looking for a template that I can use as a Rolodex. Does anyone know
where I can find one?


Thanks

 

[Rick B]

The "contact management that ships with Access would work.. Just click NEW
and select the template from there

There is also a Personal address book database template on the Microsoft
website.
Templates > Microsoft Office Programs > Access > Health and Home

 

[RKraus]

The one (it is an access one) that my office has currently has the ability to
search, but it doesn't work and I am hoping to find one that will allow me
the search option. This base will have almost 2000 names in it.

In the meantime, I will try these both out.

Thanks

 

[Rick B]

Why not just modify your's to allow for searches? A template is simply a
starting point. You should customize it to meet your needs. If you already
have one that works, just add the new features to it.

 

[RKraus]

Well, that would be possible......I don't know who did this one, but it needs
major work......I don't know if I am up to that or not, but will give it a
try.

Thanks.

 

[Vincent Johns]

Well, that would be possible......I don't know who did this one, but it needs
major work......I don't know if I am up to that or not, but will give it a
try.

Thanks.

To add searches, one easy choice would be to define a Form and a Macro,
something like these:

Form [F_SetValue] contains only two controls:
- a label showing text like "What name do you wish to find?"
- a text box called [Value]

The "On Exit" event of text box [Value] is set to run Macro [M_Search].

Macro [M_Search] contains the following commands:

OpenTable "T_Rolodex", acNormal, acReadOnly
FindRecord Forms!F_SetValue!Value, acStart, False, , False,
acCurrent, True

Change "T_Rolodex" to the name of the Table in which you want to search
for a name.

To use this, open [F_SetValue], enter the desired name, and press Enter.
Your Table should open with the searched-for text highlighted (if it
was found).


This mechanism might be a bit primitive for your taste, but I think it
should work without much effort on your part, and without depending on
much of your existing database code. If you need something fancier than
what a Macro can do, you can convert this Macro to a Module (= VBA code)
and add whatever else you need there.

Why not just modify your's to allow for searches? A template is simply a
starting point. You should customize it to meet your needs. If you already
have one that works, just add the new features to it.

[...]