VBA and Office 2003

D

Detlef

Hi,

once upon a time a collegue of me write a macro with the following rows:

dlgProgress.Show
dlgProgress.ftText.Caption = "Project running ..."
dlgProgress.Repaint
....
dlgProgress.ftText.Caption = rs.Fields(2) + " in work..."
dlgProgress.Repaint
....

Under Office 2000 this macros runs well but under Office 2003 i gets a
'Object Required' runtime error 424.
I'm not the maco programmer specialist but i think i have to initialize the
dlgProgress. But how.

Hope you can help
Detlef
 
D

Dr. Stephan Kassanke

Detlef said:
Hi,

once upon a time a collegue of me write a macro with the following rows:

dlgProgress.Show
dlgProgress.ftText.Caption = "Project running ..."
dlgProgress.Repaint
...
dlgProgress.ftText.Caption = rs.Fields(2) + " in work..."
dlgProgress.Repaint
...

Under Office 2000 this macros runs well but under Office 2003 i gets a
'Object Required' runtime error 424.
I'm not the maco programmer specialist but i think i have to initialize
the dlgProgress. But how.

Hope you can help
Detlef
Click to expand...

Hi Detlef,

did you rename a user form previously called "dlgProgress"? Check whether
this form exists or not. Where exactly does the error occur?

can you give more information on the procedure? "rs" sound like recordset,
may be this has to be initialized.

cheers,
Stephan
 
Top