Oct 3 2007, 03:54 AM
I have a problem.
I was created a report with a wizard, but when i go in VBA section, the report is not inside while the forms yes.
Please help me.
Do you mean you can't see the required Report object in the VBA Explorer pane?
If that the case, the Report does not have any code and the Wizard decides to set the Property "Has Module" to False / No.
To create the Module for the Report, all you have to do is to select "[Event Procedure]" in one of the Report's Events, e.g. the Open Event then click the Build button with 3 dots to the right of "[Event Procedure]". Access will automatically creates the Module associated with the Report, set the Property "Has Module" to True and take you to the Module / VBA window with pre-built stub for the Open Event.
Alternatively, you can simply set the "Has Module" Property to True in the DesignView of the Report and the VBA Explorer window will show the Report object.
Oct 3 2007, 06:05 AM
Now it's works fine.
You're welcome ... Glad to help ...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here