Search results

I don't want to lock some of them because i want to be able to change the due date for some books, but obviously i wouldn't want a date set that has already been :) I came up with some code that is executed AfterUpdate.. If issueDate < Now() Then MsgBox("Incorrect Date Entered") issueDate =...

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.

Thankyou, It works perfectly

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

Thanks statsman this is coming together nicely. I have one more problem though. When running the report if a student has more than 1 book overdue, it is creating a report for the student twice. How do i stop it from creating the report twice and just writing you have 2 books overdue.

Ok that makes a bit of sense. By doing this, will it limit the report to only students with overdue books? By running the query i made (Selecting overdue books) will that make the report just show what i want it to show?

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

Thanks, just what i needed. Cheers bob

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 believe you get this error because you have a relationship between the two fields, so basically what you've told it to do is when you add a job then there will NEED to be a part selected. So i think if you fix the relationship up, you should be good. I think this is right, I'm still kind of...

For the avaliable books? No, For the Book Title Combo box, i have just add to the query under 'Row Source' in data properties. This is what the row source shows for it: SELECT tbl_book.bookID, tbl_book.bookTitle FROM tbl_book WHERE (((tbl_book.onShelf)=True));

My guess is, is that you will have to do some sort of query that will add them together. TotalHours:Mon+Tue+Wed+Thu+Fri and then you will be able to display the TotalHours field

Here, I saved it as a 2003 version, hopefully it'll still work the same EDIT: Well the same error occurs, so thats good.. I guess lol

Good idea, Here ya go

Yeah i'm really confusing myself as well lol. I'll give an example of how it works hopefully it will make some sense. I open the form_bookIssues: I select the studentID from the Student search combo box. In the subform_bookissues, it will then list the current book issues that student has. In...

Yes I still need to see the book that has been Issued out rather than seeing a hole lot of Issues that appear blank. Yes it does work correctly, in the fact that when i select a book to be issued, it unchecks the onShelf box making the book 'Unavaliable'. Yet in the Issues form because the...

Ok that does help. I just put _BOOKIDHERE_ just to make the query look proper. But i didn't know about any of the & symbols. So thanks, I managed to fix the error as well.

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