lrarmbruster
New member
- Local time
- Today, 08:22
- Joined
- Oct 17, 2012
- Messages
- 6
Is it possible to create an embedded macro in a report?
I want to be able to click on a value in the current report and have it open another report depending on the value that is selected; however, when I select the column I want to use to create the macro on I am not given any options to do so under the events tab in the properties tool bar.
Is it not possible to do what I want to do or is there a different way to go about this.
Another issue I am having trouble with is getting the macros to work in SharePoint. I tried using a table to run an embedded macro on and it worked in access but when synced to the SharePoint site I receive an error saying the object does not contain the object "field name used in macro if statement". Does SharePoint not support embedded Macros or is there another step I need to complete to make the embedded Macro work correctly?
I am using SharePoint 2010 and Access 2010.
I want to be able to click on a value in the current report and have it open another report depending on the value that is selected; however, when I select the column I want to use to create the macro on I am not given any options to do so under the events tab in the properties tool bar.
Is it not possible to do what I want to do or is there a different way to go about this.
Another issue I am having trouble with is getting the macros to work in SharePoint. I tried using a table to run an embedded macro on and it worked in access but when synced to the SharePoint site I receive an error saying the object does not contain the object "field name used in macro if statement". Does SharePoint not support embedded Macros or is there another step I need to complete to make the embedded Macro work correctly?
I am using SharePoint 2010 and Access 2010.
