Search results

Yes. Double clicking only opens a property sheet. The menu that you shared is not available in my version.

I will give it a try. Thanks

Hello. Thanks for your help, but my version is different. It might be 2016 or 365, not sure and do not know how to check it.

Good morning, 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...

Yes. Steps 2 and 3 are my current process.

Good morning, 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...

Hello, 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...

Perfect. Thank you very very much for your help!!!!

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...

I will also prepare an access file to upload here. Thanks

It shows MSGraph.Chart.8 Thanks

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 .ApplyDatalabels 2 And if I comment that line then the error moves to the next one With .Axes (2) Thanks

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.

Thanks for your reply. What would be the line code in Access? I am looking at the Chart and ChartAxis classes and do not see where to do it. THanks

Hello, In Excel it is possible to adjust the min/max Y-axis values using code. Can this be done in Access? I have included an example where due to the Y-values starting from 0, it is hard to appreciate the differences. I can manually adjust the minimum, but this is a chart template that gets...

Thank you for your help. It did not occur to me to write it like I posted it. I was trying something like, StrIDLocator = application.function("FORMAT(me.Number,"0000") It works now. Perfect!

Hello. My code reads a number from a table and needs to be converted to string. In Excel's VBA you can use application.worksheetFunction to trigger any Excel Formula, but I cannot find that same type of code in Access. My line would look somethin like this, StrIDLocator = FORMAT(me.Number...