multiple query

  • Thread starter Thread starter Robert Painter
  • Start date Start date
R

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
 
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".
 
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
 
Back
Top