Solved

MS Access 2010 - Chart Visibility

Posted on 2016-09-15
5
24 Views
Last Modified: 2016-10-30
Is there a way to make a chart non-visible if there is no data in the chart? I pose the same question for a subform, if there is no data in the detail section of a subform can the whole subform be made non-visible?
0
Comment
Question by:Elemental Drake
5 Comments
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 250 total points
ID: 41801015
is that Chart linked to a data source?

is that possible we check that same query, if that query returns 0 record, we hide the Chart accordingly?

we may need to do this in Form_Load or Form_Current event.
0
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 250 total points
ID: 41801722
You can make a section visible or invisible depending on some evaluation -- here is an example:

Private Sub Form_Current()

   If Val(Me![OrderID]) > 100 Then
      Me.Section(acFooter).Visible = False
   Else
      Me.Section(acFooter).Visible = True
   End If
   
End Sub

Open in new window

0
 

Author Comment

by:Elemental Drake
ID: 41801747
This would probably work as a last resort. I would like to have the textbox that labels the sections to appear. This way it will still relay the message that this person was accounted for but there is no data associated with them.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 41801756
Could you position the textbox at the bottom of the Detail section, so it would appear even if the section is invisible?
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 41865715
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- Ryan Chong (https:#a41801015)
-- Helen_Feddema (https:#a41801722)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question