How do you make a date / time stamp while starting a new entry?

#10 (**permalink**) 28-Jul-2006, 08:30 AM

What I did (which hasn't worked):
1) Opened the form in Design Mode.
2) Went into the properties of my Textbox (End Time).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12379-how-do-you-make-date-time.html
3) Wnt into the Before Update box and click the "..."; which is beside the
[Event Procedure].
4) I simply copied your suggestion and pasted it in the code.
5) I suggested putting the "Me." suggested, but it didn't help. I
presented a drop-down of options, but I didn't do anything w/ it.

I'm sure that I have to create a Control & a name for the control. How?

"Rick B" wrote:

> You have to write code that runs on the before update event.
>
> Select "event procedure". Then click the triple dots to go into the vba
> script.
>
> Make your code something like...
>
> Private Sub Form_BeforeUpdate(Cancel As Integer)
> SomeControlName = Now()
> End Sub
>
>
>
>
> replace "SomeControlName" with the name of your control.
>
>
>
> --
> Rick B
>
>
>
> "Shawn" wrote in message
> news:69311261-0E1E-47E5-9B2C-CE6BE45D9F74@microsoft.com...
> > We're half way there. I have the Beginning date/time working. I tried
> > puting the "Now() in the "before update" event but it didn't work. I did
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12379
> > this through the form and in the property for the Ending Date, hoping that
> > the date/time would show up after saving or exiting the newly created
> > event.
> > Was I supposed to do this somewhere within the Table? I couldn't find the
> > "before update" option within the table. Am I doing something wrong?
> >
> > "Rick B" wrote:
> >
> >> Just add a field to your table for the start and end date/time. Add
> >> these
> >> to your form. Personally, I would not make them visible.
> >>
> >> Set the default value on the start time to =Now()
> >> Or, you could use the "before insert" event and set the field "when the
> >> first character is typed in a new record". This would be best if you
> >> leave
> >> the form sitting open and at a blank record between calls.
> >>
> >>
> >> Use code to set the end time to Now() put the code in the "before
> >> update" event.
> >>
> >> I have not tested those events, so make sure it does what you expect.
> >>
> >> --
> >> Rick B
> >>
> >>
> >>
> >> "Shawn" wrote in message
> >> news:2E0222DB-1E4D-40D9-B5A2-19E66C82E78C@microsoft.com...
> >> > My database is used to log and journal technical calls for our product.
> >> > It
> >> > is important for me to keep a date and time for everytime I receive and
> >> > end a
> >> > call. Same thing with any journals that I have attached to that call
> >> > record.
> >> > How do I Make a Date / Time stamp appear when I start a new record
> >> > (when
> >> > clicking the 'New Record' button) and when I end the record (when
> >> > clicking
> >> > the 'Save Record' button)? The date / time can not change once it's
> >> > been
> >> > "stamped".
> >> > Thank you.
> >>
> >>
> >>
>
>
>