Brad Marks
BradM at blackforestltd.com
Wed Apr 10 19:38:19 CDT 2013
Rocky, I will try this tomorrow. Thanks, 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Wednesday, April 10, 2013 4:25 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 Report - Buttons Quit Working Dan, The Click event is tied to VBA code for each of the buttons and the code is there. None of them work, however. I added a new button and added VBA code for it. It works nicely. I have never seen this happen before. I do have a backup copy of the accdb file and I believe that I can delete the report and then copy it from the backup file if necessary. Thanks for the advice. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Dan Waters Sent: Wed 4/10/2013 5:48 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 Report - Buttons Quit Working Hi Brad, A quick check would be to make sure that the Click event has something in it like 'Event Procedure'. Also check to be sure the code is still there. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Wednesday, April 10, 2013 4:53 PM To: Access Developers discussion and problem solving Subject: [AccessD] Access 2007 Report - Buttons Quit Working All, I have an Access 2007 Report that has a number of Command Buttons. This report has not been changed in several months. All of a sudden, none of the Command Buttons do anything. I have done a decompile and compact-repair, but this did not fix the problem. If I add a new button, it seems to work fine, but none of the original buttons work. Any advice would be appreciated. Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=6D84D2847F.C4ACC -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=D0BE4289AF.84C11