Solved

Remote Assistance Unsolicited Command Line using VBA in Access 2003

Posted on 2009-04-02
4
633 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

832 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