R
robin1
Guest
Access 2000 form handling with vb help
Hello everybody,
I’m trying to create my own personal knowledge base and I’m not familiar with Microsoft Access and VB so can someone give me a hand with this..
snapshot of the 2 forms were attached to this posting
Form1 has the following:
1 combo box – manually entered tables names found in the db: "table_win95";"Win95";"table_w2k";"win2k";"table_linux";"Linux”
1 text field – to entering key words to search
1 search button -- button that does the search
Form2 has the following:
1 list box –display search results (records found, resulting from the search done from form1)
3 textbox – textbox1: will display title_field, textbox2: will display description_field, textbox3: will display results_field .
to make this posting simple
1 database, call it knowledgedb
3 tables, call it table_win95, table_win2k, table_linux
for example, lets just say the following fields are found in all 3 tables: title_field, description_field, results_field.
I already created the form but I just need some help I guess with vb to make it work.
Basically what I want to do is select a category from the combo box, and enter key search word to search.. hitting the search button should search the selected table and display the results in the list box located in form2.. selecting records in the list box should display or populate the textboxs located below which are textbox1, textbox2, textbox3..
Any help u can give me would be greatly appreciated.
Hello everybody,
I’m trying to create my own personal knowledge base and I’m not familiar with Microsoft Access and VB so can someone give me a hand with this..
snapshot of the 2 forms were attached to this posting
Form1 has the following:
1 combo box – manually entered tables names found in the db: "table_win95";"Win95";"table_w2k";"win2k";"table_linux";"Linux”
1 text field – to entering key words to search
1 search button -- button that does the search
Form2 has the following:
1 list box –display search results (records found, resulting from the search done from form1)
3 textbox – textbox1: will display title_field, textbox2: will display description_field, textbox3: will display results_field .
to make this posting simple
1 database, call it knowledgedb
3 tables, call it table_win95, table_win2k, table_linux
for example, lets just say the following fields are found in all 3 tables: title_field, description_field, results_field.
I already created the form but I just need some help I guess with vb to make it work.
Basically what I want to do is select a category from the combo box, and enter key search word to search.. hitting the search button should search the selected table and display the results in the list box located in form2.. selecting records in the list box should display or populate the textboxs located below which are textbox1, textbox2, textbox3..
Any help u can give me would be greatly appreciated.
Last edited:
