DVD Rental Database

[rainman89]

Are you sure u are using the combo box wizard located on the toolbar? because all i am doing is creating the combo box

 

[Golddust]

Yes that is the box which is appearing when i click on the combo box wizard but i only get two options. the third option isnt there when i try...Wierd

 

[rainman89]

Here ya go. I set the visible property of the detail section to false until you make a selection of a customer id or a supplier id. Instead of making them blank!

 

[Golddust]

Yes that is the box which is appearing when i click on the combo box wizard but i only get two options. the third option isnt there when i try...Wierd

 

[Golddust]

ok heres a screeny of what i am getting here

 

[rainman89]

That is wierd. The upload that i have there should take care of your problems

 

[Golddust]

Ive got a few more minor problems which i cant seem to sort out wordered if u can take another look:

1. On the "Add New Supplier" Form. When i first open it there is data/information already on the input boxes..I am trying to get it so when i open the form "add new Supplier" the input boxes will be blank ready for the user to input info.

2. On the "ADD New DVD" form i am trying to get it to display the Supplier ID and the Company name in the dame combo box so it is easier for the user to identify the Supplier but its just not happening for me. i have got it so it displays just the Supplier ID but i need the company name also.

Thanks again

Jon

 

[rainman89]

Ok on the "add new supplier form" change its mode to data entry, it will open to a new record.

On the "add dvd form" u need to change the comobbox properties. if you still want to see the supplier ID with the name change the 0" to .5" or something like that

see pics attached

 

[Golddust]

Thank you rainman. ive sorted that all out now.

Now formy next step.

One the Customers details page i want to create a tab which when clicked will display all the customers past and present rentals to date. I know that i need to create a query but am 100% on what to do. could you explain?

Thank you for the help

Jon

 

[rainman89]

One the Customers details page i want to create a tab which when clicked

a tab or a button?

U do just that. create the query using the wizard and set the filter to the customerID
ie SELECT (whatever info here, dvd rentals, date, etc) FROM "yourtblcustomers" WHERE (customerID=customerID open on the form)
i think the easiest way (for me anyways) would be to create a seperate form(whose recordsource is the query) and set it up using the cmd button wizard to open up the form and show a specific record

 

[Golddust]

do u think it would be easier to create a new form and embed the new form in the customer form? How is this done?

 

[rainman89]

you want to see the customer dvd information on the customer form?

These "embedded forms" are called subforms and all you need to do is create the form based on the query, then drag it in to the existing form.

youll have to adjust the query though.
the customer ID in the query would be based off of the combo box that we set up before

 

[Golddust]

Thanks for your reply.

I have now added the query to the "view/edit Customer Details" but i cant get it to display the relavant feilds. i want it to only show the data from the Customer who's data is being displayed.

Do u know how..

i have added the file incase u want to take alook

 

[rainman89]

For future information. dont put spaces or "/" in a form name. it confuses things.
Also dont use spaces in table/field names

2nd you need to change the supplier combo box on the add new dvd form so that its bound column is 1 and its control source is supplier ID( tried to add a new dvd and it wouldnt let me)

now to the query
add the following to the criteria of the customer id

[Forms]![View/Edit Customer Details].[Combo35]

no results will show up beacuse u have no entries in it yet! so fix those problems and let me know what else comes up

 

[Golddust]

OK. fixed all them problems. so thank you.

What i am looking for now it to create a switch board but i dont want any old switchboard i want one from an example access database i found on the microsoft site. i like the layout and the way it works. The only thing now is that i have no idea how to copy the switchboard from that DB to mine.

I have attached Both Files incase you want to take alook.

Thanks again for the help

Jon

 

[rainman89]

before doing this i would backup your database!

go to file>
get external data>
import and select the switchboard from the sample

 

[Golddust]

Another quick question..i am going to purchase microsoft office 2007 this afternoon and i was wondering whether it would effect the DB at all?

 

[rainman89]

2007 is buggy still, i wouldnt go there
Ill stick with 2003 thank you

Others may be more qualified to answer this question!

 

[rahulgty]

I am attaching a sample of this kind project "Video Rental", which I had prepared year ago. Hope it can help you.

 

[Golddust]

OMG..I think u have just saved my life. Thank you..that has also helped alot