How do I get the current User's path to Desktop

[Christer]

I need to find out the current user's path to his/her Desktop and use it
within an Access module. Is this possible? We use Windows Vista and Office
2007.

I hope sombody can give me a hint.

 

[Stefan Hoffmann]

hi Christer,

I need to find out the current user's path to his/her Desktop and use it
within an Access module. Is this possible? We use Windows Vista and Office
2007.

Use either the special folders api

http://msdn.microsoft.com/en-us/library/aa140088(office.10).aspx

or

Environ("%DESKTOP%")

Caveat: The environment approach can be easily redirected to any folder
by the user.


mfG
--> stefan <--

 

[Daniel Pineault]

The following link should be what you are looking for.

http://www.mvps.org/access/api/api0054.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.