D
darianta
Hi all, I need some help. I know Access pretty well, but I'm relatively new
to VBA.
I have a database with a search form using 2 list boxes, each referring to a
different query, and one command button to display the results.
I have a results form displaying information from the first query, with a
subform displaying data from the second query.
Problem #1
I set the command button on the search form to open the results form but
that doesn't display any results. I think I need to have it run the queries
before the results will show up on the form, but I'm not entirely sure how to
do this.
Problem #2
The search form has two search fields, one Position, and the other Skill.
The users of the database want to be able to search for a position or a skill
or both. Each employee in the database has several skills. I'm not really
sure how to set this part up. Because each of these fields is from a
different query (otherwise I end up with each employee showing up a dozen
times, once for each skill), I'm not sure how to set the criteria. Also, if
a user selects one skill form the list, I need it to show everyone with that
skill, and not with ONLY that skill.
If you can help me with this that would be very much appreciated. If you
think there's a different, "better" way to do what I'm trying to do, by all
means let me know that too because I'm really not sure what to do or if I'm
even on the right track with this. I'm open to any and all suggestions.
Thanks!!
to VBA.
I have a database with a search form using 2 list boxes, each referring to a
different query, and one command button to display the results.
I have a results form displaying information from the first query, with a
subform displaying data from the second query.
Problem #1
I set the command button on the search form to open the results form but
that doesn't display any results. I think I need to have it run the queries
before the results will show up on the form, but I'm not entirely sure how to
do this.
Problem #2
The search form has two search fields, one Position, and the other Skill.
The users of the database want to be able to search for a position or a skill
or both. Each employee in the database has several skills. I'm not really
sure how to set this part up. Because each of these fields is from a
different query (otherwise I end up with each employee showing up a dozen
times, once for each skill), I'm not sure how to set the criteria. Also, if
a user selects one skill form the list, I need it to show everyone with that
skill, and not with ONLY that skill.
If you can help me with this that would be very much appreciated. If you
think there's a different, "better" way to do what I'm trying to do, by all
means let me know that too because I'm really not sure what to do or if I'm
even on the right track with this. I'm open to any and all suggestions.
Thanks!!