Solved

MS Access 2010 - Chart Visibility

Posted on 2016-09-15
5
33 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 51

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

762 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