Re: OpenForm OpenArgs - multiple arguements

On Tue, 13 Feb 2007 21:57:35 -0500, Mark J Kubicki wrote:

I need to pass several values to a form

what is the proper delimitation for setting the value of multiple
arguments?

the values are:
string:"true",
and
2 field values on the current form (which opens the second):
me.Manufacturer.value, and me.CatalogueNo.value

thanks in advance,
mark

The OpenArgs argument is a string.
You can separate the various inner strings using any character
(hopefully, not a character that might be found in an inner string).
I've used the comma as a separator below. You could also, for example,
use the pipe (|) character.

You wish to pass the word "True" as a string and not True as an Access
constant number (-1), is that correct?

DoCmd.OpenForm "FormName", , , , , , "True" & "," & Me![Manufacturer]
& "," & Me![CatalogueNo]

This will pass to the second form like this:
True,Lockheed,123

In the second form's Load event, you would parse the openargs into
it's 3 inner strings. If you need help with that, post back.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: A critique of cgi.escape
    ... backward compatability. ... Character encoding and character escaping are separate jobs with ... separate requirements that are better off handled by separate code. ... The resulting string might be a byte string or it might still be unicode: ...
    (comp.lang.python)
  • RE: Split non delimited data into multiple cells
    ... I used a column as a counter, and then used the mid statement in separate ... It separates each character into its own cell. ... charcter of the string in its own cell. ... I am importing an ascii file and can separate the data manually during ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Getting a filename and directory path from a string in RPG?
    ... I have a string that looks like this: ... filename in separate variables. ... I don't think CHECKR will help in this case. ... just be the last character in your string. ...
    (comp.sys.ibm.as400.misc)
  • How to separate a string into char array
    ... How to separate the string into a char array or a string array just have on ... character per element? ...
    (microsoft.public.dotnet.languages.csharp)
  • [TOMOYO #15 3/8] Common functions for TOMOYO Linux.
    ... This file contains common functions (e.g. policy I/O, pattern matching). ... Since TOMOYO Linux is a name based access control, ... TOMOYO Linux's string manipulation functions make reviewers feel crazy, ... the Linux kernel accepts all characters but NUL character ...
    (Linux-Kernel)
Quantcast