Trying to make a guest registration form....

[sdupont]

Hi all,

I have a need to make a guest registry, and try as I might, I just
can't seem to get the right programming in the expression builder.
Here is what I need to do.

I have one field labeled "Accommodations" which has a drop down
listing of 7 codes. I need to then a) assign a dollar value to each
code, then b) place that dollar amount in the "Accommodations Fee"
field. Also one of the codes has 3 subtypes each with a different
dollar amount.
Put the "Membership Type" dollar amount in the "Membership Fee"
field,
"Hot Tub" fee (if any) in the "Hot Tub Fee" field
And lastly put the combined total in the "Total Fees" field.
Here is the exact information.

Field "Accommodation" The codes and dollar amounts for this field
are AV = $30, AR=$20, MP=$20, CW=$15, BC=$20, TENT=$10, and last one,
RV has 3 subtypes 1)Full=$20, Elec=$12, Water=$12.

The next one, is the "Membership Type" field and the code and
prices are, BS=$10, SS=$60, RS=$250, SHO=$1000, and GA=$5000,

The last one is "Hot Tub", Y=$5, N=$0.

Then these 3 totals I want to put in the "Total Fees" field.

While I'm sure this is elementary to you folks, for a newbie like
myself, it's daunting. Any help would be greatly appreciated.

Thank You so much.
Sean Du Pont July 31, 2006.

[Tom van Stiphout]

On 31 Jul 2006 18:07:32 -0700, "sdupont" <ao***@hotmail.comwrote:

What happens when the Accomodations fee for AV changes? Do you think
the users want to call the programmer to have him change the
expression to change $30 to say $35? I don't think so.
Or what if there is another surcharge or membership type? Or we have a
"Summer Special" with 10% off pricing? Call in the programmer to fix
an expression?

It appears that you currently don't have this kind of flexibility
built into the system. There seems to be no data-driven programming.

Reservation systems are complex. You're probably going to hate this
answer, but I really believe a good one can only be written by an
experienced professional.

-Tom.

>Hi all,

I have a need to make a guest registry, and try as I might, I just
can't seem to get the right programming in the expression builder.
Here is what I need to do.

I have one field labeled "Accommodations" which has a drop down
listing of 7 codes. I need to then a) assign a dollar value to each
code, then b) place that dollar amount in the "Accommodations Fee"
field. Also one of the codes has 3 subtypes each with a different
dollar amount.
Put the "Membership Type" dollar amount in the "Membership Fee"
field,
"Hot Tub" fee (if any) in the "Hot Tub Fee" field
And lastly put the combined total in the "Total Fees" field.
Here is the exact information.

Field "Accommodation" The codes and dollar amounts for this field
are AV = $30, AR=$20, MP=$20, CW=$15, BC=$20, TENT=$10, and last one,
RV has 3 subtypes 1)Full=$20, Elec=$12, Water=$12.

The next one, is the "Membership Type" field and the code and
prices are, BS=$10, SS=$60, RS=$250, SHO=$1000, and GA=$5000,

The last one is "Hot Tub", Y=$5, N=$0.

Then these 3 totals I want to put in the "Total Fees" field.

While I'm sure this is elementary to you folks, for a newbie like
myself, it's daunting. Any help would be greatly appreciated.

Thank You so much.
Sean Du Pont July 31, 2006.

[sdupont]

Excellent point. Yes, data driven programming seems vital. So, how
would one do a data driven base? To assign changing values to codes
that do remain the same and put those values in another field "total
for that field", then take that value to a "totals" field. The "totals
field" would have input from other fields as well. I really cant afford
prof. help. It's not that complex of a reservation system. It is in
totality as I have described. Thanx for the feedback.
Sean

[pietlinden]

Tom van Stiphout wrote:

Reservation systems are complex. You're probably going to hate this
answer, but I really believe a good one can only be written by an
experienced professional.

-Tom.

I'd have to agree. I tried one once several years ago. A LOT harder
than it looks.

[Tom van Stiphout]

On 1 Aug 2006 10:26:45 -0700, "sdupont" <ao***@hotmail.comwrote:

Data driven programming is a big topic. I'm sure Google will enable
you to find some resources. For me it means that the program is
controlled by records in the database, and I can change its behavior
by changing the data in those (control) tables. The rest of the
program is a more generic engine that just looks at the control tables
to decide what to do.
To make it a bit more specific for your program, you would probably
have an Accomodations table with ID, Code, StandardPrice, and your
dropdown would draw from this table. The data driven part here is that
the price automatically changes once the Administrator changes the
price in some Accom Maintenance form.
You might have a AccomSubTypes table with the 0 or more subtypes for
each Accom. Again those would show based on which Accom was selected.

Happy Programming,

-Tom.

>Excellent point. Yes, data driven programming seems vital. So, how
would one do a data driven base? To assign changing values to codes
that do remain the same and put those values in another field "total
for that field", then take that value to a "totals" field. The "totals
field" would have input from other fields as well. I really cant afford
prof. help. It's not that complex of a reservation system. It is in
totality as I have described. Thanx for the feedback.
Sean

[Ron2006]

Simplistic approach - this is not the best approach because it will
limit expansion but it will work. A good book on Access and data
normalization would be benificial.

3 tables - Accomodation , membership, Hottub - perhaps call it extras

3 fields each
ID - autonumber
Description
Fee

combo1 for accomodation is based on accomodation table, it shows
description, is bound to the ID which is what is saved but has fee as
the third field. In the after updateevent for that box the code would
be something like

me.accomodationfee = me.combo1.column(2) (the count is based
on 0 col1=0)

The other two comboboxes would have the same structure and perform the
same appropriate action.

The source for the total field would be
=nz(me.accomodationfee,0) + nz(me.membershipfee,0) +
nz(me.extras,0)
Ron