Not sure if the attachment zip included the file so here it is again . . .

Steve

Cheers, although No help so far :-(

I just need to create a loan and return form, the loan form needs to save the loans in it...

are there any examples floating around here? I can't seem to find any..

cheers

Did you look at the download?

Steve

I didn't realise that was revised.. cheers for your help !
However I'm a bit more confused...
I'm not sure how to implement what you did in the actual way that i want .. (I think that makes sense)

cheers

Both Steve and I have given you a lot of information and help. Steve even went further then I think he should have to give you a nice rental setup.

You need to spend some time digesting the information you have been given and making use of it. You seem to expect us to do the work for you and thatt's expecting too much.

wij_man

I agree with Scott . . . it takes some time to get used to programming access . . . and I suggest getting one of the books recommended at this site.

I put some code in your db just so you can see what it looks like and how it works . . . nothing really too fancy . . . but keeping it simple coding wise ususally produces a simply user interface.

Likewise, I've used some VBA code using DAO recordsets . . . that's a whole discussion in and of itself but the sample code should give you a good start . . .

In any event, moving beyond the wizards is a big step! Interestingly, I never used them . . . having programmed before, I just went straight into basic coding and never looked back . . . but I've still got a lot to learn and I too visit this site for various insights and coding tips.

Steve

i am currently making a video loaning system and am having problems with caluclating the overdue cost for a video.
can someone please help!!!

where can i download the Northwinds sample database please?

Hey potty, where you from ? (I don't want you copying my courseowrk.. lol)

anyways here's an example of a overdue for a video..
BTW to cover my own back I'm saying right now that if you intend to pass this off as your own work in anyway do not use it.

to work out your days overdue here is the code to put in your "Control source" of your "Days overdue field"

=DateDiff("d",[Date Due Back],Now())+Int(Format([Date Returned],"ddmmyyyy")<Format([Date Due Back],"ddmmyyyy"))+1

For the cost I've used this..

=[Days Overdue]*[Hire Cost]

hope that's helped ya..

pottywithit - where can i download the Northwinds sample database please?

It comes free with Access and should be in your Samples folder in Office in the Programs folder.

Steve

hey i was wonderin how i would make a RENEW button for renewing a video. i kno wi need to create a button but what would the code be.

thanks

First, it would be a good idea to start your own thread trather then piggy back on an existing one.

Second, adding a renew feature is dependent on a number of factors. Do you want the renewal to be a separate loan transaction? Or do you just want to extend the due date? How do fees figure in? There is no way we can give you a code sample without knowing how your system works.

I suggest you start a new thread (Renew video rental) with more info so we can help.





Edited by: ScottGem on Fri Apr 15 12:36:14 EDT 2005.

hi sorry, i actually dont know how to start a new thread.
With the renews I'm not sure whether I want to extend the due date or make it a separte loan transaction. at the moment the due date is calculated by validation in the table by ()+3 (which means that the due date is three days after the video has been rented. which way would be most suitable for me?

You select a forum appropriate to your topic and then click on the Add New Post link. It would help if you read the instructions.

That's a question YOU need to answer. Either way is viable, but its a business rule, not an access one.

HTH

ok ive chosen to make it a separte loan transaction. how would i go about making the renew button to renew a video for 3 more days?

Generate and run an Append query that takes the data from the current loan record and changes the Loan date. You might also want to add a flag to indicate its a renewal.

HTH

what fields would i have to use for that append query?

How do you expect us to know? Its your database. Its also YOUR assignment. We can provide direction ans suggestions, but we are NOT going to do the work for you.