[AccessD] Looking at lines of code in code

This is to check that each of the message boxes in the system appears in the
language table where I store the multiple language translations.

So, once I find the call to TranslateMessage in the module, then I have to
look in another table - tblLanguage-Msgboxes - to see if the phrase to be
translated, which is the function call's argument, is in the table.  If not
I want to add it.

So searching for the phrase TranslateMessage would do it but each time I
find it, I'd have to copy the argument, flip over to the table and do a
search.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Saturday, March 10, 2007 8:19 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Looking at lines of code in code

Why don't you just search for that phrase in the find dialog in the editor?
That would not limit you to just the form modules but it would allow you to
see each instance of that phrase. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Saturday, March 10, 2007 11:09 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Looking at lines of code in code

Dear List:
 
I have a need to programmatically look at every line of code behind all
forms looking for the string "TranslateMsgbox".
 
I'm floundering around here a bit.  I know how to cycle through the forms
collection.  But once I open the form in design view and Set frm =
Forms(strFormName) I can't figure out how to loop through every line of code
behind the form.  
 
Any suggestions appreciated.
 
MTIA
 
Rocky
 


 	
	
--
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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007
6:53 PM