Username?

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

Guest

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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a (sequential not autonumber) number in append query 5
concatenate records 2
formatting odd date field in table 1
can I change text field size in output table of make table query? 2
Data Access Layer (DAL) Design - Help please 3
#deleted on linked table select query 2
Converting a number field into a text field 3
Outer Join Question - "join expression not supported" 1

Back
Top