AUTOMATIC DELETION OF CELL CONTENT

[roy.okinawa]

Cell A updates daily, the day difference between dates in Cell B and C.
However, once I enter a date in Cell D, I would like Cell A to stop
calculating and become blank. Is this possible?

 

[Ofer]

I think you made a mistake with the Discussion group tou posted this question
in, It sound like an Excel question, and you posted it in Microsoft Access
discussion group

 

[roy.okinawa]

No it is for Access. I created a Access screen where I input my data. I
wasn't sure what to call the boxes where data is input to.

Thanks.

 

[Ofer]

In Access we refer to cells as Fields
So how did you set the value in fieldA?

In the control source of fieldA you can try this formula

=IIf([D] Is Null,iif(FieldB Is Null Or FieldC Is
Null,Null,DateDiff("d",FieldB,FieldC)),Null)

 

[roy.okinawa]

Thanks.

Field A shows cumlative days =DateDiff("d",[Date Received At Vendor],Date())

Once Field D has a date I want Field A to stop and become blank.

I will try the below formula.

In Access we refer to cells as Fields
So how did you set the value in fieldA?

In the control source of fieldA you can try this formula

=IIf([D] Is Null,iif(FieldB Is Null Or FieldC Is
Null,Null,DateDiff("d",FieldB,FieldC)),Null)

No it is for Access. I created a Access screen where I input my data. I
wasn't sure what to call the boxes where data is input to.

Thanks.

 

[David C. Holley]

While we should be able to walk you through you challenges, I would
*HIGHLY* recommend that you read up on Access to ensure that you
understand Access and DB related terminology. You'll find that it will
save you a lot of time and it might actually help you to understand &
solve future problems. Awhile back, SYBEX was publishing a book entitled
'Access Developer's Handbook' (or something similar). I used the A2.0
version and have never bought any other Access-related books.

Thanks.

Field A shows cumlative days =DateDiff("d",[Date Received At Vendor],Date())

Once Field D has a date I want Field A to stop and become blank.

I will try the below formula.

:

In Access we refer to cells as Fields
So how did you set the value in fieldA?

In the control source of fieldA you can try this formula

=IIf([D] Is Null,iif(FieldB Is Null Or FieldC Is
Null,Null,DateDiff("d",FieldB,FieldC)),Null)



:

No it is for Access. I created a Access screen where I input my data. I
wasn't sure what to call the boxes where data is input to.

Thanks.

:


I think you made a mistake with the Discussion group tou posted this question
in, It sound like an Excel question, and you posted it in Microsoft Access
discussion group

--
I hope that helped
Good Luck


:


Cell A updates daily, the day difference between dates in Cell B and C.
However, once I enter a date in Cell D, I would like Cell A to stop
calculating and become blank. Is this possible?

 

[roy.okinawa]

Thanks. I will get the book.

While we should be able to walk you through you challenges, I would
*HIGHLY* recommend that you read up on Access to ensure that you
understand Access and DB related terminology. You'll find that it will
save you a lot of time and it might actually help you to understand &
solve future problems. Awhile back, SYBEX was publishing a book entitled
'Access Developer's Handbook' (or something similar). I used the A2.0
version and have never bought any other Access-related books.

Thanks.

Field A shows cumlative days =DateDiff("d",[Date Received At Vendor],Date())

Once Field D has a date I want Field A to stop and become blank.

I will try the below formula.

:

In Access we refer to cells as Fields
So how did you set the value in fieldA?

In the control source of fieldA you can try this formula

=IIf([D] Is Null,iif(FieldB Is Null Or FieldC Is
Null,Null,DateDiff("d",FieldB,FieldC)),Null)



:


No it is for Access. I created a Access screen where I input my data. I
wasn't sure what to call the boxes where data is input to.

Thanks.

:


I think you made a mistake with the Discussion group tou posted this question
in, It sound like an Excel question, and you posted it in Microsoft Access
discussion group

--
I hope that helped
Good Luck


:


Cell A updates daily, the day difference between dates in Cell B and C.
However, once I enter a date in Cell D, I would like Cell A to stop
calculating and become blank. Is this possible?

 

[Tim Ferguson]

Field A shows cumlative days =DateDiff("d",[Date Received At
Vendor],Date())

Once Field D has a date I want Field A to stop and become blank.

I think this is a GUI question rather than a tables design one. I think
you are referring to textboxes on a form, not fields in a table.

In which case, you can use the control events to do what you want. Trap
the OnChange event of textbox D with something like


Private Sub txtD_Change()
If Not IsNull(txtD.Value) Then
' if it has a value, stamp on the other control
Me!txtCumulativeDays.ControlSource = ""

End If

End Sub

If you need to re-activate the control when you move to a new record,
then use the form OnCurrent event

Private Sub Form_Current()
Me!txtCumulativeDays.ControlSource = _
"=DateDiff("d",[Date Received At Vendor],Date())"

End Sub


If all this is hungarian to you, then you need to read up about Access
events and forms as David has suggested.

B Wishes



Tim F