query where end user puts in selection criteria

[Angeline]

Hi,
I need to design a database which allows Recruiters to select and customize
a set of interview questions from a comprehensive list. The end user to run a
query from a form view. The table the query would run from is simple. [Field
1] Competency [Field 2] Question. It is simply a list of 50 competencies
(accoutability, integrity , analysis) each with one to five questions.

I'd like to design a query which can be executed from a form which allows
the end use to select from a list of competencies. The results will display
results from [?[Field1] and [Filed2]. Once I work out how to do this, I'll
set up a macro which runs the query to a report so that they can print off a
list of the questions.

I'm a novice at database design and usually get by with the features of
ACCESS and occassionaly copying code into even procedures. However I do not
know VB and would like some help if possible on designing this form of query
from a form which allows the end user to make a selectin from a list.

Thanks so much!
Angeline
Sydney (AUS)

 

[Duane Hookom]

I suggest you look at "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You would need to implement you competencies and other stuff.

 

[Angeline]

Duane,
Thanks for access to your application and manual. Very interesting although
I can't seem to make any changes in the design view

I'm thinking that this solution might be too overcomplicated for me. I just
need to work out how to create a Query from a form. I tried to look at the
design view of your form but couldn't access them.

Is there an easier way? I'm thinking that if I can list the values on a form
with a radio button. The user clicks which competencies are required and this
populates the values into a table. This would be perfect. Do you know if it
is possible?

I suggest you look at "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You would need to implement you competencies and other stuff.

--
Duane Hookom
MS Access MVP
--

Hi,
I need to design a database which allows Recruiters to select and
customize
a set of interview questions from a comprehensive list. The end user to
run a
query from a form view. The table the query would run from is simple.
[Field
1] Competency [Field 2] Question. It is simply a list of 50 competencies
(accoutability, integrity , analysis) each with one to five questions.

I'd like to design a query which can be executed from a form which allows
the end use to select from a list of competencies. The results will
display
results from [?[Field1] and [Filed2]. Once I work out how to do this, I'll
set up a macro which runs the query to a report so that they can print off
a
list of the questions.

I'm a novice at database design and usually get by with the features of
ACCESS and occassionaly copying code into even procedures. However I do
not
know VB and would like some help if possible on designing this form of
query
from a form which allows the end user to make a selectin from a list.

Thanks so much!
Angeline
Sydney (AUS)

 

[Duane Hookom]

You should be able to modify the designs of objects. You might need to
convert the mdb to a later version of Access.

I don't understand your whole selected competencies stuff but you could add
a field in the table of questions that determines the grouping or use the
levels that are included.

--
Duane Hookom
MS Access MVP
--

Duane,
Thanks for access to your application and manual. Very interesting
although
I can't seem to make any changes in the design view

I'm thinking that this solution might be too overcomplicated for me. I
just
need to work out how to create a Query from a form. I tried to look at the
design view of your form but couldn't access them.

Is there an easier way? I'm thinking that if I can list the values on a
form
with a radio button. The user clicks which competencies are required and
this
populates the values into a table. This would be perfect. Do you know if
it
is possible?

I suggest you look at "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You would need to implement you competencies and other stuff.

--
Duane Hookom
MS Access MVP
--

Hi,
I need to design a database which allows Recruiters to select and
customize
a set of interview questions from a comprehensive list. The end user to
run a
query from a form view. The table the query would run from is simple.
[Field
1] Competency [Field 2] Question. It is simply a list of 50
competencies
(accoutability, integrity , analysis) each with one to five questions.

I'd like to design a query which can be executed from a form which
allows
the end use to select from a list of competencies. The results will
display
results from [?[Field1] and [Filed2]. Once I work out how to do this,
I'll
set up a macro which runs the query to a report so that they can print
off
a
list of the questions.

I'm a novice at database design and usually get by with the features of
ACCESS and occassionaly copying code into even procedures. However I do
not
know VB and would like some help if possible on designing this form of
query
from a form which allows the end user to make a selectin from a list.

Thanks so much!
Angeline
Sydney (AUS)

 

[Angeline]

Duane,
Thanks for taking the time to respond to my questions.

I am using ACCESS 2003

I'll explain a bit better. I have a table with three fields. Field1
[Competancy], Field 2 [Specific Competency] and field3 [Question]. So the
record is only 3 fields wide and 122 rows long.

I'd like for a user to be able to select specific competencies (field2) so
that only the questions for those competencies will be displayed. Its easy
for me to do this in query design view but I'd like to be able to create soI
am used to working in design view and building queries for myself but this is
to be designed for an end user. So the question is, how do I get them to
build their own query from a form. The query would be so simple (as you can
see from the table structure) but the tricky part for me is how can I get
them to easily select more than one specific competency (field 3) and what
kind of control would I need.

It is probably a really simple thing to do but I have brain drain and I
don't write VB so I'm trying to be creative about how I could do this.

I really appreciate your help and advice.

rgs
Angeline

You should be able to modify the designs of objects. You might need to
convert the mdb to a later version of Access.

I don't understand your whole selected competencies stuff but you could add
a field in the table of questions that determines the grouping or use the
levels that are included.

--
Duane Hookom
MS Access MVP
--

Duane,
Thanks for access to your application and manual. Very interesting
although
I can't seem to make any changes in the design view

I'm thinking that this solution might be too overcomplicated for me. I
just
need to work out how to create a Query from a form. I tried to look at the
design view of your form but couldn't access them.

Is there an easier way? I'm thinking that if I can list the values on a
form
with a radio button. The user clicks which competencies are required and
this
populates the values into a table. This would be perfect. Do you know if
it
is possible?

I suggest you look at "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You would need to implement you competencies and other stuff.

--
Duane Hookom
MS Access MVP
--

Hi,
I need to design a database which allows Recruiters to select and
customize
a set of interview questions from a comprehensive list. The end user to
run a
query from a form view. The table the query would run from is simple.
[Field
1] Competency [Field 2] Question. It is simply a list of 50
competencies
(accoutability, integrity , analysis) each with one to five questions.

I'd like to design a query which can be executed from a form which
allows
the end use to select from a list of competencies. The results will
display
results from [?[Field1] and [Filed2]. Once I work out how to do this,
I'll
set up a macro which runs the query to a report so that they can print
off
a
list of the questions.

I'm a novice at database design and usually get by with the features of
ACCESS and occassionaly copying code into even procedures. However I do
not
know VB and would like some help if possible on designing this form of
query
from a form which allows the end user to make a selectin from a list.

Thanks so much!
Angeline
Sydney (AUS)

 

[Duane Hookom]

To select multiple competencies, you could use a multi-select list box.
There are several samples of using list box controls as criterias in
queries. Samples:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
http://www.rogersaccesslibrary.com/TableOfContents3.asp

--
Duane Hookom
MS Access MVP
--

Duane,
Thanks for taking the time to respond to my questions.

I am using ACCESS 2003

I'll explain a bit better. I have a table with three fields. Field1
[Competancy], Field 2 [Specific Competency] and field3 [Question]. So the
record is only 3 fields wide and 122 rows long.

I'd like for a user to be able to select specific competencies (field2) so
that only the questions for those competencies will be displayed. Its easy
for me to do this in query design view but I'd like to be able to create
soI
am used to working in design view and building queries for myself but this
is
to be designed for an end user. So the question is, how do I get them to
build their own query from a form. The query would be so simple (as you
can
see from the table structure) but the tricky part for me is how can I get
them to easily select more than one specific competency (field 3) and what
kind of control would I need.

It is probably a really simple thing to do but I have brain drain and I
don't write VB so I'm trying to be creative about how I could do this.

I really appreciate your help and advice.

rgs
Angeline

You should be able to modify the designs of objects. You might need to
convert the mdb to a later version of Access.

I don't understand your whole selected competencies stuff but you could
add
a field in the table of questions that determines the grouping or use the
levels that are included.

--
Duane Hookom
MS Access MVP
--

Duane,
Thanks for access to your application and manual. Very interesting
although
I can't seem to make any changes in the design view

I'm thinking that this solution might be too overcomplicated for me. I
just
need to work out how to create a Query from a form. I tried to look at
the
design view of your form but couldn't access them.

Is there an easier way? I'm thinking that if I can list the values on a
form
with a radio button. The user clicks which competencies are required
and
this
populates the values into a table. This would be perfect. Do you know
if
it
is possible?




:

I suggest you look at "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You would need to implement you competencies and other stuff.

--
Duane Hookom
MS Access MVP
--

Hi,
I need to design a database which allows Recruiters to select and
customize
a set of interview questions from a comprehensive list. The end user
to
run a
query from a form view. The table the query would run from is
simple.
[Field
1] Competency [Field 2] Question. It is simply a list of 50
competencies
(accoutability, integrity , analysis) each with one to five
questions.

I'd like to design a query which can be executed from a form which
allows
the end use to select from a list of competencies. The results will
display
results from [?[Field1] and [Filed2]. Once I work out how to do
this,
I'll
set up a macro which runs the query to a report so that they can
print
off
a
list of the questions.

I'm a novice at database design and usually get by with the features
of
ACCESS and occassionaly copying code into even procedures. However I
do
not
know VB and would like some help if possible on designing this form
of
query
from a form which allows the end user to make a selectin from a
list.

Thanks so much!
Angeline
Sydney (AUS)