Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 OLE Object

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-29 : 09:35:20
AG writes "Problem #1
I have tbl's and qry's that are on SQL server. The forms and reports
are in Access Projects. The forms and reports work when it was in a
.mdb file. I use the upsize wizard to transfer the tbl's and qry's to
SQL server and frm's and qry's to Access Projects. Now, some of the
command buttons on the form works. When I click on some of the
command buttons, a message comes up, and it states, "There was a
problem accessing a property or OLE method of OLE Object."
What does that mean, and How do I resolve it? Do I need to use ADO
instead of Access given application such as the DoCmd?

The command buttons that are the problem are "Add New Client" and
"Edit Client Record." I use the Do Commands to open and edit
the record. When a user clicks on those buttons, a form is
opened, and it has sub forms. When I click on "View Client Record,"
the same form works fine."
   

- Advertisement -