Search results

The system you described would work too, but I'm trying to keep the system very simple becuase the librarian users do not want to learn a difficult new system. Because the system is for a very small library within the career center at my school, most users will only check out one or two books...

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...

I'm pretty much an Access newbie, but I would start by manually adding a combo box to the form. The combo box wizard will pop up, allowing you to select "Find a record on my form based on the value I selected in my Combo box". This will let you specific a field to use as a filter. I've also done...

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...

thank you, that worked perfectly. i know that a date would be more useful, but the way i've set up the database is to store the date information in a different table. technically i don't think i need the flag in the booklist table, but it provides a second location to store the information for...

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, Thanks for the help, it turns out I was able to do what I wanted by setting the up the relationship (I had i search on that alot, i wasn't sure what it did) and then futzing around with the form wizard. I didn't use any NotInList events, since basically all the things had to be typed in...

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...