Recent content by K1Kingy

  1. K

    Stop old dates

    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 =...
  2. K

    Stop old dates

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

    Count amount

    Thankyou, It works perfectly
  4. K

    Count amount

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

    Check Box stays ticked

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

    Easiest Way to do a report

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

    Easiest Way to do a report

    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?
  8. K

    Easiest Way to do a report

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

    Opening default form

    Thanks, just what i needed. Cheers bob
  10. K

    Opening default form

    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?
  11. K

    Error if nothing selected in Combobox

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

    Form complications

    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));
  13. K

    Adding total of columns, row by row

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

    Form complications

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

    Form complications

    Good idea, Here ya go
Back
Top Bottom