append text field based on controls buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I create an event which adds a time stamp and a text string to a
field based on either a check box or a selection from a list box? I'm trying
to create a form which would allow users to quickly update a status board
during certain engagements by clicking a button on the top half of the screen
and having a large text filed on the bottom half record the time and event
which just occured with little or no typing involved. I need to treat each
engagement as a seperate record for historical purposses and each engagement
has several steps which must be recorded. Our current method is to have the
status coordinator place an X in a cell on an MS Excel spreadsheat for the
event and then switch over to MS Word and type in the date, time and what
just occurred. Several things fall through the cracks when the person is a
slow typist

Can someone help?
 
SGT said:
How can I create an event which adds a time stamp and a text string to a
field based on either a check box or a selection from a list box? I'm trying
to create a form which would allow users to quickly update a status board
during certain engagements by clicking a button on the top half of the screen
and having a large text filed on the bottom half record the time and event
which just occured with little or no typing involved. I need to treat each
engagement as a seperate record for historical purposses and each engagement
has several steps which must be recorded. Our current method is to have the
status coordinator place an X in a cell on an MS Excel spreadsheat for the
event and then switch over to MS Word and type in the date, time and what
just occurred. Several things fall through the cracks when the person is a
slow typist
Click to expand...


Use the button's Click event to add the data to the fields
in a table. I'm not at all sure where you want to put this
data, but the date and description really need to be in two
separate fields.

Assuming the date and description are displayed in a
(continuous?) form (or subform?), the button's Click event
procedure would first make sure it's operating on a new
record:
DoCmd.RunCommand acCmdRecordsGoToNew
and then set the time:
Me.txtEventTime = Now()
while it's not clear where the event description is coming
from, if it's a predefined text string associated with a
check box/option button in an option group, then you can use
a little more code:
Me.txtEventDesc = something or other

All this sounds fairly easy to do, but you just haven't
provided enough details for me to be very specific about how
to do it.
 
Back
Top