Search results

Having just had a quick play, this is because the underlying data source field is set as a String data type which is why you see the lexical ordering. Do you really need the K prefix on each value? If not then using a numeric data type will automatically resolve the problem. I've seen this...

Firstly I want to express that I am certainly not an authority on Microsoft Access, VBA or the Web Components library which have all caused me numerous headaches in the past (I am just self taught like many others here). However I have been playing with Pivot Charts recently and maybe able to...

Hi, I'm new to the forum and have recently posted my first question which I've managed to answer by myself and posted the solution for others (which I hope will be of some use). I too was looking for the option to update the status to [SOLVED] as editing the first posting title didn't work. This...

[SOLVED] PivotChart form adding new series with VBA As promised a working sample as I've finally got my SubForm PivotChart to work as required. Points to note.... - This works on Access 2003, it may work on other versions but I'm unable to test. - Uses OWC10 Web Components library reference...

[SOLVED] PivotChart form adding new series with VBA I've finally found the answer to my problem... Dim p As PivotTable Dim pv As PivotView 'Assign PivotView to variable pv Set pv = c.Charts(0).Axes(0).CategoryLabels.PivotAxis.GroupFields(0).Axis.Data.View 'Insert the new...

[SOLVED] PivotChart form adding new series with VBA I had hoped that my first post would be a solution on how to utilise the OWC10 chartspace component but I've run into problems that I'm seemingly unable to resolve. I've exhaust all the web resources I can find and overcome many problems...

My name is Alan but I go by the username RandomCoder as I feel this is particularly apt for me. My day-to-day duties generally involve programming PLCs using ladder-logic and statement list, I have experience with Allen Bradley, Siemens and Mitsubishi. We also have many machines running on a...