DVD Rental Database
Sunday March 14, 2004
In a recent forum posting, HIPHOPDREDAY asks:
"Hi. I have loads of dvd's and i'm at uni and my housemates are always borrowing my films so one day i decided that i would make up a rental system database on access xp just to pass the time. however i soon discovered that i got an E in my Computing A Level for a reason. I am totally stumped on how to go about this task. I have set-up a table of my dvd's. a table for my housemates and a table for rentals. i then set-up queries for the different genres of films, a list of available and not-available films and also a quetry for customers. i then made a form but i cannot for the life of me remember how to get my database to work in the format of:
a housemate goes to a form to rent movies. they choose the films they want and these are sent to the rentals form. ther movies that have been rented then go into the 'not available' category. when the films are returned the films returned then go into the 'available' category. it should be simple enough to do but i just cant work it out. can anyone help?
"Hi. I have loads of dvd's and i'm at uni and my housemates are always borrowing my films so one day i decided that i would make up a rental system database on access xp just to pass the time. however i soon discovered that i got an E in my Computing A Level for a reason. I am totally stumped on how to go about this task. I have set-up a table of my dvd's. a table for my housemates and a table for rentals. i then set-up queries for the different genres of films, a list of available and not-available films and also a quetry for customers. i then made a form but i cannot for the life of me remember how to get my database to work in the format of:
a housemate goes to a form to rent movies. they choose the films they want and these are sent to the rentals form. ther movies that have been rented then go into the 'not available' category. when the films are returned the films returned then go into the 'available' category. it should be simple enough to do but i just cant work it out. can anyone help?
Comments
You should set up a command button on your form that says “Process Rentals” or something. When they press the button it will process your code. You would then have to put your SQL or VB code in there that puts the textbox.text contents into a string or an array, whichever you are more comfortable with, then write generic sql or vb code with those string variables in there.
You could probably record a macro that performs the action and then copy the code into the button code, since it will always be those records referred by the text boxes.
Hope that helps.
If somebody had done it or developed it, please mail it to me in santosh_ku_panda@hotmail.com
im having the same problem could someone help me please. Email me on Ervin_dara@yahoo.co.uk than you
i have been working on a database of this kind at school if you send me a table of your films i may be able to help you out