| | |
|
|
|
Accessing Data on Table |
|---|
| message from Brett on 24 May 2004 |
Hi
I have Access 2003 and my information does not appear in
table when entered via a form....Some data will appear
such as text with no formula attached...can anyone help?
|
| Arvin Meyer replied to Brett on 24 May 2004 |
Except in instances where history is important or processing is unusually
long, calculations are not stored in a relational database. This is because
they can always be recalculated. If you absolutely have to store them, you
need to push the data into a bound textbox or directly into a table using a
recordset. To push the data into a textbox, use some code similar to this in
each text box which is a part of the expression.
Sub MyText_AfterUpdate()
If Len(Me.[MyText2] & vbNullString) >0 And _
Len(Me.[MyText3] & vbNullString) >0 Then
Me.[MyText4] = Me.[MyText] + _
Me.[MyText2] + Me.[MyText3]
End If
End Sub
|
|
Archived message: Accessing Data on Table (MS Access Error Message)
