Pivotchart - Right click problem

[systemx]

Hi all,

My database has right click disabled (for obvious reasons).

I have added a new form which contains a pivotchart. The intention is for the user to be able to build custom charts.

Because the right-click is disabled (I assume) - the user is unable to access the 'Field Properties' box to drag and drop various headings from my query.

Does anyone know how I can either -

1. Make the 'Field Properties' box visible when the form opens
2. Temporarily enable the right click, but now enable to user to select 'Design View'?

Thanks,

Rob

 

[systemx]

Hi all,

I am now enabling these commandbars (not sure if it is one or all that needs to be enabled at this stage).

CommandBars("Function Pivot Table Popup").Enabled = True
CommandBars("Function Pivot Chart Popup").Enabled = True
CommandBars("PivotTable PopUp").Enabled = True
CommandBars("PivotChart PopUp").Enabled = True
CommandBars("Form PivotTable Popup").Enabled = True
CommandBars("Form PivotChart Popup").Enabled = True
CommandBars("View PivotTable Popup").Enabled = True
CommandBars("View PivotChart Popup").Enabled = True
CommandBars("Table PivotTable Popup").Enabled = True
CommandBars("Table PivotChart Popup").Enabled = True
CommandBars("View Design Field Popup").Enabled = True

This enables the right click on Pivot Chart and Table view only - so that user can change the chart type and fields in the design.

I am assuming all other commandbars are disabled at startup for this to work.

Cheers,

Rob

 

[natep26]

Did you ever find a solution to your problem. I've been playing with the following line of code attached to a command button.

DoCmd.RunCommand acCmdViewFieldList

But am having trouble getting it to work.

Any Ideas??

Thanks

Problem resolved by creating a custom toolbar with only the fieldlist control available.