Username?

R

Rickard Sjöberg

H

I'm currently using an access form to collect information from an AS400 database (SQL
There are no problems to import the information from the AS400 into a table in access, however i would like to add a field for the UserID which contains the domain username. The information from AS400 is inserted by using a question, activated by scanning a barcode.

thank
Rickar
 
M

MGFoster

Rickard said:
Hi

I'm currently using an access form to collect information from an AS400 database (SQL)
There are no problems to import the information from the AS400 into a table in access, however i would like to add a field for the UserID which contains the domain username. The information from AS400 is inserted by using a question, activated by scanning a barcode.
Click to expand...

Try this URL:

Get Login Name:

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

Rickard Sjöberg

I can get the username from the computer, the problem i have is to write the username to the same post that is created by the SQL query.
 
Top