Field Append, Update....newbie access'er

[Guest]

I am stuck on trying to append/update a field for two particular
application....

1) i created a command button and when it is pressed. it will enter
today's date on a field. This will be read only on the form view, if thats
possible. It wont be used as "LastModified" function.

2) I will have 2 fields. the first one is read only, while the 2nd is
where the user enters comments. Once the comment is entered an "update"
button will be pressed and the text entered will move up to the first field
with a time/date attached to the end. the first field will serve as
historical memos.

i may be entering the wrong keywords at microsoft help....i cant get a clear
direction...please help

 

[Vincent Johns]

OK, I set up a Table, a Macro, and a Form with the following properties
(abbreviated list):

Table: [Comments]

Columns
Name Type Size
---------- ------------- --------
CommentsID Long Integer 4
Attributes: Fixed Size, Auto-Increment
Saved Memo -
DateSaved Date/Time 8
NewComment Memo -



Form: [F_Comments]

Text Box: Saved
Enabled: False

Text Box: DateSaved
Enabled: False

Command Button: cmdUpdate
Caption: Update
Enabled: True
OnClick: [Event Procedure]
= [M_Update] Macro

Text Box: NewComment
Enabled: True



Macro: [M_Update]

Actions
SetValue
Item: [Forms]![F_Comments]![Saved]
Expression: [Forms]![F_Comments]![NewComment]

SetValue
Item: [Forms]![F_Comments]![DateSaved]
Expression: Now()

I am stuck on trying to append/update a field for two particular
application....

1) i created a command button and when it is pressed. it will enter
today's date on a field. This will be read only on the form view, if thats
possible. It wont be used as "LastModified" function.

The [DateSaved] and [Saved] controls are ghosted (gray text, obviously
not changeable), and the other 2 controls are active. Clicking
[cmdUpdate] causes the date & time to be entered into
[Comments].[DateSaved] on the currently visible record.

2) I will have 2 fields. the first one is read only, while the 2nd is
where the user enters comments. Once the comment is entered an "update"
button will be pressed and the text entered will move up to the first field
with a time/date attached to the end. the first field will serve as
historical memos.

I made 4 fields visible (2 active); the copied comment and the date/time
are visible. If the user entered a comment without clicking
[cmdUpdate], the 2 disabled controls are empty.

However, this design does not protect against saving new values on top
of (= replacing) old ones. (Caveat emptor.) But I think it does a lot
of what you described.

i may be entering the wrong keywords at microsoft help....i cant get a clear
direction...please help

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.