Selecting Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Mallis - 20 May 2005 06:36 GMT

I have a query that returns a variety of student psychometric data (IQ,
reading level, etc). There are about 12 different fields that contain this
data.

I want to design an interface (switchboard, I suppose) so that staff can
access details of their students. BUT I'd like to give them a choice (on the
fly) of what fields are shown. I'd like to give them checkboxes of fields
they would like to output (to iether screen or print).

While it's easy enough to go into the query and select the fields to show,
then run the query, this would be far from the ideal.

I'm sure it's standard stuff...but I'm stumped.

Any clues??

Thanks in advance
Tony

Reply to this Message

MA - 20 May 2005 11:49 GMT

> I have a query that returns a variety of student psychometric data
> (IQ, reading level, etc). There are about 12 different fields that
[quoted text clipped - 15 lines]
> Thanks in advance
> Tony

I'd organize it in a different way, with a submask listing all the
characteristics

It will be easier to find what you'll need

Signature

_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it

Reply to this Message

Duane Hookom - 20 May 2005 14:23 GMT

I don't know what you mean by "submask listing all the characteristics" and
I doubt Tony does either.

There is a small ad hoc/"query by form" applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane that
provides this type of functionality.

Signature

Duane Hookom
MS Access MVP

>> I have a query that returns a variety of student psychometric data
>> (IQ, reading level, etc). There are about 12 different fields that
[quoted text clipped - 20 lines]
>
> It will be easier to find what you'll need

Reply to this Message