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