Hi there,

Let me be more specific this time. 
And Marcelo - I m xtremely sorry, i did not read ur initail fw 
lines.Unknowingly i wrote u a mail at ur office id. Extremely sorry for 
that. But i wud really appreciate if u cud take a look at this...
 
I have done exactly the way you told me, however its giving me an 
Automation error. Even the following statements (declarations) give me an 
automation error, is driving me crazy.
   
Private Sub OnClickUpdateOrder() 
 
Dim rsOrders As RecordSet
Dim rsUpdateInfo As RecordsSet
 
End Sub
 
When I click on the update button it gives me an Automation error, 
and highlights the first Dim statement. So its pointing out to the 
first Dim Statement. I tried to find info about Automation error on
Google but no much help.
 
I thought that it would be a  better idea to let you know.
 
I would really appreciate your help.
Thank you
Viv

Have you switched on either DAO or ADO under Tools- References?

johnb

In the VB editor, select the Tools..References menu item, it will display
the project references.  Make sure that DAO (or ADO if that's what you are
using) is selected.

An Automation error is raised when the application cannot find an ActiveX
class it thinks it needs.


-----Original Message-----
From: Vivin Deshpande [mailto:vdeshpande@m...]
Sent: Thursday, August 29, 2002 9:35 AM
To: Access
Subject: [access] Automation Error - 2


Hi there,

Let me be more specific this time. 
And Marcelo - I m xtremely sorry, i did not read ur initail fw 
lines.Unknowingly i wrote u a mail at ur office id. Extremely sorry for 
that. But i wud really appreciate if u cud take a look at this...
 
I have done exactly the way you told me, however its giving me an 
Automation error. Even the following statements (declarations) give me an 
automation error, is driving me crazy.
   
Private Sub OnClickUpdateOrder() 
 
Dim rsOrders As RecordSet
Dim rsUpdateInfo As RecordsSet
 
End Sub
 
When I click on the update button it gives me an Automation error, 
and highlights the first Dim statement. So its pointing out to the 
first Dim Statement. I tried to find info about Automation error on
Google but no much help.
 
I thought that it would be a  better idea to let you know.
 
I would really appreciate your help.
Thank you
Viv