Solved

Remote Assistance Unsolicited Command Line using VBA in Access 2003

Posted on 2009-04-02
4
639 Views
Last Modified: 2012-05-06
I created an asset database that contains the NETNAMES of all workstations in my office.  All workstations are enabled to accept Unsolicited Remote Assistance through: hcp://CN=Microsoft%20Corporation,L=Redmond,S=Washington,C=US/Remote%20Assistance/Escalation/Unsolicited/Unsolicitedrcui.htm

On my database I would like to create a command button that once clicked, it opens: hcp://CN=Microsoft%20Corporation,L=Redmond,S=Washington,C=US/Remote%20Assistance/Escalation/Unsolicited/Unsolicitedrcui.htm

Then grabs the netname of the PC from the textbox, and allow me to provide remote assistance.
Is this possible?
0
Comment
Question by:Alex219267
  • 2
4 Comments
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24059282
read this link in its ehtirety... it has java and asp solutions for what are requesting.

                     http://www.joatit.com/wordpress/?p=53
0
 

Author Comment

by:Alex219267
ID: 24074432
"hcp://CN=Microsoft%20Corporation,L=Redmond,S=Washington,C=US/Remote%20Assistance/Escalation/Unsolicited/Unsolicitedrcui.htm"

OKay I made a change to the UNSOLICITEDRCUI.HTM FILE and added this :

<script LANGUAGE="VBscript">
sub Window_Onload()
      on error resume next
      set fso = CreateObject("Scripting.FileSystemObject")
      if fso.fileexists("D:\temp\wsra.txt") then
            set objFile = fso.OpenTextFile("D:\temp\wsra.txt", 1)
            idComputerName.value = objFile.Readline
            objFile.Close
      end if
end sub
</script>

On my access application, my click event will send the PC netname from an object text box, to a txt file on D: temp of my computer.  
NOW??? How can I continue to code in VBA to open this altered unsolicited.htm file???

Can someone please explain what this: "hcp://CN=Microsoft%20Corporation,L=Redmond,S=Washington,C=US/Remote%20Assistance/Escalation/Unsolicited/Unsolicitedrcui.htm"

DOES in detail??? WHat is HCP ??? what is CN=Microsoft%20Corporation,L=Redmond,S=Washington,C=US ???

0
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 total points
ID: 24101808
Alex,
Just got back to the office.  I guess you did not see the two asp solutions that were contained in responses from Sir Tom (February 29th, 2008 at 7:58 am) and Corwin (March 14th, 2008 at 7:44 ).  Both solutions involved creating a form_load procedure for the Microsoft Remote Assistance Tool. The  load procedure will supply all the parameters required to automate Remote Assistance when the connection is made.

Sir Tom's solution is shown below.  If it does not work for you, then try Corwin's solution.  

 in his post on , Sir Tom said..   I was playing with code some more and found way to pass the Machine or IP and then automatically start the remote session and thought I would post it, in case anyone would like to use it.

function onLoad()
{
;
;
try
{

//idComputerName.value = hnlf8913
setTimeout(idComputerName.focus(),250);
g_oSAFRemoteDesktopConnection = oSAFClassFactory.CreateObject_RemoteDesktopConnection();
if (window.location.search.substring(1)!= )
{
idComputerName.value = window.location.search.substring(1); // load the Machine Name
document.getElementById(btnConnect).click(); // clicks the connect button
document.getElementById(btnStart).click(); // clicks the Start Remote Assistance button
}
}
catch(error)
{
FatalError( L_RCCTL_Text, error );
}
;
return;
}

Now when you send
%windir%\PCHEALTH\HELPCTR\Binaries\HelpCtr.exe -url hcp://CN=Microsoft%20Corporation,L=Redmond,S=Washington,C=US/Remote%20Assistance/Escalation/Unsolicited/UnsolicitedRCui.htm?SomeMachineName

it automatically starts the remote session.

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question