How do I add a command button to my main switchboard and associate it with
opening a report filtering a set of records between given dates? I have a
switchboard designed and working. It is to make the application more polished
and user friendly for those who don't know how to write queries and don't
want to know; they just want to filter records with a touch of the button.

Thanks in advance for any help on this matter.

Shepherdess

The same way you created the Switchboard-->Tools-->Database Utilities--
>Switchboard Manager unless you have reached the maximum number of buttons on
it.

shepherdess wrote:
>How do I add a command button to my main switchboard and associate it with
>opening a report filtering a set of records between given dates? I have a
>switchboard designed and working. It is to make the application more polished
>and user friendly for those who don't know how to write queries and don't
>want to know; they just want to filter records with a touch of the button.
>
>Thanks in advance for any help on this matter.
>
>Shepherdess

--
Message posted via http://www.accessmonster.com

On Jul 12, 8:38 am, shepherdess
<shepherd...@discussions.microsoft.com> wrote:
> How do I add a command button to my mainswitchboardand associate it with
> opening a report filtering a set of records between given dates? I have aswitchboarddesigned and working. It is to make the application more polished
> and user friendly for those who don't know how to write queries and don't
> want to know; they just want to filter records with a touch of the button.
>
> Thanks in advance for any help on this matter.
>
> Shepherdess

Shepherdess,

Are the filter dates static, or set by the user? That will drive part
of your design. I am assuming you want the user to be able to set the
date range, in which case you'll need to allow the user to populate
the dates on the form, then call OpenReport with the "WHERE" argument
that contains your criteria.

Are you using the MS Access Switchboard, or one of your own creation?
The MS Access Switchboard uses the same form for every menu, so if you
add text boxes, they would show up on all menus. That is, unless you
do some fancy coding to work around that.

Glad you're thinking about the user first!

Brandon Smith-Daigle
http://accesspro.blogspot.com (access tips for non-programmers)