Access Logon Form

[ThePro]

I have a form where users usually select from a drop down list their names to
add to the records they are adding. If possible I want to create a new form
that opens before this one and captures their names and then opens up the
next form with their names already selected so it consecuently adds it to
every record their create until they close the form.

Is this possible?

Thanks

 

[Rick Brandt]

I have a form where users usually select from a drop down list their
names to add to the records they are adding. If possible I want to
create a new form that opens before this one and captures their names
and then opens up the next form with their names already selected so
it consecuently adds it to every record their create until they close
the form.

Is this possible?

Thanks

Even better. Use the code at the link beow to automatically capture their
windows logon name. You can then use that as your default value or create a
two field translation table that maps their network profile name to the name
you would rather use. Then they don't have to enter their name at all.

http://www.mvps.org/access/api/api0008.htm

 

[ThePro]

I talked with some ppl at the office and although what you suggested is a
great idea the way users will use that workstation it will probably be logged
on always as different users will be using it without logging off.

So I just want is to create a simpre from with a single drop down menu where
they select a name, press a button and it opens the form they use to fill in
the record with the user filed arleady selected and locked so it enters their
name into each of the records they fill until they close the form.

Thanks

 

[Rick Brandt]

I talked with some ppl at the office and although what you suggested
is a great idea the way users will use that workstation it will
probably be logged on always as different users will be using it
without logging off.

So I just want is to create a simpre from with a single drop down
menu where they select a name, press a button and it opens the form
they use to fill in the record with the user filed arleady selected
and locked so it enters their name into each of the records they fill
until they close the form.

Thanks

Create your form and have the [OK] button hide the form rather than close
it. Then you can always refer to the hidden form any time you want the
current user name.