[AccessD] Solution Looking for a Problem

Actually, it's a space that's the default delimiter for Split.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Wednesday, January 21, 2009 4:44 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Solution Looking for a Problem

Well, I like comma for delimiting but that's just habit.  Pipe is, I
think, more conventional - I should use that.  But the function will
work with any delimiter - I think help said blank is the default. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, January 21, 2009 4:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [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


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