[AccessD] Access 2007 Report - Buttons Quit Working

Brad:

After you copy the event code (excluding the Private Sub and End Sub lines)
delete the event code (including the Private Sub and End Sub lines) you will
need to recreate it.

Display the property sheet for the button (right click button, select
Properties)-->Events Tab-->On Click Event-->Drop down combo box and select
[Event Procedure]--->click builder button to the right (button with the
three dots).  Then it will flip to the VBA page and you'll see the Private
Sub and End Sub lines.  Paste your copied code in there.

HTH

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, April 11, 2013 5:32 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 Report - Buttons Quit Working

Rocky,

I tried the steps that you suggested (copy out the code, delete the module,
and recreate it, pasting back the code).

When I try to recreate the code, the VBA editor is opened, but it is not
showing the buttons Click event but it is showing code for another button.

I am not sure how things work behind the scenes, but it appears that the
"links" between the buttons on the report and the VBA code are messed up.

Thanks for your help.

Brad 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin
Sent: Wed 4/10/2013 7:33 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 Report - Buttons Quit Working
 
How about if you copy out the code, delete the module, and recreate it,
pasting back the code?


Rocky