Environ State or City?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dogpigfish - 28 Jun 2007 16:20 GMT

Is there anyway to use the environ function to get the City or State? If
not, does anyone have a recommendation? Thanks in advance.

Reply to this Message

Douglas J. Steele - 28 Jun 2007 16:27 GMT

The Environ function is intended to return the string associated with an
operating system environment variable. If you go to a DOS box,type Set and
hit Enter, you'll see a list of all of the variables currently defined. If
the City or State value you want is in that list, within Access you can use
Environ("NameOfVariable") to retrieve its current value.

If that's not what you're looking for, you'll need to provide more
information about what you're trying to do.

Signature

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

> Is there anyway to use the environ function to get the City or State? If
> not, does anyone have a recommendation? Thanks in advance.

Reply to this Message

John W. Vinson - 28 Jun 2007 20:51 GMT

>Is there anyway to use the environ function to get the City or State? If
>not, does anyone have a recommendation? Thanks in advance.

Probably not. How would a laptop computer (say) know where it happened to be
located at the moment? For that matter, when I've installed Windows, I don't
recall ever being asked for that information as a Windows value (only for
transmittal to vendors for registering software).

What's the context? What are you trying to accomplish?

John W. Vinson [MVP]

Reply to this Message

missinglinq - 29 Jun 2007 01:44 GMT

Could I use the environ function to find my glasses? I'm sure they're
somewhere here in the environment!

>>Is there anyway to use the environ function to get the City or State? If
>>not, does anyone have a recommendation? Thanks in advance.
[quoted text clipped - 7 lines]
>
> John W. Vinson [MVP]

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message

John W. Vinson - 29 Jun 2007 17:22 GMT

>Could I use the environ function to find my glasses? I'm sure they're
>somewhere here in the environment!

<chuckle>

I solved that problem by going to my nearby Honk's Only $1.05 Store (inflation
has struck) and bought eight 2-diopter reading glasses. They're all over the
house.

John W. Vinson [MVP]

Reply to this Message

missinglinq - 30 Jun 2007 04:07 GMT

Actually, I do too! One pair in each room plus a pair in the car!

>>Could I use the environ function to find my glasses? I'm sure they're
>>somewhere here in the environment!
[quoted text clipped - 6 lines]
>
> John W. Vinson [MVP]

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message