UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Report in VBA Section    
 
   
luigen
post Oct 3 2007, 03:54 AM
Post #1

New Member
Posts: 16
From: Castano Primo - Milan - ITALY
Hi guys.
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.
Thanks
Luigi
Go to the top of the page
 
+
vtd
post Oct 3 2007, 04:49 AM
Post #2

Retired Moderator
Posts: 19,667
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.
Go to the top of the page
 
+
luigen
post Oct 3 2007, 06:05 AM
Post #3

New Member
Posts: 16
From: Castano Primo - Milan - ITALY
Now it's works fine.
Thanks
Luigi
Go to the top of the page
 
+
vtd
post Oct 3 2007, 06:32 AM
Post #4

Retired Moderator
Posts: 19,667
You're welcome ... Glad to help ...
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 01:55 AM