MS Access Switchboard With Dynamic Labels

[ghadley_00]

Hi,

Is there a way to have the labels in a MS access database switchboard
dynamically generated based on values in a table? I have a table of
items (let's call it table Main) , each of which is assigned to a
category. The list of categories is stored in a separate linked table
(let's call it Categories). The Categories table consists of entries
that have an ID number and a name.

I have made queries of the Main table where I make the search criteria
the ID number for the category of interest.

I then made a report for each of these queries.

I would like to make a switchboard that has links to the reports I have
made (one for each category, which is a fixed number), but I would like
the text labels for each of the options to be the description listed
for each entry in the Categories table.

In essence, is it possible to create a switchboard which can
dynamically generate its text labels based on fields in a table?

Any help that could be provided would be greatly appreciated.

Best wishes,

George Hadley
gh********@yahoo.com

[Larry Linson]

Most anything is possible, with some well-thought-out design and some
experience using Access' VBA code. I wouldn't start out trying to modify a
Switchboard created with the Switchboard Manager, however. But you can
certainly create Switchboards that are based on Tables, and other factors.

Larry Linson
Microsoft Access MVP

<gh********@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Hi,

Is there a way to have the labels in a MS access database switchboard
dynamically generated based on values in a table? I have a table of
items (let's call it table Main) , each of which is assigned to a
category. The list of categories is stored in a separate linked table
(let's call it Categories). The Categories table consists of entries
that have an ID number and a name.

I have made queries of the Main table where I make the search criteria
the ID number for the category of interest.

I then made a report for each of these queries.

I would like to make a switchboard that has links to the reports I have
made (one for each category, which is a fixed number), but I would like
the text labels for each of the options to be the description listed
for each entry in the Categories table.

In essence, is it possible to create a switchboard which can
dynamically generate its text labels based on fields in a table?

Any help that could be provided would be greatly appreciated.

Best wishes,

George Hadley
gh********@yahoo.com

[Br]

Does't one of the sample databases in Access contain this functionality??

Larry Linson wrote:

Most anything is possible, with some well-thought-out design and some
experience using Access' VBA code. I wouldn't start out trying to
modify a Switchboard created with the Switchboard Manager, however.
But you can certainly create Switchboards that are based on Tables,
and other factors.
Larry Linson
Microsoft Access MVP

<gh********@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Hi,

Is there a way to have the labels in a MS access database switchboard
dynamically generated based on values in a table? I have a table of
items (let's call it table Main) , each of which is assigned to a
category. The list of categories is stored in a separate linked table
(let's call it Categories). The Categories table consists of entries
that have an ID number and a name.

I have made queries of the Main table where I make the search
criteria the ID number for the category of interest.

I then made a report for each of these queries.

I would like to make a switchboard that has links to the reports I
have made (one for each category, which is a fixed number), but I
would like the text labels for each of the options to be the
description listed for each entry in the Categories table.

In essence, is it possible to create a switchboard which can
dynamically generate its text labels based on fields in a table?

Any help that could be provided would be greatly appreciated.

Best wishes,

George Hadley
gh********@yahoo.com

--
regards,

Br@dley