Adding a command button to a switchboard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shepherdess - 12 Jul 2007 15:38 GMT

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

Reply to this Message

jahoobob - 12 Jul 2007 16:03 GMT

The same way you created the Switchboard-->Tools-->Database Utilities--

>Switchboard Manager unless you have reached the maximum number of buttons on

it.

>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
[quoted text clipped - 5 lines]
>
>Shepherdess

Reply to this Message

bsmith59@gmail.com - 20 Jul 2007 07:39 GMT

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
[quoted text clipped - 4 lines]
>
> 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)

Reply to this Message