Code

Re: Getting corrent user

Skarn — Sat, 17 Jul 2010 13:40:29 GMT

I had similar problems in my workplace - the Network object would not be created (permission denied when I debugged) but Infopath reports no error when the form was opened - just an empty field.

I have 2 solutions I used - get user to enter their login name into a field - then use the 'IsCurrentUser' function of Infopath to validate that what they put in really is their user name - don't forget to put the domain name for your workplace at the beginning for the 'IsCurrentUser' function.

The other way was I had an SQL server with a 'view/stored procedure' which had only the 'SUSER' variable as a value. By referencing this view as a secondary datasource and retrieving the values when the form opens - I immediately make the current username available to the form in the secondary datasource field. If you have an SQL database you can use in this way - I think this is the nicest method.

Re: Getting corrent user

Sara Campo — Wed, 26 May 2010 12:31:14 GMT

Not working, the field is empty.

Re: Getting corrent user

Jimmy — Wed, 26 May 2010 12:04:04 GMT

Is your code producing any particular error, or just not working?

Re: Getting corrent user

Sara Campo — Wed, 26 May 2010 11:01:36 GMT

I using Infopath 2003.

Re: Getting corrent user

Jimmy — Wed, 26 May 2010 10:47:34 GMT

Why not use InfoPath's userName() function?

Getting corrent user

Sara Campo — Wed, 26 May 2010 10:12:12 GMT

I have a big trouble. I need to get the username but i can't create an activexobject. the code that i'm using is:

Sub XDocument_OnLoad(eventObj)

Dim wsh

Dim un

wsh = CreateObject("WScript.Network")

un = wsh.UserName

XDocument.UI.Alert(un)

XDocument.DOM.selectSingleNode("//my:campiPersonali/my:user").text = un

end sub

Any sugestion?