Recent content by PS65

Hey, Thanks man, it works. :D

Hi, there seems to be a problem...it says "Run Time Error 7951". When I debug, it says there is a problem with the following: If Me.RecordsetClone.RecordCount = 0 Then Any ideas?

Hi, Basically, I have a query which brings up a customers details when they enter the Name and DOB. However, lets say they get it wrong, or don’t even type anything in…….the form just opens with a blank section. Is there any way to make it give an alert say “No Record Found”. Thanks

Hey Jeremie, thanks......Books on order. But waiting for delivery times! Database seems to be coming on a bit better now. However, the 'copy' table isnt working. I made a table called 'tblFilmCopy'. It should have how many copy's are availble to rent.. And also, when a film is rented, the...

Hi Scott, you are quite right, the assignment is simpler. RV, I will look into normalisation, thanks for that. Also....my teacher and other student have no idea.....which is rather annoying, and most books seem to be to advance for me. Can anyone recommend any good access books, which will...

I thought that is working, as a customer has more than 1 loan here: I didn't ask you to, I was trying to make it easy for someone to visualise, as looking at a few tables with relationships probably takes longer to understand.

Hi Scott, So does this mean...for now my tables/relationships are correct? Would you like me to upload the database? Thanks

So Far..... Hi Guys, So far this is what it looks like: Now, few more questions :confused: Basicly, at the moment, when you add a loan to a customer, it says he is hiring at 'FilmID #' When a film is on loan to a customer is says 'Film is on loan to 'CustomerID #' And in the loans...

Hi, firstly I have put a similar topic on in 'tables' but for a different issue. Basically I am making a database for a video rental company as my A level coursework. I actually no NOTHING about Access....but the bare basics. The databases main aims are: Inputs: The system should allow the...

Hi Jeremie, Thanks for the advice, that did make it clearer!! I will try and have a go on Friday as i'm away for a few days now. I will get back to you ASAP. Thanks :cool:

To make life a bit easy.....

Hi Guys, Thanks for the advice, I will work on that tonight and get you a screen shot again. In terms on User, Film and Loan ID's, these should all be AutoNumbers right?

Hi everyone, Basicly I am doing an Access Project for my school coursework, but I am really confused and my teacher isn't that great. My coursework is based on a video rental company. The database (in breif) has to be able to bring up a customers details, and add a loan to/under that customers...