Using another Timer (other than Access) and Multi Threading

darbid

Registered User.
Local time
Today, 02:57
Joined
Jun 26, 2008
Messages
1,428
Following on from my experience here (I believe that java is not the problem) http://www.access-programmers.co.uk/forums/showthread.php?t=174588 which is not relevant for this question, but is the reason why I am asking it.

If from a routine I click on an "open file" button in InternetExplorer which opens the windows dialog to choose a file then this routine is frozen.

My computer is not frozen though.

I tried the MSAccess form Timer eg

set timerinterval
click

The timer does not start till the dialog is closed.

I then tried what I believe is the Windows API "SetTimer" but once again the Timer does not kick in till the dialog is closed.
Code:
Public Declare Function SetTimer Lib "user32.dll" (ByVal hWnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long
Is there any other method I can try? It appears (irrespective of whether my InternetExplorer is the Webbrowser control on a form in Access or I use the IE.application, as soon as an application calls a click, that application is totally frozen.

Is the reason why I cannot get any further that MSAccess does not multi thread. For example if I was on VB6 and called the click then the API timer would run on another thread.
 
Ok I cannot answer my question about whether it is a threading issue but I have got to control the windows dialog.

I set up two MDBs.

MDB1 - calls a function in MDB2 to set the Timer in MDB2.
MDB1 - clicks the button in Internet Explorer thus bringing up the open file window dialog and freezing MDB1.
MDB2 - the timer kicks in - finds the dialog, enters the path in the text and clicks ok.
MDB1 can then continue on its way.

Even a dumb beginner with a few hours googling can get around windows security.

I cannot have two MDBs, but at least I now know it is possible so I suppose it is back to my original suggestion in the other thread, MDB2 will have to be a .dll. Now I just gotta learn about them.
 

Users who are viewing this thread

Back
Top Bottom