I want to display my primary axis (Y-axis) values as xxxk (2k for example). But the chart's Property Sheet drop down menu does not allow custom formatting. It only limits choices to a handful of Access formats.
Is there a way to insert custom formatting numbers in Access...
I appreciate all your feedback even though I do not understand most of them. My organization would grant any permission to save the values I am using into a permanent table. And the only reason I am uploading my values into a #tmpTable is to prevent my Access database from...
I will try to do my best explaining this error, please be patient with me.
I have a VBA code that loads values from an Access table into a temporary T-SQL table. The purpose is to do the required math using the server's processor. The logic works perfect if I debug.print the SQL...
Thank you for your help. I just have one more request. In my first sample the code will work if it reads from a table. What if the modern chart works from a query? I missed to include that detail in my first sample file. My database fills the charts using a query instead of a table for space...
So, I built this sample file at work where they use Office 365 and the code worked. However, when I open the same file at home using Office 2016 it does not work.
In office 2016 I get an error saying: a problem occurred while Mocrosoft Access was communicating with the OLE server or ActiveX...
Sorry to bother you again but it seems I need to add a library for the code to work.
I get a Automarion error, Library not registered and the line is
And if I comment that line then the error moves to the next one
With .Axes (2)
I finally got to test the code today and received an error.
I get a "Method or data member not found" in line
With Me.Chart8 <-----That is my chart's name
I will keep testing it over the weekend. Thanks for your help.