By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,318 Members | 2,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,318 IT Pros & Developers. It's quick & easy.

MS Access Switchboard With Dynamic Labels

P: n/a
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

Feb 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Feb 15 '06 #2

P: n/a
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
Feb 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.