Search results

That's correct. Here is the instruction A form for adding borrowing events. Add two command buttons to your form that will allow you to open the other two forms. Use proper validation rules to make sure the return date cannot be earlier than the borrow date (but it can be the same date). Make...

You know the smart ass comments are really not helpful. I understand what each of you are saying about the best way to do, but I have to following the instructions given to me. Now if you want to express your opinion about the instructors comments feel free. I am not the one who wrote it.

I really appreciate all suggestions and they are all valid unfortunately I am restricted to what the instructors instructions. I need to do things laid out in the final project instructions. The instructor specifically for a validation rule to restrict borrowing if the book is not available...

thank you I will try that

thanks

ok thank you. Its not that at all I don't want to screw anything up that I have already done because I am not as experienced with access. Also it is due by midnight tonight.

Sorry I have been busy completing the project. The suggestion to the previous post was valid and if I could start all over I would have done that. Unfortunately I am almost done and since I am new to access I don't want to screw anything up that I have already completed. I just thought there...

Im creating a library management system and I created a form for adding new borrowing events, it includes book, member name, book status, default value for the checkout date that will automatically populate for current date, due date that automatically calculates with dateadd function and return...

Hi, I have a query that shows all the books that have been borrowed. I created a form to show all these events they include Date Out Date Returned whether the book is out or available. I need to be able to add new borrowing events to this form, but I need a way to restrict it based on whether...

That's not what I thought at all. Please do not misinterpret anything. I asked a question and I got an answer, but for what I was specifically trying to do the removal of the "" worked. My previous attempts used True but did not work

Thank you I will keep that in mind

I didn't think anyone was wrong. I trust all the responses that I receive.

Have to say this project is taking its toll on me. I sit at my desk for hours trying to figure out simple things because this is new to me. I want to figure it out but my brain just doesn't work that way. Thanks for the help.

After trying a few things I was able to get it to work when I removed the "" around No.

Ok thanks.

I have a report based on member information and I want to change the text color of the members last name to red if they have not paid their dues. The paid dues field in the table is check box for either yes or no. I have been messing with this for about an hour and I think I am close I am just...

I see that is something to consider. It would be on the day after their 18th birthday.

Sorry I left out some information. I need to be able to calculate the age of a person when the book is returned in order to charge a fee for days past due. The fee structure is for anyone 18 and under on the date of book return is charged is $0.5*DaysPastDue and for anyone over 18 at the time...

Hi, I am working in a database and I need to calculate a persons age on a specific date. I am having a little trouble coming up with the correct expression for this, can someone help please? I have the DOB each person and use the DateDiff function I can calculate age as of Date(). Thanks,