Before I attempt to implement the excellent suggestions by Sco and you about
filtering the phone list, I need to know how to code the list so when it is
opened without any filter it is in alphabetical order.
In the meantime, I will work on the Filter by Contact as suggested.
Thanks a lot for your help. It is so satisfying when something works!
Joan
:
Hi Joan,
Glad to hear you have the form working OK now.
Sco has provided an excellent working example which
should help with your follow-up question.
I *think* I see where you are going with your second
question. I used the Alpha Button setup in a couple of
different places based on the need. For the Vendor list
form I have a command button on each line of the continuous
form that will open up a "Vendor Detail" form. This
detail form displays all the information for that specific
vendor. The Phone List form serves as a great search form
for all the vendors and the user can quickly drill down to the one
they want and then click to view additional details. For
your setup, you could create a new form-subform based
on the attorneys. The subform would list all of that attorney's
clients. The phone list Alpha form would display all of the
attorneys so the user could quickly drill to the one they want.
The user then clicks on a command button in the detail section
that will open the new form-subform to display that attorney's
clients and workload. Follow me? Perhaps this is how you
could set up your forms.
In another situation I used the Alpha button forms for a list
of food products. The food product list could be huge so I
added additional sorting/filtering capabilities. The Header
section has a Primary sort Option Group for Active/Inactive/All
products and a Secondary sort Option Group for Report
Group or Inventory Location. The Secondary sort is optional
so the user selects their criteria and gets a smaller list. At ANY
time the user can click the Alpha buttons for further filtering.
So a user could, with just a couple of mouse clicks, drill down
to all the active products in the Freezer and then beginning with
the letter "B". This was accomplished by using code to change
the RecordSource of the form by the Option Group selections.
Since the Alpha buttons simply filter the existing RecordSource,
they can be used at any time along with whatever other options
the user selected. It works very well, however, this level of
complexity may not be what you are after. This setup requires
LOTS of coding, sleepless nights, and monitor head-whacking!
Post back if you are still having difficulty.
--
Jeff Conrad
Access Junkie
Bend, Oregon
Hi. It worked! I deleted the marco and form copied from Northwind and began
from scratch. I was very, very careful per your instructions.
Other: At work I have a command button for each attorney so they may click
on it and all their cases will appear.
Any suggestions of how I could filter the Phone List so they would only have
the phone nos. of their clients? Maybe too many layers.
Thanks for you help. Appreciated.
:
The other option would be to use the wizard and recreate the buttons from
scratch. Then you have the problem of creating the macro (or code) from
scratch as there is no wizard to do that..
As the sample in Northwind does work, the problem lies with your renaming.
Sco
M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President
www.DAAUG.org
MS Colorado Events Administrator
www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at
www.ScoBiz.com
Thanks for input. I did change the field name:[LastName Father] to
[LastnameFather]. That changed the error message to:
'The object doesn't contain the Automaton object 'LastNameFatheFilters'
I will look again to see if I forgot one.
Frustrated. Is there any other place I could get the alpha buttons for a
phone list?Joan
:
1 - Are you sure you changed *all* of the references? There are a bunch.
2 - Are you sure you entered them all the same everywhere? In your post
you
say you changed the reference to the option group frame to [Lastname
Fatherfilters] with a space, but your error message you show is
"LastNameFatherFiters" without a space. Was this error in just your
posting
here or is it actually in your form and/or macro?
You never said you actually changed the name of the option group frame
on
the form. Did you do that and not mention it or did you not do it? In
case
you didn't realize it, "CompanyNameFilters" in the macro condition
column is
a reference to the option group frame on the form. If you change it in
the
macro, it must be changed on the form.
Also, keep in mind that Northwind is not a good "best-practices"
database.
They use spaces in names extensively throughout the database. Good
naming
conventions consider spaces in any names, fields and objects, very evil.
Recheck all of the names for both spelling errors and spaces.
Good luck.
Sco
M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President
www.DAAUG.org
MS Colorado Events Administrator
www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at
www.ScoBiz.com
I copied Nortwind Phone Macro and Phone List.
I replaced the company field with my [Lastname Father] field.
I changed the name of the form and also in macro.
I changed the filters in the macro to [lastname fatherfilters]
Set value:changed to [Lastname Fatherfilters]
ERROR MSG: The object doesn't contain the Automation object
"LastNameFatherFiters."
If I click on the aplha button quickly before the message appears,the
filter
works.
Any help appreciated. Need to do this for work.
Thanks.
