Code in Access 2016

Question

Hi there,

I'm using Access 2016 and using a database I created using a previous version. I've created a button that opens up a report, but I need to change edit the code to change the path of the file it's trying to point to.

In design view, if I go to the details of the Embedded Macro for the button it takes me to a page where I can assign an action to it.

From here, how do I see / edit the actual code as they're isn't a developer tab?

Thanks!

Answer 1

That IS the actual code! It would appear you used the Command button wizard to create your open report button. The wizard created an embedded macro. The macro language is a separate language in Access.

but I need to change edit the code to change the path of the file it's trying to point to.

I don't understand what you mean by that. Reports are objects embedded within your Access database. There are no "files" to change. So the concept of pat is not applicable here.

If you want the button to open a different report then pull down the arrow to the right of the Report name and select a different report.

And, by the way, the macro interface hasn't changed since Access 2010.