As an alternative to going down the full-blown security road, which is not
for the faint-hearted, a DIY login form that accepts a UserName and password
(see 'Input Masks' & Default Values) makes for a limited, though very useful
way to ascertain who logged in & when.
NB: this can be very easily bypassed, but as a place to start, I'd recommend
it.
Paul.
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
er******@tau.ac.il (uv) wrote in message
news:<23**************************@posting.google. com>...
Hi!
I've been asked to write a database in Access and I'm making my first
steps.
I've encountered some problems:
1. I've made forms using the wizard and for some reason the fields are
entered into the tables automaticaly even without submition. How can I
avoid that?
This is default behavior. You can unbind the forms and write the data
to the tables using code, but that's a LOT more work.
2. In a way the opposite question: I would like to have the worker
login and date be automaticaly entered into the forms. How can I do
that?
If you want to use CurrentUser, you have to make users login, which
means you need to implement security. Then you can write the value of
CurrentUser into the table you're writing to in the BeforeInsert event
of your form.