AccessObject version Error?

Sully38

Board Regular
Joined
Mar 9, 2004
Messages
167
I am currently working with a database with Access 2002 that is using the following line of code:

Dim accObject As Access.AccessObject

When this code is transported to Access 2000 it fails. Is this code new to 2002? Is there a equivalent in Access 2002 to it?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
I've never used it before but A2K Object Viewer shows this short list of members for Access.AccessObject.

FullName
IsLoaded
Name
Parent
Properties
Type

What is it you want to do with the AccessObject? Might be there's another way to do it.

Mike
 
Upvote 0
I have been giving the honor of taking over a DB that is only 1/2 working with no documentation. If I am reading everything correctly That dim declares ACCObject and then defines all reports to it, so that they can be accessed through a drop-down box. I am just very unfamiliar with Access 2000 as I went from Access 97 to Access 2002. so there may be some functionality I am unaware of.

:oops:
 
Upvote 0
It's a little more limited but this would walk through the Reports Container.
I'm just curious - is the Object Viewer Members list different in A2k vs A2002? Could be a references problem.

Mike

Code:
Function IterateThruReports()
     Dim db As Database
     Dim i As Integer
     
     Set db = CurrentDb()

     For i = 0 To db.Containers("Reports").Documents.Count - 1
          MsgBox db.Containers("Reports").Documents(i).Name
          
     Next i

Set db = Nothing     
End Function
 
Upvote 0

Forum statistics

Threads
1,221,687
Messages
6,161,287
Members
451,695
Latest member
Doug Mize 1024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top