RE: [MS_AccessPros] ms access 2007 form with graph object

 

i HAVE GOTTEN MOST OF WHAT i NEED TO WORK.

i AM USING THE EXCEL MACRO CREATION AS A BASIS, AND THEN MIGRATE THE CODE OVER TO VBA/MS ACCESS.

 

2 THINGS i COULD USE HELP ON ARE:

AN EXPLANATION OF THE VBA CODE GENERATED WHEN IT USES "SELCT" AS IN THE FOLLWING: THIS MACRO IS ENABLES THE DATABLE FOR THE PIVOTCHART, i CANNOT FIND THE EQUIVALENT SYNTAX TO GET THIS TO WORK IN MS ACCESS VBA.

 

iS THERE AN EQUIVALENT FOR THE "sETeLEMENT" ?

 

 

' show_data_table Macro
'

'
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.SetElement (msoElementDataTableShow)

 

 

tHE OTHER ISSUE I AM HAVING, I CANNOT DINF A WAY IN mS ACCESS VBA TO TOGGLE THE DATATABLE ON/OFF IN A PIVOTCHART.

 

tHANKYOU ALL IN ADVANCE

TERENCE

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (7)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___