[AccessD] Solution Looking for a Problem

I think you mean "pipe delimited", not "comma delimited" based on how you are calling 
Split()

Yep Split() is incredibly useful for this sort of thing.

If you weren't already familiar with Split(), then maybe you aren't aware of Join() either - it's 
another useful function.

-- 
Stuart

On 21 Jan 2009 at 12:45, Rocky Smolin at Beach Access  wrote:

> I needed to pass multiple arguments to a pop up form through OpenArgs.  So I
> needed to parse them.  Found this on the web:
>  
> Dim Hold_OpenArgValues() as String
> Hold_OpenArgValues()=Split(Me.OpenArgs, "|")
>  
> except I DIMmed Hold_OpenArgValues as varOpenArgs as Variant.
>  
> and walla!  the three comma delimited arguments I passed showed up just
> where they were supposed to:
>  
>     Me.txtPartNumber = varOpenargs(0)
>     Me.txtXactQty = varOpenargs(1)
>     Me.txtAuditReference = varOpenargs(2)
> 
> Note the array is zero based. 
>  
> One line to parse openargs! (not counting the DIM)  
>  
> Who knew?
>  
> 
> 
>  	
> 	
>  
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 858-259-4334
> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> 
> www.bchacc.com <http://www.bchacc.com/> 
> 
>  
> 
>  
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com