heh, well we're walking into API territory now... You're far more knowledgable here... (I tend to employ the use of machette's here ;-)) I've only really seen WaitForSingleObjectEx used to launch an app and stop processing until the called app closes. Now I've done some more research, I see that...
hmmm, but the OP wants the individual words in their own strings. May I make suggestion based on macropod's function?
(it's basically the same thing, but goes on to Split the returned string into a string array.)
Sub TrimString()
Dim MyString As String
Dim strOutput() As String
Dim...
Thanks:-)
heh, but both solutions are new apps...;) I was simply suggesting that (unless the master.exe is doing something fancy as well are firing the "sub-apps") it would be less expensive to use the API.
Yeah, in which case no solution will be truely elegant anyway! :-D
Reconcidering...
strongm,
After reading back my last post, I realise I could have worded it better, it was not meant to sound the way it reads!! You've helped me out far too many times for me to critise you - I hadn't read the OP closely enough and jumped in both feet first (as usual... ;-)).
I'd suggest the...
...Private Sub Form_Load()
Set appXL = New Excel.Application
Dim MyFile, MyPath, strWorkbook
strWorkbook = Dir(strPath & "*.xls")
Do While strWorkbook <> "" ' Start the loop.
' Ignore the current directory and the encompassing directory.
If strWorkbook <> "." And...
Nope, use the sleep API. It wont chew your processor...
(Praise to the KPD Team)
'This project needs a button
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Private Sub Command1_Click()
'KPD-Team 1998
'URL: http://www.allapi.net/
'E-Mail: KPDTeam@Allapi.net...
Well, I can't understand that. Is your app having to do something else before login?
Surely it would be easier to launch "normally" at startup and grab the username then rather than polling the system...
Anyway, see if the snippet below helps. KPD Team rocks...
Private Enum...
Well, talk about learning something new every day! That page could have saved me AGES of mucking about a couple of years ago! However, I'm confused. Surely all the information you need is on that link? When you say "programatically hiding the app" ... from what? The Services List? Processes...
Then I think you're going have to learn C/C++ or a variant. AFAIK, the VB compiler can not compile service executables.
I'd be glad to be proved wrong though.
Gotta love allapi.net!
The code snip below is pretty self-explainatory, however, I'd to some research into Services before implementing it. It works differently depending on the flavour of Windows you're running. Also, from a VB point of view, I believe you can't actually comiple and run a...
Well, I think your next option is going to be use Ethereal to analysis what's going on at the network level. Also, comment out the line:
On Error GoTo err_Inet1_StateChanged
When the error occurs, it'll dump you into the code and you'll be able to try to find out what is/isn't happening.
This sounds like a configuration problem. Access 2000 comes up my connect drop-down.
Do you have Access 2000 or later and the latest version of MDAC installed on you're devopment machine?
Change the error checking section to this:
err_Inet1_StateChanged:
Dim nextAction As Long
Debug.Print StrConv(Buffer, vbUnicode)
nextAction = MsgBox("Oh dear, an error occured. It was reported as '" & Err.Description & "'. What would you like to do?", 18)
If nextAction = 3 Then...
Ok, replace your code with that listed below. I've added some quick and dirty error checking. Let's see if we can't find the source of the problem.
Option Explicit
Private Sub Form_Load()
'initialize and stage controls
ScaleMode = vbPixels
Text1.Move 5, 115, 300, 20
Text2.Move...
Certain firewalls can block indivual applications. That was the reason for the question.
Just tried it twice in quick succession, the second attempt threw up an error "Unable to complete request". The is usually caused on the Server side. Give me a moment to add some error checking to your code...
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.