Hi Duane,

Comments below...

Duane Hookom wrote:
I hate the name "Object Definitions" and generally
changed it to "ObjDef" immediately after it saved.

Understood. I was just playing with it for now.

The code to create the form is long gone since I worked
for another company.

Ah, I see. No problem.

The code was used in the BR Code Stuffer
http://www.rogersaccesslibrary.com/Otherdownload.asp?
SampleName='BR%20Code%20Stuffer%20Add-In/Builder%20for%
20Access%2097'.

Of course I have this already. I'm pretty sure I have ALL
your samples! :-)

I distributed the Code Stuffer as an MDE. There is a
utility in the Code Stuffer that allows the user to
easily create a MsgBox that is actually a
MenuBox with user provided options and captions. If the
Code Stuffer wasn't an MDE I think I could have copied a
form from the Code Stuffer into the developer's MDB.
Because of the MDE, I had to use code to create the form
and add controls. There is a table in the wizard that
contains the properties required to build the form on the
fly. This table was created by using the documenter. You
won't see the code to do this in the Code Stuffer
wizard because it is an MDE file.

Well this is quite interesting. I have played with the
Code Stuffer before, but I must have overlooked that
aspect. I understand about it being an MDE so no code is
available. I never realized you could spontaneously create
forms/controls using information stored in a table. So you
used the Documentor information as a base for the form
information? As Spock would say, "Fascinating."

Do this cause database bloat by constantly creating new
forms/controls?

There are several wizards in Access that create forms and
reports.

Yep, but too bad you can't study the code at how to create
the forms/controls since they are MDE wizards. I vaguely
recall that Microsoft had some wizard code available at
some point in time that could be downloaded. Maybe I'm
mistaken. I'll have to dig around my archives and look
around.

If you use Access 97 and write code but don't use the
Code Stuffer, you should.

Yes, Master. Apologies for my disobedience.
;-)

Thanks again for the information, it has been very
interesting.

--
Jeff Conrad
Access Junkie
Bend, Oregon