Re: User defined fields - UDF in Folder Issues

In article <3EFDBBB5.7050806@phillipsfam.com>, Reed Phillips wrote:
> Will Listing 24.2 on page 562 in Sue's book solve the problem? It seems
> to suggest it will
>
> If so, can I add this Sub to my form script and call it from a
> CommandButton? Or does need to run as a seprate VB application?
>
> Sorry for the long winded post.
>
Don't have the book, but you probably do want to create all your custom
fields as fields in the folder in all your folders that use them, even
though you publish the form to the org forms library. Normally, you would
do this by opening a new form in the folder, going into design mode, and
typing in the fields that you want, using the category of fields in the
form. Just be sure to use fields of the same name, type, and format as
you used in the form definition. As you have three to do, perhaps you will
have an easier time writing a script to do it in CDO (assuming you don't
have to learn CDO scripting first).

Hollis D. Paul [MVP - Outlook]
Hollis@outlookbythesound.com
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com...D=TECH&LN=EN-US

Mukilteo, WA USA

If I have the form in the matching public folder, I will need to publish
to both the folder and the library, or not use the library at all. I
was told this is not a good practice. I use to do it this way. I would
open the form in the appropriate folder, modify it and publish to all
the folders where the form is used. Was I correct to use this method in
the first place?

Hollis D. Paul wrote:
> In article <3EFDBBB5.7050806@phillipsfam.com>, Reed Phillips wrote:
>
>>Will Listing 24.2 on page 562 in Sue's book solve the problem? It seems
>>to suggest it will
>>
>>If so, can I add this Sub to my form script and call it from a
>>CommandButton? Or does need to run as a seprate VB application?
>>
>>Sorry for the long winded post.
>>
>
> Don't have the book, but you probably do want to create all your custom
> fields as fields in the folder in all your folders that use them, even
> though you publish the form to the org forms library. Normally, you would
> do this by opening a new form in the folder, going into design mode, and
> typing in the fields that you want, using the category of fields in the
> form. Just be sure to use fields of the same name, type, and format as
> you used in the form definition. As you have three to do, perhaps you will
> have an easier time writing a script to do it in CDO (assuming you don't
> have to learn CDO scripting first).
>
> Hollis D. Paul [MVP - Outlook]
> Hollis@outlookbythesound.com
> Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
> http://search.support.microsoft.com...D=TECH&LN=EN-US
>
> Mukilteo, WA USA
>
>