Dear All,
I am currently creating a MS Access database relating to books with around 15 diffrent fields all in one table and they all have to be in one table. I have created a test version with all fields filled in relating to 7 books. It will be used by a number of people that i work with. They will view all the brochure information within a form. What I want to know is first of all can i create a tick box system whereby there will be 4 options of new, re-print, ammended reprint, and out of print; when i clcik the new button the form will filter all books that are new?
Second of all, I also want to know, can i create a form whereby at the top there is a search bar, and below is my table, and then below that is the fields that i typed with the data in it. I want to be able to type in the search bar, and as i type it narrows the table down. For example, if i typed in the search bar "Alice", in the table below all books with Alice in the title would appear and then i could click within the list box to display that book's information in the form below?
Please help as I am in desperate need.
Many Thanks
Tom
I am currently creating a MS Access database relating to books with around 15 diffrent fields all in one table and they all have to be in one table. I have created a test version with all fields filled in relating to 7 books. It will be used by a number of people that i work with. They will view all the brochure information within a form. What I want to know is first of all can i create a tick box system whereby there will be 4 options of new, re-print, ammended reprint, and out of print; when i clcik the new button the form will filter all books that are new?
Second of all, I also want to know, can i create a form whereby at the top there is a search bar, and below is my table, and then below that is the fields that i typed with the data in it. I want to be able to type in the search bar, and as i type it narrows the table down. For example, if i typed in the search bar "Alice", in the table below all books with Alice in the title would appear and then i could click within the list box to display that book's information in the form below?
Please help as I am in desperate need.
Many Thanks
Tom
