You could try this,
Rather than using the Return statement ammend it like this:
IF EXISTS ("Your query")
SET @Exists = 1
ELSE
SET @Exists = 0
SELECT @Exists AS 'My Column Name'
Then use a Recordset object in VB to capture back the value returned as column 'My Column...
Hi,
Dont know if this is what you mean but could you not simply use the VB Shell command to run your application.
Something like this:
Shell("C:\MyProgram.exe",vbNormalFocus)
Hope this helps
Davie
Your program should run which ever version of the files is registered on the machine. To do this you can use RegSvr32 from a command prompt.
Hope this helps
Davie
If you make sure that the scripting runtime is selected in the refernces dialog then the only other thing I can see is the wrong spelling of FileSystemObject.
Also you'll prbably need to put in:
Set MyTxt = fs.opentextFile("C:\Test1.txt",forWriting)
or a with block error comes up...
Hi,
I am working on an Inet tool that will fetch relevant data from a login protected web site. So far I have been able to get it to login to the server and navigate to the search page, which seems to work fine (with my standard username and password). But I cant seem to get the parameters for...
Thanks,
The Sleep method, combined with the DoEvents works really well, it now only uses around 5% of the system resources while running. It was the loop waiting for the Timer to fire that was causing the problems.
Cheers again
Davie
Hi,
I have writen a VB App. that loops every so many seconds and retrieves mail from a Pop3 host. To delay the loop I use a Timer object and allow the user to set the delay time.
When the app. is running though it seems to use a large ammount of system resources, particularly processsor time...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.