B
bijan
Hi All
I have a procedure that connect to a database and gets data in a several
steps .and it is necessary to show the name of each steps to user( in
label1.capation) in a user form,It works fast and user just can see the last
step name , how can I control the showing of them in two or more seconds?
My procedure like this:
dim SQL1 as string
dim SQL2 as string
connection string .....
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
STEP ONE
label1.caption="STEP ONE"
SQL1=(my sql statment is here)
:
:
Range("A5").CopyFromRecordset rs
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
STEP TWO
label1.caption="STEP TWO"
SQL2=(my sql statment is here)
:
:
Range("A10").CopyFromRecordset rs
:
:
rs.Close
conn.Close
Thanks in advanced
I have a procedure that connect to a database and gets data in a several
steps .and it is necessary to show the name of each steps to user( in
label1.capation) in a user form,It works fast and user just can see the last
step name , how can I control the showing of them in two or more seconds?
My procedure like this:
dim SQL1 as string
dim SQL2 as string
connection string .....
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
STEP ONE
label1.caption="STEP ONE"
SQL1=(my sql statment is here)
:
:
Range("A5").CopyFromRecordset rs
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
STEP TWO
label1.caption="STEP TWO"
SQL2=(my sql statment is here)
:
:
Range("A10").CopyFromRecordset rs
:
:
rs.Close
conn.Close
Thanks in advanced