[AccessD] VBE Experience anyone?

Take a look at these

http://www.carlprothman.net/Default.aspx?tabid=81

http://www.astahost.com/info.php/vba-oracle_t10766.html


**************************************************
* Patricia O'Connor    
* Information Technology Specialist 3 (Programming) 
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
**************************************************
 

> 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Mark A Matte
> Sent: Friday, March 28, 2008 01:53 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] VBE Experience anyone?
> 
> 
> Hello All,
>  
> I am using the code below to loop through the Modules and 
> find stuff.  It always points to the current db.  Is there 
> any way to point this to a different database...if so anyone 
> know the syntax?
>  
> Thanks Again,
>  
> Mark A. Matte
>  
> ***************
>  For Each vbComp In VBE.VBProjects(1).VBComponents        
>      With vbComp                
>         StartLine = 1                
>         StartColumn = 1                
>         EndLine = vbComp.CodeModule.CountOfLines                
>         EndColumn = 60            
>         strCode = .CodeModule.Lines(1, .CodeModule.CountOfLines)
> 
> *************
> _________________________________________________________________
> Test your Star IQ
> http://club.live.com/red_carpet_reveal.aspx?icid=redcarpet_HMTAGMAR
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>