jwcolby
jwcolby at colbyconsulting.com
Wed Jan 21 15:39:29 CST 2009
I published a class to parse openargs. I like to set up openargs in a syntax as follows: VarName1=VarVal1;VarName2=VarVal2; In the class I grab the openargs, parse them, then store them in a collection keyed on VarName. The class then has a method to pass in a varname and get back a varval. I like doing it this way because the class can just be initialized in the header of any form (I do it in my form class of my framework actually) and then the form can have a standard syntax for obtaining the openargs, by name. http://www.databaseadvisors.com/downloads.asp Second entry down. John W. Colby www.ColbyConsulting.com Rocky Smolin at Beach Access Software 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/> > > > > > >