DVD Rental Database

[Golddust]

Hello all,

I am a student and in need of some serious help. For our Coursework we were told that we needed to create a database for a company of our choosing. I did some research and decided to pick a DVD rental shop as i thought this would be a good idea at the time. Now its come the time to actualy start making the thing and i am in serious trouble..i have no idea how to use access..i have tried going through all the tutorials but they confuse me more!

all i have so far is 4 tables..customers..DVD's..rentals.and Suppliers..i need to know how to create a input form so i can add new customers but when i try to create a form and then go to pick out the feilds..there is no fields to choose from!

i really really really need some help here.

thanks foe reading

Jon

 

[ColinEssex]

You are going to have a problem I think.

First, create the tables with the fields in them. Check out "normalisation" so that you can get the relationships right between the tables. Then create a query to use as a recordset for your main input form. Use that query to then create the form.

As a matter of interest, if you have no idea at all, how does the college expect you to do it? or have you missed all the classes

Col

 

[Golddust]

Thanks for your reply.

Ive done what u asked and it seems to be working now. i have created a good input form for adding new customers.

What i need now is to creat a form were i can search for a customers records based on there customer ID so i need an input box were the customer ID is inserted and when the serahc is complete i want the customers details of that ID to appear. is this possible?

Also the reason i am not so good with access is because when i was being taut how to use it. I just wasnt picking it up. My fault

Thanks

Jon

 

[rainman89]

Id use a combo box whose source is your customer table (Cust ID) and limit it to the list that way u can only select the customer IDs that exist

 

[Golddust]

Thanks rainman. i tried this just a minute ago but wheni go to select the table/query i want to use for the data it tells me that there is no valid fields in the table/query. but there is.. i dont understand..i tried doing it with all the tables and queriies i have but i keep getting the same error message.

thanks

Jon

 

[rainman89]

interesting.. your statement should be something like
SELECT [CustID] FROM [TableCustomer].. that simple. its weird that it cant find any values..

 

[Golddust]

yes just treid this and when i go to select from the new drop down list box..it i blank..for some reason it is not picking up any of my fields.

Thanks

Jon

 

[rainman89]

There is another problem going on then.
if it cant read from your tables to select info from them thats a big problem.

you are using the wizard to make a combo correct?
the select info from table or query option?

 

[Golddust]

yess that is correct i am using the wizard to make the combo boxes. and i tried to select info from the query option and no luck. i have also tried the table option to see if that works but no.

Thanks

Jon.

i can send u the file if u like..just email me @ whittlephones1@aol.com

 

[rainman89]

post it up here.

Compact and repair then zip!

 

[Rich]

Put the combo box in the Form header and select "find a record on my form" from the wizards list of options

 

[Golddust]

Thank you Rich, i tried it but still no luck i just keep getting the error message "No valid fields were found "customerDetails". Please select another source"

it wont let me upload it for some reason. Its just not working for me..stops uploading alf way through.

Thanks

Jon

 

[rainman89]

make sure the file is under the 500 kb or whatever the limit is

 

[Golddust]

ok i have now attached the file to this message.

thanks

Jon

 

[rainman89]

Here i added the combo box to the view/edit form!

 

[Golddust]

Hello,

Thank you very much for that much apprieated.

ill let u know if i run into any more problems. lol

Thanks again

Jon

 

[rainman89]

Not a problem. glad i could help.
For future reference.
if u use the combobox wizard and do like rich said

Put the combo box in the Form header and select "find a record on my form" from the wizards list of options

Itll work fine. thats all i did!

 

[Golddust]

Hell again,

I have ran into the same problem again with the suppliers form..I am trying to put a combo box at the top..but again it just keeps saying "no valid fields were found" i have tried doing what you said you did but i cant find that option.

when the combo bozx wizard appears it only gives me 2 options..1 which is "i want the combo box to lookup values in a table or query" and the other is "i want to enter the values my self. and thats all there is.

i am using access 2003..is this why?

thanks

Jon

 

[rainman89]

no. i am also using 2003. post it up ill look

 

[Golddust]

ok here it is..Its the View/edit Supplier detials in the forms section..I am also having another problem here..when i open the "add new supplier" form i want the input boxes to be blank ready for new data..but they are not blank they have records from the tables in there..do u know what i am doing wrong?

Thanks for looking

Jon