creating a log file with MS Access

this is the SQL of my Append Query

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser, Now());



Rick Brandt wrote:
"snipersix" wrote in message
oups.com...
im sorry i made a mistake the error was

Run-time Error '3061'

too few parameters. expected1

Post the SQL of your query.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"snipersix" wrote in message
oups.com...
this is the SQL of my Append Query

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser, Now());

CurrentUser is a function so you need the () on the end just like you have after
Now().

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser(), Now());

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

great now it works, thank you very much for your help


Rick Brandt wrote:
"snipersix" wrote in message
oups.com...
this is the SQL of my Append Query

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser, Now());

CurrentUser is a function so you need the () on the end just like you have after
Now().

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser(), Now());

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com