Solved

Remote Assistance Unsolicited Command Line using VBA in Access 2003

Posted on 2009-04-02
4
650 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

615 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