HELP!! Need to edit variables in an access file.

[RB26DETTGT_R]

Hi guys, Im pretty new wqith MS Access.

I have a program from a relative of mine which I am attempting to
debug. It is a program which allows the user to enter dockets for truck
deliveries, enter the kn's travelled, load carried, penalty rates, etc,
and then calculates the final total price, including taxes.

The problem is, Every km has a different rate (e.g 36km's=0.78 cents,
37km's= 0.90 cents, etc...) Now, 2 of the km variables have the wrong
rates entered from whoever made the program, and I cant find a way, or
option, to edit these variables. Im sure it is extremely difficult for
most to understand without seeing the program, but maybe somebody knows
of an option to edit a variables list, or wher it can be found? I want
to change, for example, 37km's =0.90cents to 0.92 cents.

Thanks for your help, whoever can help me

 

[___]

Check in any modules for the values, or, if there are none, look in th
code behind each form, I'm sure you'll find it there.

HT

 

[Brendan Reynolds]

Access is very flexible, and provides developers with a range of choices as
to where and how they store and retrieve lists of values such as these. They
could be variables or constants in a VBA module, or they could be stored in
a lookup table. There are other options, but these two would be by far the
most common.

Try working from the end result backwards. Find a text box on a form or
report that uses these values, and examine the Control Source property for
the text box. Hopefully, you'll be able to follow the trail back from there.
If you get stuck, post a follow up message here describing what you've been
able to find so far.