Change Network user name to Noted DB name (Len, Trim and such)

[skipit]

Morning all,

I am having some trouble grasping the idea behind Len, Trim and such (I think this is what I need to use).

What I need to do is change the network login name into the db name for a Lotus Notes db. Here is the format of each:

Network Login (I pull this into my DB and save as a variable and in a hidden txtbox):

aslayj

I need to change the above to (this would be the Lotus Notes DB name):

jslayt01.nsf

Any help will be very welcome.

Thanks and have a great day,
Skip

 

[WayneRyan]

skipit,

Dim strOldName As String
Dim strNewName As String

strOldName = "aslayj"
strNewName = Right(strOldName, 1) &  Mid(strOldName, 2, Len(strOldName) - 2) & "01.nsf"

Wayne

 

[skipit]

Wayne,

Thanks for the help. I will try it out and post back if I have any other questions. Is there any reading besides the help files that talk about these actions?

Once again thanks and have a great day!!!

Skip

 

[WayneRyan]

skipit,

Just look at sample databases and use the Search Facility here. These
are pretty common topics.

Wayne