Default value in table field (username and computername)

This used to work fine in Access 2003 to insert a default value in a field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007

I believe it should work in Access 2007 as well, although I always cringe
when I see people use the Environ function to return the user ID given how
easy it is to change.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"mario" wrote in message
...
This used to work fine in Access 2003 to insert a default value in a
field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007

I'm with Douglas on the vulnerability of this approach. Have you looked
into using a call to obtain the NT logon instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"mario" wrote in message
...
This used to work fine in Access 2003 to insert a default value in a
field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007

http://www.mvps.org/access/api/api0008.htm and
http://www.mvps.org/access/api/api0009.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff Boyce" wrote in message
...
I'm with Douglas on the vulnerability of this approach. Have you looked
into using a call to obtain the NT logon instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"mario" wrote in message
...
This used to work fine in Access 2003 to insert a default value in a
field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007

These won't work as field defaults in a table design but will work as
defaults for controls in forms. Users should only interact with forms so this
should work.

--
Duane Hookom
Microsoft Access MVP


"Douglas J. Steele" wrote:

http://www.mvps.org/access/api/api0008.htm and
http://www.mvps.org/access/api/api0009.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff Boyce" wrote in message
...
I'm with Douglas on the vulnerability of this approach. Have you looked
into using a call to obtain the NT logon instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"mario" wrote in message
...
This used to work fine in Access 2003 to insert a default value in a
field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007

"Thanks Duane. I would ideally do something like "=Environ("USERNAME") & "
on " & Environ("COMPUTERNAME")" in the default value of the field in table
design, without having to deal with form.

I agree, I am not a IT person. Why are people saying that "I always cringe
when I see people use the Environ function to return the user ID given how
easy it is to change".

If it was easy to accomplish in Access 2003 using "=Environ("USERNAME") & "
on " & Environ("COMPUTERNAME")", why was it taken off in Access 2007 without
an alternate way of doing it.

Thanks
Mario





"Duane Hookom" wrote:

These won't work as field defaults in a table design but will work as
defaults for controls in forms. Users should only interact with forms so this
should work.

--
Duane Hookom
Microsoft Access MVP


"Douglas J. Steele" wrote:

http://www.mvps.org/access/api/api0008.htm and
http://www.mvps.org/access/api/api0009.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff Boyce" wrote in message
...
I'm with Douglas on the vulnerability of this approach. Have you looked
into using a call to obtain the NT logon instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"mario" wrote in message
...
This used to work fine in Access 2003 to insert a default value in a
field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007

I'm not sure why the functionality was removed. To be honest I was very
surprised to hear that it worked in earlier versions.

Many of us "mature" Access programmers don't believe in offering table
datasheet views to users. There is much greater control and functionality
with forms.
--
Duane Hookom
Microsoft Access MVP


"mario" wrote:

"Thanks Duane. I would ideally do something like "=Environ("USERNAME") & "
on " & Environ("COMPUTERNAME")" in the default value of the field in table
design, without having to deal with form.

I agree, I am not a IT person. Why are people saying that "I always cringe
when I see people use the Environ function to return the user ID given how
easy it is to change".

If it was easy to accomplish in Access 2003 using "=Environ("USERNAME") & "
on " & Environ("COMPUTERNAME")", why was it taken off in Access 2007 without
an alternate way of doing it.

Thanks
Mario





"Duane Hookom" wrote:

These won't work as field defaults in a table design but will work as
defaults for controls in forms. Users should only interact with forms so this
should work.

--
Duane Hookom
Microsoft Access MVP


"Douglas J. Steele" wrote:

http://www.mvps.org/access/api/api0008.htm and
http://www.mvps.org/access/api/api0009.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff Boyce" wrote in message
...
I'm with Douglas on the vulnerability of this approach. Have you looked
into using a call to obtain the NT logon instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"mario" wrote in message
...
This used to work fine in Access 2003 to insert a default value in a
field.
=Environ("USERNAME") & " on " & Environ("COMPUTERNAME")

Can you please let me know what is the equivalent in Access 2007