Command Button Filter & Error Message ("MS Jet database. . .")

[Flopbot]

I have a volunteer database in Access 2003 that has 3 Command Buttons on my
main form: Active, Occasional, & Archived. When I press each button, I want
it to only show the volunteers with that status selected. To do this, each
button relates to a Macro (example below).

~Macro Name: Show Active
~Action: Apply Filter
~Filter Name: Show Active
~Where Condition: [Status]=â€Activeâ€

When I click the button, I get the following message. When I click OK, it
goes away and filters everything just like I want.

~“The Microsoft Jet database engine could not find the object ‘Show Active’.
Make sure the object exists and that you spell its name and the path name
correctly.

Unfortunately, I don’t really know how macros work and the other threads on
this error message are all way over my head. I got lucky and found a set of
instructions online that got me this far, but now I’m stuck. Any ideas?

 

[Scott McDaniel]

I have a volunteer database in Access 2003 that has 3 Command Buttons on my
main form: Active, Occasional, & Archived. When I press each button, I
want
it to only show the volunteers with that status selected. To do this,
each
button relates to a Macro (example below).

A simpler way might be to use the form's Filter property. For each your
buttons add code like this:

Me.filter = "[Status]='Active'"
Me.FilterOn = True

This would be for your Active button ...

~Macro Name: Show Active
~Action: Apply Filter
~Filter Name: Show Active
~Where Condition: [Status]=â€Activeâ€

When I click the button, I get the following message. When I click OK, it
goes away and filters everything just like I want.

~“The Microsoft Jet database engine could not find the object ‘Show Active’.
Make sure the object exists and that you spell its name and the path name
correctly.

Unfortunately, I don’t really know how macros work and the other threads
on
this error message are all way over my head. I got lucky and found a set
of
instructions online that got me this far, but now I’m stuck. Any ideas?