how do I print a list of available reports in Access 2007?

  • Thread starter Thread starter Norwalker
  • Start date Start date
N

Norwalker

There are many reports available in my ACCESS 2007 database, but all i need
is a listing of them. how do i do that?
 
Tools - Documentor - Analyze - Select all reports - Select your desired
option, click ok, ok. On tool bar select Word (2007) or Analyze with Word
(Older Access).

Then open the .rtf file it produces.
 
An easy way to do that is with the Access system objects.

The attached query will provide a list of reports in the MDB.

SELECT Name, Type
FROM MSysObjects
WHERE (((Name) Not Like "*~*") AND ((Type)=-32764))
ORDER BY Name;

In MSysObjects table (a system level table that you do not create and which
is normally not visible or shown) the name of each object is stored in the
name field. The type of an object is stored in the Type field and Type
f -32764 means that object is a report.

You can do the same kind of query for all system objects (tables, queries,
modules, etc.)

Regards

Kevin
 
An easy way to do that is with theAccesssystemobjects.

The attached query will provide alistof reports in the MDB.

SELECT Name, Type
FROM MSysObjects
WHERE (((Name) Not Like "*~*") AND ((Type)=-32764))
ORDER BY Name;

In MSysObjects table (a system level table that you do not create and which
is normally not visible or shown) the name of each object is stored in the
name field.  The type of an object is stored in the Type field and Type
f  -32764  means that object is a report.

You can do the same kind of query for all systemobjects(tables, queries,
modules, etc.)

Regards

Kevin






- Show quoted text -
Click to expand...

This query worked like a charm but a strange problem keeps coming up
with a table that I created for my objects. I am using 2007 but
saving in 02-03 format and I had originally created a table called
tblObjects with the following fields:

ID - AutoNumber
ObjectName - Text

I manually typed in each object name, b4 reading this post, and
everything was working fine. One place I was using this table was as
a record source in a comboBox on my main menu. I had it set to only
show forms and used this to navigate to my forms. I than decided to
add another field to my table called UserFriendlyName and I used an
update query to update the field with the object names w/0 the prefix
of frm, rpt ect. However, when I tried to open the table by double
clicking access crashed. I could get to the data from a form I
created or from going into design mode and then viewing the datasheet
but everytime I doubled clicked on the table access crashed.

I then tried creating a new table through a make table query with the
same results. Next I manually re-created table and used an update
query with the same results. Next I created a New Database and
imported all the objects but again was unable to open the table by
double-clicking. Next, I again recreated the table and manually typed
in the object names and again same results. Lastly, I used the above
query and then created a make table and again same results.

All I can think is that there is some reserved word that I am using in
my object name that is causing the crash. I copied the database over
to a box with Access 2003 installed and the table is working fine.
Has anyone else encountered this type of problem?
 
Back
Top