Error in creating subform control source

[Lou_Reed]

I believe that I have found another error in the Ceil Inn tutorial.



In the area where they are creating a subform (RoomOccupancySummary) the control source for Room Use
is stated:

=[sbfOccupancies]*[Form]*[txtRateTotal]

I believe it should be:

=[sbfOccupancies]*[Form]*[txtRoomUse]


in other words replace [txtRateTotal] with [txtRoomUse] and it should work.


I am not sure what the formula is doing (I know it is calculating Room Use, but I am not clear how it is doing that), but on examining the other two formulas it appears that this correction is required.

Is this accurate?

Thanks in advance.

Respectfully,


Lou_Reed

[June7]

The * characters do not make sense in that context and the expression will error. Consider:

=[sbfOccupancies].[Form].[txtRoomUse]

[Lou_Reed]

I did.

It just seems odd to use in that formula txtRateTotal instead txtRoomUse. As you can see in the third formula they
use is

=Nz([txtRoomUse])+Nz([txtPhoneUse])

this is clearly the sum of the first two calculated values. RoomUse and PhoneUse. So it would make sense to change
the first formula from

=[sbfOccupancies].[Form]![txtRateTotal]

to

=[sbfOccupancies].[Form]![txtRoomUse]

Again I am not sure what these terms are I am only analyzing them in context.

I need to know more about Nz I am guessing.

ley me check Nz and see what it means.

Respectfully,


Lou_Reed

Thanks in advance.


Respectfully,


Lou_Reed

[June7]

What is RoomUse data? Why would it be added to phone charges?

[Lou_Reed]

I see your point. I guess then based on that fact, that the third and final formula on that page is incorrect. Since it also uses RoomUse data.

The final value is the sum of the first two calculations so it also cannot use RoomUse data.

This is another error in the Ceil Inn tutorial?

Thanks for your response. it is much appreciated.

Respectfully,


Lou_Reed

[June7]

Possibly error. Already confirmed other errors.

[Lou_Reed]

Yes, but don't you think it easier if there were a way for it to show all undefined variables in the program or system. I assume
this is interpreted code.

Maybe we are spoiled, but when it points out undefined variables it make life a little easier.

Respectfully,


Lou_Reed

[June7]

Not sure what you mean. Use of Option Explicit in module headers will force all VBA variables to be declared. If controls are improperly referenced in VBA, the debug compiler will error. If controls are improperly referenced in Access forms and reports expressions or in queries, an error will be indicated or trigger input prompt.

[Lou_Reed]

I guess that I have been bitten by this error before. In programming the error jumps out at you
usually during compile time, but certainly during run time.

By the way, what does txtRateTotal mean. In other words what does putting the txt in front of a variables name
do?

Respectfully,


Lou_Reed

[June7]

Prefixing variable or object names with an indication of the type is a common (and optional) naming convention. In this case txt probably means a textbox (I use tbx). cbx could be for combobox, lbx for listbox, lbl for label, etc.

VBA variables could be like dblAmt, intQty, txtName, dteStart, etc.

Whatever convention you adopt, be consistent.

[Lou_Reed]

Okay, but I think it is the only place the txt is used on the variables in question.

Also, should not the NewOccupancy Form have navigation buttons? We putting more that than one date for
Customer Accnt. 100752 by Employee 24095.

It seems another Ceil Inn tutorial error?


Respectfully,


Lou_Reed

[June7]

Do you mean the intrinsic navigation bar at bottom of form? Activate if you want to.

[Lou_Reed]

Yes that is what I meant. I will activate to see if it helps in inputting data.

Respectfully,

Lou_Reed

[Lou_Reed]

I will activate the navigation button on the NewOccupancy form. It seems the only way to input multiple pages of data
on the NewOccupancy form.

However, just to be sure. Am I missing something here? Is there a way to input multiple pages of data on this
NewOccupancy form and not need to use navigation buttons?

Any help appreciated. Thanks in advance.

Respectfully,


Lou_Reed

[June7]

Unless the form is opened by another form and only to a new record row then closed after entering single record, there must be a method for navigating. If not the intrinsic bar then custom command buttons.