X xZielx Honorable Nov 7, 2016 10 0 10,510 Jan 6, 2017 #1 I created a database to keep track of book collection. How can I create/input a search box in this database?
I created a database to keep track of book collection. How can I create/input a search box in this database?
B boosted1g Titan Jun 12, 2013 14,846 8 74,965 Jan 6, 2017 #2 Can you specify more then just "Micorosft Database"? Are you talking about MS Acess, talking about MS SQL database or what?
Can you specify more then just "Micorosft Database"? Are you talking about MS Acess, talking about MS SQL database or what?
X xZielx Honorable Nov 7, 2016 10 0 10,510 Jan 6, 2017 #3 boosted1g : Can you specify more then just "Micorosft Database"? Are you talking about MS Acess, talking about MS SQL database or what? Sorry, MS Access.
boosted1g : Can you specify more then just "Micorosft Database"? Are you talking about MS Acess, talking about MS SQL database or what? Sorry, MS Access.
B boosted1g Titan Jun 12, 2013 14,846 8 74,965 Jan 6, 2017 #4 So you currently just have a table with your data in it. So you need a form to put a text box in to actually search your database, you need a query (this is what searches your table for the data you inputed in the form), and then you either need to open the data in another form or in a report. Here is some different tutorials: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwj4z9ORpq7RAhVJNJQKHXBACZIQtwIIHTAA&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZSvn5DdhCDg&usg=AFQjCNGRg-JvAj7hsGrTditc5YtV1s2eDA http://www.knowledgewave.com/blog/msoffice/access/create-an-interactive-access-form-to-filter-a-query-by-date-range-2.html This is not really a novice task as you need to have some level of understanding of databases and passing variables.
So you currently just have a table with your data in it. So you need a form to put a text box in to actually search your database, you need a query (this is what searches your table for the data you inputed in the form), and then you either need to open the data in another form or in a report. Here is some different tutorials: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwj4z9ORpq7RAhVJNJQKHXBACZIQtwIIHTAA&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZSvn5DdhCDg&usg=AFQjCNGRg-JvAj7hsGrTditc5YtV1s2eDA http://www.knowledgewave.com/blog/msoffice/access/create-an-interactive-access-form-to-filter-a-query-by-date-range-2.html This is not really a novice task as you need to have some level of understanding of databases and passing variables.
X xZielx Honorable Nov 7, 2016 10 0 10,510 Jan 6, 2017 #5 boosted1g : So you currently just have a table with your data in it. So you need a form to put a text box in to actually search your database, you need a query (this is what searches your table for the data you inputed in the form), and then you either need to open the data in another form or in a report. Here is some different tutorials: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwj4z9ORpq7RAhVJNJQKHXBACZIQtwIIHTAA&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZSvn5DdhCDg&usg=AFQjCNGRg-JvAj7hsGrTditc5YtV1s2eDA http://www.knowledgewave.com/blog/msoffice/access/create-an-interactive-access-form-to-filter-a-query-by-date-range-2.html This is not really a novice task as you need to have some level of understanding of databases and passing variables. I haven't had any experience with MS Access in the past. It was just always THERE, not being used. Hmm.. Yes, I assumed it would. Thank you.
boosted1g : So you currently just have a table with your data in it. So you need a form to put a text box in to actually search your database, you need a query (this is what searches your table for the data you inputed in the form), and then you either need to open the data in another form or in a report. Here is some different tutorials: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwj4z9ORpq7RAhVJNJQKHXBACZIQtwIIHTAA&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZSvn5DdhCDg&usg=AFQjCNGRg-JvAj7hsGrTditc5YtV1s2eDA http://www.knowledgewave.com/blog/msoffice/access/create-an-interactive-access-form-to-filter-a-query-by-date-range-2.html This is not really a novice task as you need to have some level of understanding of databases and passing variables. I haven't had any experience with MS Access in the past. It was just always THERE, not being used. Hmm.. Yes, I assumed it would. Thank you.