Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Remote Assistance Unsolicited Command Line using VBA in Access 2003

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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

730 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