Storing Dynamic values

  • Thread starter Thread starter Cesar Zapata
  • Start date Start date
C

Cesar Zapata

Hi,

I'm more an excel guy but trying into Access and filemaker... so far
Access looks better. here goes my question.

I have a textbox called lets say txtpoints & txtcalc

so far the expression\formula is kind like this

IIf([points]>1,[points],IIf([points]>=0.01 And [points]<=0.25,-2,100))

the values of the results my change overtime ... How can I store them so
the I can put it in a form so the user can change the value if needed
later on.

Thanks
 
What you're saying is you want to display a default value and then let the
user modify that value to something else, and then store that value in the
table?

Assuming that you have a field in the table to store the resulting value, be
sure that the form's record source includes that field, and bind a textbox
to that field (the control source of that textbox will be the field name).
Then put your expression in the Default Value property of that control (be
sure that points is a field in the form's record source too).

Then, when a new record is created, the default value will fill in, but the
user can change it. And the value that is in the textbox when the record is
saved will be saved into the table.

And, my personal opinion re: ACCESS vs. FileMaker.... stay with ACCESS.
 
Thanks for your answer even though it does not answered my original
quesiton it did answer another question I had.

My original request was something like this.
orignal

form1
txtpoints and txtcalc
txtpoints is empty and txtcalc contains
IIf([txtpoints]>1,[txtpoints],IIf([txtpoints]>=0.01 And
[txtpoints]<=0.25,-2,100)

now lets say I have another extra table called tblSetupvalue and a form
displaying this values.

so in form1.txtcalc I would like to have it like this.
IIf([txtpoints]>form2.txtcondition1,[txtpoints],IIf([txtpoints]>=form2.condition2
And [txtpoints]<=form2.condition3,form2.condition4,100)


I hope you understand me..

and thanks for trying.
 
Thanks for your answer even though it does not answered my original
quesiton it did answer another question I had.

My original request was something like this.
orignal

form1
txtpoints and txtcalc
txtpoints is empty and txtcalc contains
IIf([txtpoints]>1,[txtpoints],IIf([txtpoints]>=0.01 And
[txtpoints]<=0.25,-2,100)

now lets say I have another extra table called tblSetupvalue and a form
displaying this values.

so in form1.txtcalc I would like to have it like this.
IIf([txtpoints]>form2.txtcondition1,[txtpoints],IIf([txtpoints]>=form2.condition2
And [txtpoints]<=form2.condition3,form2.condition4,100)


I hope you understand me..

and thanks for trying.
 
So long as the form2 is open when you're working in form1, what I posted for
you will work in this situation as well. The difference is how you reference
the form and the appropriate control.

You'll want to set the Default Value to something like this:

=IIf([txtpoints]>Forms!form2!txtcondition1,[txtpoints],IIf([txtpoints]>=Form
s!form2!.condition2
And [txtpoints]<=Forms!form2!.condition3,Forms!form2!.condition4,100)

--

Ken Snell
<MS ACCESS MVP>

Cesar Zapata said:
Thanks for your answer even though it does not answered my original
quesiton it did answer another question I had.

My original request was something like this.
orignal

form1
txtpoints and txtcalc
txtpoints is empty and txtcalc contains
IIf([txtpoints]>1,[txtpoints],IIf([txtpoints]>=0.01 And
[txtpoints]<=0.25,-2,100)

now lets say I have another extra table called tblSetupvalue and a form
displaying this values.

so in form1.txtcalc I would like to have it like this.
IIf([txtpoints]>form2.txtcondition1,[txtpoints],IIf([txtpoints]>=form2.condi
tion2
And [txtpoints]<=form2.condition3,form2.condition4,100)


I hope you understand me..

and thanks for trying.








What you're saying is you want to display a default value and then let the
user modify that value to something else, and then store that value in the
table?

Assuming that you have a field in the table to store the resulting value, be
sure that the form's record source includes that field, and bind a textbox
to that field (the control source of that textbox will be the field name).
Then put your expression in the Default Value property of that control (be
sure that points is a field in the form's record source too).

Then, when a new record is created, the default value will fill in, but the
user can change it. And the value that is in the textbox when the record is
saved will be saved into the table.

And, my personal opinion re: ACCESS vs. FileMaker.... stay with ACCESS.
Click to expand...
Click to expand...
 
Back
Top