Where did this report come from?

[JJBaseball]

Hello,

I'm not that familiar with Access and I'm looking at the previous
developer's database. The is a form/switchboard that has a button that when
clicked generated a report of mismatches between two tables. I found the
name of the report but I can't figure out how it is getting generated. I ran
a relationships check on the report name and it only returned one query...a
matching query. I don't see any reference to this report which seems to
basically be an error report from this "matching" query. How is this report
getting generated? Is it possible that when the excel file got imported into
the the access database, the matched and unmatched reports got generated? I
was thinking it gets generated on the fly when the "mismatched" report button
is pressed. Any help would be appreciated.

 

[JJBaseball]

Hello,

I'm not that familiar with Access and I'm looking at the previous
developer's database. The is a form/switchboard that has a button that when
clicked generated a report of mismatches between two tables. I found the
name of the report but I can't figure out how it is getting generated. I ran
a relationships check on the report name and it only returned one query...a
matching query. I don't see any reference to this report which seems to
basically be an error report from this "matching" query. How is this report
getting generated? Any help would be appreciated.

 

[John Spencer]

It depends.

The report could have a record source that is not a saved query. So you need
to check (in design view) the report's record source.

If you are pressing a button on a switchboard, it is executing some VBA code
(or a macro). You could try tracking that down.

If you open the report from the report's page of the application, does it run
and give you expected data?



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County