[AccessD] Open Multiple Instances of a Form and passing a parameter

To avoid the argument containing a delimiter character, I use the 'cents'
character, which hasn't been on anyone's keyboard for many years.

The cents character is Chr(162).

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert
Sent: Tuesday, August 07, 2012 10:54 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Open Multiple Instances of a Form and passing a
parameter

>
> Rocky Smolin
> I parse multiple arguments in a single string using the Split 
> statement - works a treat.
>

Until:
* One of your arguments contains the delimiter character, then your split is
off
  - Solution: write code to quote the delimiter in your arguments. Write
your own custom split
* You have to pass Nulls
  - Solution: parse your argument, write 'Null' if null, and the proper
type-formatted string if not.
* You need unordered arguments, or you have to add, remove, and update
argument values
  - Solution: write code to store arguments in Name=Value pairs, write
parsing code to restore values

I have written all of that code, and my conclusion is it is JUST BETTER to
pass the typed arguments directly into the form.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com