Re: query where end user puts in selection criteria

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

"Duane Hookom" wrote:

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
--

"Angeline" <Angeline@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04F5DD34-961D-4FC8-95D8-931AD2EAB566@xxxxxxxxxxxxxxxx
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?




"Duane Hookom" wrote:

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
--

"Angeline" <Angeline@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DEB47EB4-4AC1-42AA-AA00-05258C375941@xxxxxxxxxxxxxxxx
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)






.

Relevant Pages

  • Re: query where end user puts in selection criteria
    ... You would need to implement you competencies and other stuff. ... MS Access MVP ... The table the query would run from is simple. ... I'd like to design a query which can be executed from a form which allows ...
    (microsoft.public.access.gettingstarted)
  • Re: query where end user puts in selection criteria
    ... I can't seem to make any changes in the design view ... need to work out how to create a Query from a form. ... You would need to implement you competencies and other stuff. ... I'm a novice at database design and usually get by with the features of ...
    (microsoft.public.access.gettingstarted)
  • Re: query where end user puts in selection criteria
    ... I don't understand your whole selected competencies stuff but you could add ... I can't seem to make any changes in the design view ... need to work out how to create a Query from a form. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: query where end user puts in selection criteria
    ... To select multiple competencies, you could use a multi-select list box. ... am used to working in design view and building queries for myself but this ... build their own query from a form. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: Multiple charts in a report
    ... I changed the design of my query: In the field "week" I filled in as ... Afterwards I made a chart with the reportwizard. ... > Duane Hookom ...
    (microsoft.public.access.reports)