Search results

I have a database for a library and when issuing books the issueDate and bookReturnDate gets inserted automatically so that works good. Dates can be edited though, what i was wanting to do is stop old dates been inserted if they are edited.

I am running a query to see how many students have books overdue. The query runs fine and i can produce good reports out of it. What i am wanting to do is count the amount of overdue books students have. So in the query i am selecting StudentID book and days overdue. StudentID | Book |...

I have a subform running in one of my forms which shows the following: StudentID | BookTitle | DueDate | DateReturned | Return* | The first 4 are straight out of my tbl_issue table. I added a check box on the end of that called Return. When i tick that it will set a return date, and update...

I have a library database, with several tables. I am wanting to produce reports for the students who have overdue books. I am completely new to reports, so any help on the easiest way to go about doing this would be a great help. Thanks EDIT: I'll post what i current have so as to help a...

What i want to do is when I open up my database I want the frm_switchboard to be opened by default, so that anyone who opens the database will automatically get the switchboard so they can work from there. Any ideas?

I have a table that is called books. In this table it contains all the 'books' avaliable in the 'library'. A field in this table is called onShelf. When it is checked, it means the book is on the shelf, when it is unticked it is currently 'issued'. On the book issue form i currently run the...

Ok i'm not sure if this is complex or not (I hope not). In MS access 2007, I am creating a library database system, with members forms, book forms and issue forms. When adding a book into the book table There is a check box called 'onShelf' which speaks for itself, if it is checked it is on...