Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / May 2007

Tip: Looking for answers? Try searching our database.

No Record Source, no dependencies?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Phil Smith - 30 May 2007 23:41 GMT
I have a chart.  It may be based on one of several different queries.  I
am not sure which.  I also can not find out which.  If I right click and
choose "Object Dependencies", it says there are none.  If I open it in
design view, and choose properties, the value for "Record Source" is blank.

All of the queries it may be based on rely on criteria pulled from a
dropdown on a form.  If I open it without that form being open, I get a
prompt for the value, if I open the form, the results change as I change
the selected value of the dropdown.  So it is obviously based on something.

I have done a compact/repair.  What the Hell?

Now, I could make a copy of the database, and start deleting queries
until it fails, but that is not the point.

Access 2003 SP2

Phil
Phil Smith - 30 May 2007 23:44 GMT
Sorry, realized this went into Excell charting, not Access...MY apologies.

> I have a chart.  It may be based on one of several different queries.  I
> am not sure which.  I also can not find out which.  If I right click and
[quoted text clipped - 14 lines]
>
> Phil
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.