• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Show how to discover phantom linkage to Report.

I have developed 9 Subreports that are linked to a phantom query.  At one time I must have linked them to the "QFinalScore_LessGrinder_LessHatch" query, but I can find no current attachment or more importantly any place in Access Design asking for this subsequent queries of the Subreports. These queries  work fine.  I only have an issue when I open the Subreports themselves.

I expect this is very easy, but I have been frustrated a day now.

I have attached "SnapShots" and a copy of the database "PSAssm_2013_1120_1425"

Any help will be greatly appreciated.

PS:  I know this database structure is a mess.  I have not had a chance to run an overhaul.

Timothy
SnapShots.pdf
PSAssm-2013-1120-1425.accdb
0
TimothyA
Asked:
TimothyA
  • 4
  • 2
2 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Check the sorting and grouping options.   Usually stuff is hiding in there.

Jim.
0
 
TimothyAAuthor Commented:
Jim,

Thanks

Grouping and Sorting does seem to have been the problem.

However,  I had delete them from srpt02WS, and I have now also removed them from srpt03, and srpt04Pipe.  All of them are still picking that same code.  It is hidden somewhere else.

I look forward to hearing back from you.

Timothy
0
 
PatHartmanCommented:
Try conditional formatting.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
TimothyAAuthor Commented:
Pat,

I do not understand what condition I would place in where.

Sorry, I do not know much.

Timothy
0
 
PatHartmanCommented:
You might have code in a conditional format that refers to a field in the query in question and that is forcing the prompt.  I know of no easy way to look at all the conditional formats but as long as you have isolated the problem to a particular form then you can go through the controls one at a time and open the conditional formatting dialog for that control to see if there is anything there.
0
 
TimothyAAuthor Commented:
Pat,

Thanks!

Microsoft help just came through.  The found a field shrunk and hidden behind the rest of the fields that had the phantom code.  It was in red.  I had over looked it, especially as I did not know what it does there.  It came form an early help suggestion.

Until next time.

Timothy
0
 
TimothyAAuthor Commented:
Good suggestions, but solution came from another help center.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now