Recent content by hemolytucus

Attached is the ER diagram for my project. Thanks. Any help will be appreciated

Hi All I am creating a videostore database . I 'd like to create a form that shows the customers details and from that form the employee can add videos/games that will be issued to the customer using buttons. I am also plabning to use the same form when a customer returns the items issued to...

I tried adding the code and it add new record added a new record but it didn't appear beneath the the previous record.

Hi All, I'm doing a school project and just need to ask for your help. How can I add a new line of record below a previous record after pressing the add button? I have attached a picture of my project Thanks

so if I type the last name "cruz" and select last name on the combo box/ it will search all customer with cruz as their last name?

Hi I am creating a a text box where the user enters a text then clicks an option from the option that is used as the criteria for the search e.g. Last Name, Phone , address then a command button wil run a query. is this possible? Any tips on how to do this. Thanks

Thank you guys. I know its possible to search items from multiple fields but will I be able to use a single search box to search for a specified field:banghead:

Hi I am creating a database for a rental store for a coursework. I am bit confused as to how tblHiredItem will be able to automatically get the HireageID from the tblHireage without trying to "search" or keying the HireageID Thanks

Hi I am creating search boxes within that searches customer by lastname, phone number, address and suburb. Will I be able to use one search button for all of them or do they have to be individual buttons? Any help will be greatly appreciated. Thanks

Thanks PR2-Eugin!!!. You are awesome!

Hi PR2-Eugin Thanks for your reply. My query now works but I still can't make the open form macro open customers living in the suburb. I am bit confused what should I write on the WHERE clause of the OPEN FORM macro. Thanks

Hi All, I am Access noobie. I am creating a form that searches customers by suburb. My table structure is like this tblCustomer tblPostCode CustomerID CustomerName PostCodeID PostCodeID(FK) SuburbName My question is how do i create a form that asks the...