Form Input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I would like to automatically input the name of the person who is inputting
data into my form. I have a field called "Input By" and I want the person's
name to automatically populate that field that is typing in the form. Is
there a way of doing that with out having to set up security where everyone
has to log on. I know it's hard because how does the computer know who is
using the computer. However, each user has their own user's computer name.
My boss don't want a password in the database so I don't know if there is
another way of doing that. Please help.
 
http://mvps.org/access/api/api0008.htm
API: Get Login Name

will give you a means of getting the name used when the user logged into
windows. In the Dirty or BeforeUpdate event of a form, you can use that to
fill your InputBy field.

Of course, if people share machines with a single login, this only gives you
the name of whoever logged in first.

HTH,


"E-mail report using Lotus Notes rather t"
 
Yes, this is very possible, and something that I routinely do in my
applications. Rather than spend the time typing out the "How-To", I can send
you a sample database that demonstrates the technique. If you are interested,
send me a message with a valid reply to address. My e-mail address is
available at the bottom of the contributor's page indicated in my signature
below. Whatever you do, please do not post your e-mail address (or mine) to a
newsgroup message.

Also, if you click on the link on the page I mentioned, please change the
subject to "Form Input" and include this hyperlink in the body of the message:

http://www.microsoft.com/office/com...cess&mid=6129fa6e-ccaa-4129-925f-292261ce16ed

That way, I'll know exactly which request is referenced in your message.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top