How can i store expressions in table?

[smahdih]

hi everyone



i create a table with below field
Field name Type
ToolsCode Text Primary Key
ToolsName Text
OldCalibration Date and Time
LeadTimeCalibration Date and Time
DueDateCalibration Date and Time

and create a form with above fields, i want DueDateCalibration equal with OldCalibration + LeadTimeCalibration

How can i do?

[orange]

Don't store a calculated field.
Use a query to do the calculation whenever that value is needed.

In this case use the wizard to create a bound form.
Then add a textbox and set its value to your expression.
You may need to work with DateAdd or DateDiff function .

[smahdih]

Don't store a calculated field.
Use a query to do the calculation whenever that value is needed.

In this case use the wizard to create a bound form.
Then add a textbox and set its value to your expression.
You may need to work with DateAdd or DateDiff function .

now i have below form (attach)

by DateAdd adds [previousCalibration] and [Priode], the Enabled Property is "No"

when click on "save" i want save current record , how do this?
[dueDateCalibration] save in table??

Tnx

[orange]

Do NOT save a calculation in a table.

Run the query or display a form (based on a query) to get the calculated value whenever you need it.

I have attached jpgs a form (design) , form values and the table involved.

Not sure where your Type? problem comes from, but don't store a calculated field.

[smahdih]

very very tnx , i fixed it

but i have question again

i want when open an access file turn up a form not by clicking on form
how do it?

[orange]

Can you provide more info or an example? I'm not understanding what you are trying/wanting to do.

You can open formB from an event on a different Form, or other condition.

[smahdih]

very very tnx , i fixed it

but i have question again

i want when open an access file turn up a form not by clicking on form
how do it?

[smahdih]

very very tnx , i fixed it

but i have question again

i want when open an access file turn up a form not by clicking on form
how do it?

[orange]

i

want when open an access file turn up a form not by clicking on form
how do it?

Please provide more info. What exactly are you trying to do?

[smahdih]

sorry for same posts

my purpose that is when i open a access file a special form appear simultaneous.

like switchboard in access

how do it?