Prev: Combo Box to write to table(s)
Next: Overflow
From: Daryl S on 27 May 2010 17:42
PJ -

If you want the date and time, do as Pieter indicated - add this: & " " &
Now()

If you just want the date, add this: & " " & Date()

--
Daryl S


"PJ" wrote:

> Thank Daryl, It worked can a date be added after the user name? If so, how
> would that look.
>
> Thanks again!!
>
> "Daryl S" wrote:
>
> > PJ -
> >
> > Use the On Enter method instead of the On Update method, and put in code
> > like this:
> >
> > If isnull(Me!txtNotesOnTransaction) Then
> > Me!txtNotesOnTransaction = CurrentUser()
> > End If
> >
> > --
> > Daryl S
> >
> >
> > "PJ" wrote:
> >
> > > I have the following code in a memo text field:
> > >
> > > Private Sub txtNotesOnTransaction_BeforeUpdate(Cancel As Integer)
> > > Debug.Print "User: " & CurrentUser() & " " & Me!txtNotesOnTransaction
> > > End Sub
> > >
> > > I want the current user entering data user name to fill in before typing any
> > > other data.
> > >
> > > It is not working any suggestions?
> > >
> > > Thanks!!
First  |  Prev  | 
Pages: 1 2
Prev: Combo Box to write to table(s)
Next: Overflow