[AccessD] Solution Looking for a Problem

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Wed Jan 21 19:16:27 CST 2009


Yes, space.  Is there a difference? (both chr(20), yes?) 


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 Charlotte Foust
Sent: Wednesday, January 21, 2009 5:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [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

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