Search results for query: *

Heh .. How can I credit myself for my own answer!? [tongue]

Found the solution @ http://msdn.microsoft.com/en-us/library/office/ff197396.aspx

Sorry man .. I'm no help with this. Typically any time I'm working with a SP, I already know what I'm looking for and can check the table in the database that's get'n updated to ensure that the SP worked. Might try this site: http://www.sqlteam.com/article/stored-procedures-returning-data

In the Scheduled Task window, in the "Start in:" text box, did you specify "cscript /nologo" ?? Dim objNetwork Set objNetwork = WScript.CreateObject("WScript.Network") strLocalDrive = "K:" strRemoteShare = "\\myServer\Map\Vol1" objNetwork.MapNetworkDrive strLocalDrive, strRemoteShare, False I...

myVar = cmdObj.Execute Msgbox = myVar

In the "InputBox Option:" .. The "Next" verbiage should be deleted. I failed to delete it prior to clicking "Submit Post". My apologies.

If it's a static list of machines, then creating an array would work. If the list of machines is dynamic (different all the time) then you're going to have to use an inputbox which will require manual interaction. Array Option: On Error Resume Next Dim arrComputers(2) arrComputers(0) =...

In the stored procedure, why not spool to a log file? Then read from the log file?

I'm attempting to add an attachment to a MS Access 2010 database via VBScript. But, I do not know the proper syntax for the command, nor can I find it. .vbs file name: ms.vbs stored on C:from DOS: cscript /nologo C:\ms.vbs Problem Line: nRS.Fields("Attachments").Value = "C:\ms.txt" What is...