multiple query

[Robert Painter]

Hi
Access 2003
Am almost there with my db but struggling on last hurdle.
I am creating a db for my sons small business of manpower agency and need to
work out how to createa query for finding employee skills.
I have entered any number of skills from a list of 70 into employee details
through a chooser section which works very well and saves into
tblemployeeskill the other tables are tblemployee and tblskills. I have made
a form with 5 comboboxes to make the selections of skills but am now unsure
which way to go. Have been trying to do it thru simple sql but getting error
message. Maybe i am on the wrong track.

Hoping some one will put me on ther right track or help with vba coding

Robert

 

[Dorian]

What is the question?
'getting error message' is not much help. what message? what sql are you
running?

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Robert Painter]

Hi. Perhaps i didnt explain very well.

1) The error message is: The expression On Click you entered as the event
property setting produced the following error: The object doesn't contain
the Automation object 'EmployeeSkills Query.'.
*The expression may not result in the name of a macro, the name of a user
defines function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

The query based is based on tblemployeeskill (which contains employeeidfk
and Employeeskills), with criteria
[Forms]![frmsearch]![cbofirstselection].[AfterUpdate].

I found Customizing Access Parameter Qureies on Access Tips @
www.fontstuff.com/access/acctut08.html and thought it would achieve my aims.

OK here goes with the question

I have a db with employees (tblemployees) who have any no of skills
(tblskills). If a client phones and says do you have a secretary who can
type, use computer and run sales ledger then i want to be able to run a
query to find such a person. I have any no of skills out of possible 70 for
each employee be they in industrial, accounts,commerce, driving or computers
so each employee may have 10 of 70 skills.
I thought (working from above from fontstuff) i would be able to have 5
comboboxes (up to 5 skills to query) and use the afterupdate of each to run
a query in one go but fell at the first hurdle.

Hope this helps clarify the problem i have, and am i on the right track ??

Robert