What is wrong with the database?

[Lou_Reed]

Okay here is the database. Some things are working and some things are not.



For instance: Total Days (for car use)
Car Condition
Tank Level
Tax Rate
Order Status

are some controls that are not working.

Also per lesson 37, I entered the first car as a CAM-422. It list the car as a Hyundai (with all of that cars details) not a CAM-422.

The reason these are not working is not clear to me.
Any help appreciated. Thanks in advance.


Respectfully,,

Lou Reed

[June7]

What does 'not working' mean - error message, wrong results, nothing happens?

Total Days should not be a field in table. This should be calculated when needed. An expression in textbox would be: =[EndDate] - [StartDate]

Same is true for TotalMilage (note this is misspelled, should be TotalMileage) - calculate when needed.

I have no problem entering data into other controls.

The Cars subform container Master/Child Links properties are not set.

[Lou_Reed]

Okay, I simply entered starting and ending mileage on the first entry for a CAM-422.

Once I entered starting and ending mileage, I got the total miles used. I did nothing there. I just got
an answer, Total Miles, calculated.

Tank Level and Condition for Car are not working. They should be.
Where in the tutorial, 35, 36 and 37 does it talk about setting Master/Child links.

It seems that all you would need to enter on say miles is starting and ending. There is no reason to enter Total Miles. it can be calculated.

The same for total number of days.

I do not want to enter data unnecessarily. If it can be calculated, then why enter the data. the calculation must be correct of course.

Thanks for you help.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, I see in the properties sheet that Master/Child links can be set in property sheet. It starts the wizard. Can I just continue there like I was on a
any other control creation?

Thanks in advance.

Respectfully,


Lou Reed

[June7]

What wizard? Do you mean the Subform Field Linker? Set the Master and Child fields.

I don't know why TotalMileage shows calculation for you - it does not for me. There is no expression in TotalMilage or TotalDays.

[Lou_Reed]

Let us take these one at a time. The variables TotalMileage and TotalDays are in the selections for control source when one is setting up the form, RentalOrders. I just put the variables in from that list. I might have added 92 n for TotalMiles in the value for TotalMiles. I doubt it though since it was a value not known by me.

The Master/Child relations for the car form and subform and is CarID. I will use that. I am just uncertain in the tutorial where it discusses putting the second subform and setting up the relationship. It is quite clear in Lesson 38 where to do this in the insertion of the first subform.

Thanks very much for your help.


Respectfully,


Lou Reed

[Lou_Reed]

Okay, here is the database. I corrected the Master/Child relationship in the second subform. Everything works except category. I am unsure as to why since I though it was okay.

I think that I can get the others, but maybe not. The RateAppiled which clearly comes from the car database is not should be shown and it is not.

R,

Lou Reed

[Lou_Reed]

I have got Category taken care of. The first value in the list was missing, so I put it in and things worked. The issue now is everything below that value.

Car Condition
Tank level
Starting date to rent, etc.


do not work.

Any help appreciated.

R,

Lou Reed

[June7]

What does 'do not work' mean - error message, wrong results, nothing happens?

I have no problem entering data into controls.

TotalMileage textbox has 'invalid control source' error. Need to change name of field in table to correct the spelling.

[Lou_Reed]

Okay, I have the database working reasonably well. I am just unsure as to what to put in. If I put start and ending mileage then total mileage
is calculated. I think that also happens with TotalDays. It is just had to put in some (but not all) data, and then leave many things blank.
I do that and other things are left blank.

Do not work applies to the combo box Tank Level and Order Status. They should be combo boxes and I am not getting this in the main form. What am I doing wrong?

Again, thanks for your help.

R,


Lou Reed

[June7]

I don't know if you did anything wrong. What were the tutorial instructions? If no specific instructions regarding these controls, maybe this is a case where it expects you to take what you have learned and apply it.

If you think they should be comboboxes (and that does make sense to me) then make them comboboxes. This is simple design modification.

[Lou_Reed]

Okay, that is what I will do on the combo boxes. I am finding errors of capitalization in Sub Total and Tax Amount. I changed them, but nothing happened.

I just am unclear, if it means say to find daily rental rate from say type of car or is it something that I put in? It seems at times to be both. That is the source of confusion. There are other ones like that, such as Tank Level. Do I take what is in the original list or do I put it in during working on that step.

Again, thanks for your help.


R,

Lou Reed

[June7]

Well, there are no lookup tables for rental rate or condition or tank level. There is no field in Cars for rate.

So, the comboboxes could use a ValueList. The rates could be: 25, 30, 35, 40, 45. Tank levels could be: 1/4, 1/2, 3/4, Full.

Cars table has a field for Condition but this really doesn't make sense to me. Seems the need is to enter a condition at the time the car is rented and also when it is returned. Note that there is also a condition field in RentalOrders.

[Lou_Reed]

I changed the textboxes for TankLevel and OrderStatus on the Rental Orders Form, right clicking and selecting change combo box.

At first I got nothing - nothing work. Then I changed from Form View to Design View. The RentalOrders form was missing the following parameters:

TankLevel
Display Control: Combo Box
Row Source Type: Value List
Row Source:"Empty";"1/4 Empty";"Half";"3/4 Full";"Full"
Bound Column: 1
Column Count: 1
Column Widths:1"
List width:1"

and for OrderStatus:

Display Control: Combo Box
Row Source Type: Value List
Row Source:"Unknown";"Car on Road";"Order Completed";"Order Reserved"
Bound Column: 1
Column Count: 1
Column Widths:1"
List width:1"

I thought since these were already on the RentalOrders table. Thus once RentalOrders table is selected for Record Source it is done.

Anyway, OrderStatus worked and TankLevel did not have them in their property sheet. So I put them in.

The OrderStatus worked, but the TankLevel did not.

I checked TankLevel in the form properties and could find nothing wrong with anything. The syntax was correct. It just was not giving me choices on the combo box.

Then I went back and checked RentalOrders Table and found a syntax error for TankLevel. that I fixed and then the form TankLevel worked.


I am confused now.

What is the relationship for the combo box on RentalOrders form and RentalOrders table? Do both have to be put in? Apparently.

If the is an error in the form which do I look at: form or table?

Things are working now I am just confused as to procedure when something is not working on the form.

Thanks in advance.

R,


Lou Reed

[June7]

Properties set on fields in table will be adopted by controls created on form if the control is created by dragging field from the Field List. Otherwise, already existing controls will not adopt the properties and controls created by icon will not adopt properties.

When changing some properties on field in table, there is a one-time option presented to have the change cascade out to controls.

I seldom set properties (such as combobox setup) on field in table.