Help with, Modifying Output Directory/ Path in Access (1 Viewer)

mblack76

Registered User.
Local time
Today, 00:06
Joined
Dec 26, 2005
Messages
13
Hello All,
I am new to vb and just trying to build a database for work. The db works ok however I am trying to modify the output location since its on a network.

The current db report output locations is...
"C:\Documents and Settings\a124567z\Desktop\ContactInfo.rtf"
with "a124567z" being the user's login or network ID.

Is there a way I can use vb to make the db report output location to automatically change according to the login id without doing it manually on all the computers?

For example if user "b444555y"
tries to export the data, the location shoyuld now be...
"C:\Documents and Settings\b444555y\Desktop\ContactInfo.rtf".

I hope I explained myself well.
Thank you in advance
 

ghudson

Registered User.
Local time
Today, 03:06
Joined
Jun 8, 2002
Messages
6,195
Searching the forum is a great way to discover and learn the answers to your Access programming questions. Although you have posted your question in the Visual Basic section of the forum.

I have previously posted the answer you seek in this thread...
http://www.access-programmers.co.uk/forums/showthread.php?t=86888&page=2

Code:
"C:\Documents and Settings\" & Environ("UserName") & "\Desktop\ContactInfo.rtf"
 

Users who are viewing this thread

Top Bottom