Rocky Smolin
rockysmolin at bchacc.com
Wed May 23 10:03:00 CDT 2012
Just thought of a problem looking for PRIVATE - it occurs multiple times in the module. I'd only want to find the first occurrence per module. Well, a few lines of code will do the job. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Wednesday, May 23, 2012 7:58 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Jumping Screen Fix - now I know how but not why Yes, copy and paste is your friend. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, May 23, 2012 9:29 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Jumping Screen Fix - now I know how but not why So you can put multiple lines in your replace? Didn't know that. However, I have a convention of putting all my DIMs at the top of my module followed by the APIs if any. I guess I could look for the first occurrence of PRIVATE and then add the RESIZE event lines plus PRIVATE. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Wednesday, May 23, 2012 7:12 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Jumping Screen Fix - now I know how but not why Rocky, If you're going to add this to every form's module you could use search and replace. Designate the Find for something that is in every form e.g. " Option Explicit" And then just include that and a line break as the first part of your "replace" string. HTH John B -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com