Rolodex Template for Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


Thanks
 
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
 
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
 
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.
 
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.
 
RKraus said:
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.
Click to expand...

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.

Rick B said:
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.
Click to expand...
[...]
Click to expand...
 
Back
Top