Required date

[samotek via AccessMonster.com]

On my form i have two fields from the table orders: order date and required
date.
I want to put in the after update event of the control orderid the following
expression
Me![required date] = Me![order date]
and to increase the order date with 10 days

Can i do it ?

 

[Douglas J. Steele]

You can, but if you're always always going to be increasing Order Date by
ten days, you probably shouldn't, as it's usually considered a bad idea to
store computed fields.

Anyhow, it would be

Me![order date] = DateAdd("d", 10, Me![order date])

 

[Allen Browne]

1. In form design view, right-click the Order Date text box, and choose
Properties.

2. Set its After Update property (Event tab of Properties box) to:
[Event Procedure]

3. Click the Build button (...) beside this.
Access opens the code window.

4. Between the "Private Sub..." and "End Sub" lines, put your line of code,
i.e.:
Me![required date] = Me![order date] + 10

This assumes that the required data should default to 10 days after the
order date, but you are happy for your user to then go and type any date
there instead.

 

[Gina Whipp]

samotek,

Yes

Me![required date] = Me![order date] + 10

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[samotek via AccessMonster.com]

Thank you ! it works !

You can, but if you're always always going to be increasing Order Date by
ten days, you probably shouldn't, as it's usually considered a bad idea to
store computed fields.

Anyhow, it would be

Me![order date] = DateAdd("d", 10, Me![order date])

On my form i have two fields from the table orders: order date and
required

[quoted text clipped - 6 lines]

Can i do it ?

 

[samotek via AccessMonster.com]

Thank you ! it works !

You can, but if you're always always going to be increasing Order Date by
ten days, you probably shouldn't, as it's usually considered a bad idea to
store computed fields.

Anyhow, it would be

Me![order date] = DateAdd("d", 10, Me![order date])

On my form i have two fields from the table orders: order date and
required

[quoted text clipped - 6 lines]

Can i do it ?

 

[samotek via AccessMonster.com]

Thank you ! it works !

You can, but if you're always always going to be increasing Order Date by
ten days, you probably shouldn't, as it's usually considered a bad idea to
store computed fields.

Anyhow, it would be

Me![order date] = DateAdd("d", 10, Me![order date])

On my form i have two fields from the table orders: order date and
required

[quoted text clipped - 6 lines]

Can i do it ?

 

[samotek via AccessMonster.com]

Thank you ! it works !

You can, but if you're always always going to be increasing Order Date by
ten days, you probably shouldn't, as it's usually considered a bad idea to
store computed fields.

Anyhow, it would be

Me![order date] = DateAdd("d", 10, Me![order date])

On my form i have two fields from the table orders: order date and
required

[quoted text clipped - 6 lines]

Can i do it ?

 

[samotek via AccessMonster.com]

Thank you ! it works !

You can, but if you're always always going to be increasing Order Date by
ten days, you probably shouldn't, as it's usually considered a bad idea to
store computed fields.

Anyhow, it would be

Me![order date] = DateAdd("d", 10, Me![order date])

On my form i have two fields from the table orders: order date and
required

[quoted text clipped - 6 lines]

Can i do it ?

 

[samotek via AccessMonster.com]

Thank you ! it works !

You can, but if you're always always going to be increasing Order Date by
ten days, you probably shouldn't, as it's usually considered a bad idea to
store computed fields.

Anyhow, it would be

Me![order date] = DateAdd("d", 10, Me![order date])

On my form i have two fields from the table orders: order date and
required

[quoted text clipped - 6 lines]

Can i do it ?