Re: Parsing OpenArgs statements

Hi.

Anyone got any suggestions?

Please see the tip, "How to get individual items passed to another form
using OpenArgs," on the following Web page:

http://www.access.qbuilt.com/html/vba4.html

Replace the comma in the InStr( ) statement with a pipe character.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"ManningFan" <manningfan@xxxxxxxxx> wrote in message
news:1175281570.681345.193960@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm trying to figure out how to do this, my form may have anywhere
from 1 to 5 arguments passed. My OpenArgs statement looks something
like this:

Arg1 | Arg2 | Arg3 | Arg4 | Arg5

I need to know if there's an easy way to pull everything prior to the
first "pipe" ( | ), and then everything from the first pipe to the
second pipe, then everything from the second pipe to the third pipe,
etc...

Anyone got any suggestions?



.

Relevant Pages

  • Re: Parsing OpenArgs statements
    ... ManningFan wrote: ... My OpenArgs statement looks something ... I need to know if there's an easy way to pull everything prior to the ... second pipe, then everything from the second pipe to the third pipe, ...
    (comp.databases.ms-access)
  • Re: Parsing OpenArgs statements
    ... My OpenArgs statement looks something ... second pipe, then everything from the second pipe to the third pipe, ... Dim MyArray() As String ...
    (comp.databases.ms-access)
  • Parsing OpenArgs statements
    ... My OpenArgs statement looks something ... I need to know if there's an easy way to pull everything prior to the ... second pipe, then everything from the second pipe to the third pipe, ...
    (comp.databases.ms-access)