Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Remote Assistance Unsolicited Command Line using VBA in Access 2003

Posted on 2009-04-02
4
Medium Priority
?
659 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
3 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 2000 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

824 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