[AccessD] Solution Looking for a Problem

...a hearty me too ...I looked at the current spaghetti I use for doing this 
and grimaced :(

William

--------------------------------------------------
From: "Dan Waters" <dwaters at usinternet.com>
Sent: Wednesday, January 21, 2009 4:24 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Solution Looking for a Problem

> Hey - this would have saved me a lot of time!
>
> Thanks!
> Dan
>
> -----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 2:46 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Solution Looking for a Problem
>
> 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
>