469,573 Members | 1,667 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

Send text file to logged in users network folder

I want to send a file to each persons home network space. I believe that
when a person logs onto a network, some sort of variable is set that
identifies the user. Is there any code that would allow me to transfer a
text file from Access 2000 for a mailmerge to the person logged in's special
network folder? I don't fully understand this, but I thought someone might
know something about it?

dixie.
Nov 24 '05 #1
4 2295
On Thu, 24 Nov 2005 16:29:49 +1100, "Dixie" <di***@dogmail.com> wrote:
I want to send a file to each persons home network space. I believe that
when a person logs onto a network, some sort of variable is set that
identifies the user. Is there any code that would allow me to transfer a
text file from Access 2000 for a mailmerge to the person logged in's special
network folder? I don't fully understand this, but I thought someone might
know something about it?


Sure. All you need to know is how your network defines the "special
network" folder.

When a user signs on to your Access application, you can find the
network name of that user using the function defined at:

http://www.mvps.org/access/api/api0008.htm

Once you have that, you should be able to cobble together the path of
the "special network" folder into a text string.

That and the OPEN "PATH\FILENAME" for Output as #x command along with
the PRINT #x, xxxx command should fix you right up.

mike
Nov 24 '05 #2
I can get the user's name no trouble, but I have no idea what their network
folder is and how to make a path to it. The network is generally Microsoft
Server2003. Can anyone tell me what your folder would be if you logged onto
such a network?

dixie

"Mike Preston" <mb******@pacbell.net.invalid> wrote in message
news:43*****************@news.INDIVIDUAL.NET...
On Thu, 24 Nov 2005 16:29:49 +1100, "Dixie" <di***@dogmail.com> wrote:
I want to send a file to each persons home network space. I believe that
when a person logs onto a network, some sort of variable is set that
identifies the user. Is there any code that would allow me to transfer a
text file from Access 2000 for a mailmerge to the person logged in's
special
network folder? I don't fully understand this, but I thought someone
might
know something about it?


Sure. All you need to know is how your network defines the "special
network" folder.

When a user signs on to your Access application, you can find the
network name of that user using the function defined at:

http://www.mvps.org/access/api/api0008.htm

Once you have that, you should be able to cobble together the path of
the "special network" folder into a text string.

That and the OPEN "PATH\FILENAME" for Output as #x command along with
the PRINT #x, xxxx command should fix you right up.

mike

Nov 25 '05 #3
On Fri, 25 Nov 2005 12:53:41 +1100, "Dixie" <di***@dogmail.com> wrote:
I can get the user's name no trouble, but I have no idea what their network
folder is and how to make a path to it. The network is generally Microsoft
Server2003. Can anyone tell me what your folder would be if you logged onto
such a network?
There may be a suggested default, but it varies by network. You'll
have to ask the sysadmin.

mike

dixie

"Mike Preston" <mb******@pacbell.net.invalid> wrote in message
news:43*****************@news.INDIVIDUAL.NET...
On Thu, 24 Nov 2005 16:29:49 +1100, "Dixie" <di***@dogmail.com> wrote:
I want to send a file to each persons home network space. I believe that
when a person logs onto a network, some sort of variable is set that
identifies the user. Is there any code that would allow me to transfer a
text file from Access 2000 for a mailmerge to the person logged in's
special
network folder? I don't fully understand this, but I thought someone
might
know something about it?


Sure. All you need to know is how your network defines the "special
network" folder.

When a user signs on to your Access application, you can find the
network name of that user using the function defined at:

http://www.mvps.org/access/api/api0008.htm

Once you have that, you should be able to cobble together the path of
the "special network" folder into a text string.

That and the OPEN "PATH\FILENAME" for Output as #x command along with
the PRINT #x, xxxx command should fix you right up.

mike



Nov 25 '05 #4
You can use Windows API calls to get the special folders,
or you can create a WshShell object and use its SpecialFolders
property:

http://msdn.microsoft.com/library/de...ialfolders.asp

(david)
"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
I want to send a file to each persons home network space. I believe that
when a person logs onto a network, some sort of variable is set that
identifies the user. Is there any code that would allow me to transfer a
text file from Access 2000 for a mailmerge to the person logged in's
special network folder? I don't fully understand this, but I thought
someone might know something about it?

dixie.

Nov 28 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Fran Tirimo | last post: by
8 posts views Thread by Lam | last post: by
1 post views Thread by Yama | last post: by
6 posts views Thread by John Dalberg | last post: by
4 posts views Thread by Salad | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.