Userform 'not responding' while waiting for SQL query with ODBC

[zeee1980]

I know the DoEvents function but I think its not solved my probelm in this case.

I started an SQL query with ODBC connection in a Userform. While the excel wait for the database results until then the Userform is going to "not responding" mode.
How can I get back the control on Userform while the SQL query is running and waiting for the results?

ODBC connection:

Please Login or Register  to view this content.

Here is the command when the Userform go to "not responging" mode. The excel wait for the SQL database about 30 seconds.

Please Login or Register  to view this content.

After that the excel gets the SQL results and the Userform is active again and i have no problem. I can list the results with DoEvents etc.

Can you help me?
Sorry for my english.

[Izandol]

You require asynchronous connection:

Please Login or Register  to view this content.

[zeee1980]

Okay, thank you its working but its create a new question:
How can I know when finished the SQL query? Because the excel is running over and at the next command line (RC = SQL.RecordCount) I have an error message (I have that in hungary I tried to translate): "Run-time error: 3704 - The operation is not allowed if the object is closed". I wait about 30 seconds and then I click Debug button at this error message, press F5 to continue the macro running and works everything good.

[Izandol]

You may use events. Change the declaration of SQL to the top of your code module like so:

Please Login or Register  to view this content.

and then you must move all of your code from after the SQL.Open line into an event:

Please Login or Register  to view this content.

[zeee1980]

Thank you, I understand this method. I did it but the event is not working.
I can read datas from the receordset in watch view but the "Private Sub SQL_FetchComplete" event is not working/starting.

It is interesting because in an other sub I do the list of recordset with manual start and the "Private Sub SQL_RecordsetChangeComplete" event is working. The SQLDB_ConnectComplete event also working. But the FetchComplete or FetchProgress not.

Why?

[Izandol]

There are some requirements you must adhere to - they are given in this Microsoft article: http://support.microsoft.com/kb/262311

[zeee1980]

Problem solved with:

Please Login or Register  to view this content.

Thanks a lot.