T
tjbar123
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