I have an Access report that has a bar chart object on it. I would like to programatically change the horizontal axis based on some date values from a table. Also the horizontal axis is numeric rather than time value - can this be changed to time value programatically so it can display full months?
Here is the code that doesn't work:
Private Sub Report_Open(Cancel As Integer)
Dim graphObj As Object
Set graphObj = Me!Graph0
graphObj.Axes(2).MinimumScale = 10000
The error message is:
Runtime error '438'
Object doesn't support this property or method
If I put this code in the graph object On_click event the axis scale changes but I don't want to have to click the graph to make it work properly especially since the report has 4 overlapping graphs.
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
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…
Familiarize people with the process of utilizing SQL Server views 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 Access…