I am assuming that you mean the windows login name. There is a system variable for this. Do a search in the VBA help (may be an API function - I am not on my computer with Access at the moment).
Hope this helps! Richard --- In [email protected], "jsivanan" <[EMAIL PROTECTED]> wrote: > Hi! > I need the current user id to determine the pathname of "My Documents". > Anybody know how to extract it from the system while in Access VB? > Specifying "C:\My Documents\filename" didn't generate an error, but > the file couldn't be found. > > Just leaving out "C:\My Documents" works sometimes because it > defaults, but several times it went to the desktop!!! > > Thanks in advance for your help. > > Jnana ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
