[AccessD] Jumping Screen Fix - now I know how but not why

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



More information about the AccessD mailing list