Search results

Hello, I'm working on a database for a small library system. The user selects a book from a list, and then enters checkout information including who checked it out, their email, the date, etc. I have a second table called transactionHistory, and every time that a book is checked out, I want to...

I have a form that is supposed to allow a user to select from a list, then click a button to change a value. First, I have a combo box with: Control source: bookList_bookTitle Row source: SELECT bookList.bookTitle FROM bookList WHERE (((bookList.checkedOut)=True)) ORDER BY...

Hello, I've been asking alot of questions on this board recently as I am attempting to set up a library database system, and I don't know much about Access. I have gotten a lot of help, but I'm beginning to doubt if my design will work out. The way I have it set up now is that there is a table...

Hello, I have a short question about updating a value from a form. My form is used to check books out from a library db, and everything works peachy except that I am currently using a checkbox to denote checkout status. That means the user pulls up the book (which is stored in the table...

Hello, I'm trying to set up an access db system to manage a small library at my school. The librarian needs an easy way to check out books, check in books, add/remove books, as well as see which are overdue, which need to be returned, etc. Furthermore, they need records to be kept so they can...