Storing a computer name


G

Guest

I have searched the discussions board for answers but have not yet found
anything (I think) that will answer my query.

I have a field in a table called ComputerName, I would like access to
determine the users computername when inputting a record so that I know who
has logged the data, but they don't know I am logging it.

I have seen many requests on the discussions pointing to a function, but
when I tried this on another pc on the network, it threw up a vba error which
when checked had missing references. I don't want to go to each users
machine and deselect these missing reference as it will cause suspicsion.

I have therefore seen the code Environ$("computername"), can somebody tell
me where I would store this code so that it records the computer name for
every record input by whichever user.

I tried in the default value, but nothing appeared.

I'm thinking that perhaps in the query, I should change the field
ComputerName to say ComputerName EXPR: Environ$("computername") but am not
sure.

Any help or alternative advice would be appreciated.
 
Ad

Advertisements

P

Pieter Wijnen

Try
Default Value: =Environ$("computername")

You have to precede functions with the = sign for default values

HTH

Pieter
 
Ad

Advertisements


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

Top