Hi guys

I have an Oracle stored procedure that I invoke from VB from a form. I run this asynchronously so that I can continue working with other forms etc while the procedure is executing. The procedure writes it's progress to a table as intervals.

I want to be able to execute some SQL in VB to retrieve the progress from this table at regular time intervals so that I can use this to display a ProgressBar in VB to let the user know how far the procedure has executed.

I call this Oracle procedure in UserForm_Initialize of a little form that displays the progressbar. Once the UserForm_Initalize function has been executed, the form shows the progressbar. It is at this stage that I need to invoke the timer and therefore call some VB function to retrieve the progress from the table.

Has anyone done this before or does anyone know how to execute a VB function at regular timed intervals?

Many thanks in advance for any help you can provide

Cheers

Ciaran

can you just add a Timer control in your little form and use the Timer event?

Marco

Hi Marco

I don't seem to be able to find the timer control. I'm using VBA rather than VB.

Do you know where I can find this control?

Many thanks

Ciaran

Another option is to open a withevents recordset asynchronously and use the FetchProgress event for your progress bar. See http://support.microsoft.com/default.aspx?kbid=262311 for an example.

hth
Phil

There problem is because I'm calling an Oracle procedure, I am using Conn.Execute command that is basically calling the procedure. I'm not retrieving anything using a recordset.

The procedure is updating a value in the database so this is what I need to query at regular time intervals so that I can publish the value in the progressbar.

Is there another way around this?
I would have thought that there is an timer control that you can reference in your VBA project.


Cheers

Ciaran

I'm not much of a VBA user myself. The only thing I've seen is Word and Excel application objects have an OnTime event, but apart from that I'm clueless

This is a possible solution for you (not the first to ask this question...)

http://www.vbdesign.net/activecad/how_to/modeless.html

Marco