I am new to access. Very familiar with Excel/VBA. We have created an access macro object called Reports. We would like to write some VBA code that will be run from the Access macro object Reports. Seems like it should be easy to run some code from the macro.
All we want to do is write a small subroutine that will run from the macro "Reports" object.
Here is VBA code we stuck in Module 1:
Code:
Sub Youhavemadeittomodule1()
Msgbox "You are in Module 1. You can start writing VBA code here."
End SUb
Tried as a function as well.
We keep getting the following error: Microsoft Access cannot find
the name 'Youhavemadeittomodule1' you entered in the expression.
We tried RunCode, RunDataMacro and RunMacro from in the macro object expression builder - all to no avail.
How do I get a macro object to run VBA code in a module?
Thanks!