How to default CurUser() into a field in a new record in a Select

[Nigel]

Hi,

In my project I have a select query showing data from a single table. This
works well in that it allows the user to view/ edit the existing data and
also to create new records.

When creating new records, I need to record the CurrentUser() and
CurrentDate() into fields on the record. I can do the date via the ‘Default
value’ on the table but can’t set the User field as CurrentUser isn’t
available. Any ideas on how can I do this?

If I scrap the ‘select query’ and carry out record admin via a form I can do
it. Trouble is I value using the ‘select query’ as it allows the user to see
more records of their data and removes complexity.

 

[tina]

Trouble is I value using the 'select query' as it allows the user to see

more records of their data and removes complexity.

how is it that the user can see more records in a query's Datasheet view
than can be seen in a form's Datasheet view? as for removing complexity, you
obviously need a little "complexity" to get the setup you want. IMHO,
allowing users to edit data via an open SELECT query is no better than
allowing them to edit data directly in an table - which is something i
never, ever do under any circumstances. use a form, hon, it doesn't need to
be any more complex than you need it to be to get the job done right.

hth

 

[Linq Adams via AccessMonster.com]

I'm afraid I'd have to agree with Tina on all points, and am particualrly
confused by your statement

"I value using the ‘select query’ as it allows the user to see more records
of their data"

 

[John Spencer]

And as far as CurrentUser goes - unless you have implemented security on
the database - currentUser will return the same value for everyone -
"admin".

Check out the FOSUSER function published at
http://www.mvps.org/access/api/api0008.htm

 

[Nigel]

I knew the answer was easy when you knew what it was.
I'd realised I was one of the new kids on the block, given what I have done
with Access, I hadn't realised I was still that new.

Oh well.

Thanks for the help.

Nigel.

 

[Nigel]

Fortunately, I have 'secured the database' so should have this covered.
Thanks for the thought though.

Nigel.