Active form

B

Boss

Hi,

I am preparing a MIS which has lots of pivot-forms.

I am thinks of exporting them to excel and viewing graphs of them using
below code

DoCmd.OpenForm "test", acFormPivotTable
DoCmd.RunCommand acCmdPivotTableExportToExcel

DoCmd.OpenForm "test", acFormPivotTable
DoCmd.RunCommand acCmdPivotChartView

This code works for the form "TEST".

Please help me so that it works for the active form. If this happens i will
have two button to "export to excel" or "view graph". user would just click
his report and do what he likes.

Thanks!
Boss
 
J

Jim Burke in Novi

You refer to a form's name with Me.Name, if that's what you're looking for.
 
B

Boss

No.. I amlooking for some code which works on the active form.

can i use

me.activefrom

help me get solve this issue.

Thanks!
Boss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top