Hi, I've been trying to find ways to make my database small in size and have less queries to be created, but the only way I can make this work will make the database bigger, and more queries, which will cause a mess..
What I want to do is I have a table called "tblTraining” and inside the table are fields called “Classes” “StuNames” and “Date started ”. Under the field “Class” are data “CCNA, “MSCE, “MCP”, “A++, ”Linux”, and “MCSA”, “Excel”, and “Word”.
The field “Class” is a combo box which gets the data from “tblClass” Now what I want to do is I want to have only one form and one query that can do a simple job search, which I think is possible to do, but I just can’t find the method to do this..
I already created a query called “qryTraining” which captures all of the fields and data from the table “tblTraining”. I created a form called “frmViewQuery”, and in this form, I have created a combo box and a command button(cmdView) to do a search based on the data that I have given. “CCNA,“ “MSCE,” “MCP,” etc.
To make my question clearer, I’ll give an example. I go to my form, and there is a combo box called “cboClass” which gets the data from “tblClass” Inside the cboClass are “CCNA, “MSCE, “MCP”, “A++, ”Linux”, and “MCSA”, “Excel”, and “Word”. Now, For example, when I select MCP under the combo box and hit the cmdView, the query pops up showing the students who are taking the MCP class only.
If I choose CCNA in the combo box and hit enter, my query will come up showing the all the students with CCNA classes. Any ideas of how I can get this done??? Thank you!!
I Hate Spammers and Flammers!!!
What I want to do is I have a table called "tblTraining” and inside the table are fields called “Classes” “StuNames” and “Date started ”. Under the field “Class” are data “CCNA, “MSCE, “MCP”, “A++, ”Linux”, and “MCSA”, “Excel”, and “Word”.
The field “Class” is a combo box which gets the data from “tblClass” Now what I want to do is I want to have only one form and one query that can do a simple job search, which I think is possible to do, but I just can’t find the method to do this..
I already created a query called “qryTraining” which captures all of the fields and data from the table “tblTraining”. I created a form called “frmViewQuery”, and in this form, I have created a combo box and a command button(cmdView) to do a search based on the data that I have given. “CCNA,“ “MSCE,” “MCP,” etc.
To make my question clearer, I’ll give an example. I go to my form, and there is a combo box called “cboClass” which gets the data from “tblClass” Inside the cboClass are “CCNA, “MSCE, “MCP”, “A++, ”Linux”, and “MCSA”, “Excel”, and “Word”. Now, For example, when I select MCP under the combo box and hit the cmdView, the query pops up showing the students who are taking the MCP class only.
If I choose CCNA in the combo box and hit enter, my query will come up showing the all the students with CCNA classes. Any ideas of how I can get this done??? Thank you!!
I Hate Spammers and Flammers!!!
