customizing "documentor" output

Hi Duane,

Just as a follow-up, I found these Viewable Access 97
Wizard code download files on Microsoft's site:

ACC97: Viewable Wzlib80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151194

ACC97: Viewable Wzmain80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151196

ACC97: Viewable Wztool80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151218

ACC97: Viewable Utility.mda Code Available in Download
Center:

http://support.microsoft.com/?id=151219

Excellent!
I know what I'll be looking at for a while!

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
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
.

Having the viewable wizards doesn't mean all code in the wizards is visible.
There are still snippets that are not available for viewing.

In the BR Code Stuffer wizard, the tables with information to build the form
are in brObjDef and brtblObjProperties. You might want to see how these are
used in the queries in Code Stuffer.

--
Duane Hookom
MS Access MVP


"Jeff Conrad" wrote in message
...
Hi Duane,

Just as a follow-up, I found these Viewable Access 97
Wizard code download files on Microsoft's site:

ACC97: Viewable Wzlib80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151194

ACC97: Viewable Wzmain80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151196

ACC97: Viewable Wztool80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151218

ACC97: Viewable Utility.mda Code Available in Download
Center:

http://support.microsoft.com/?id=151219

Excellent!
I know what I'll be looking at for a while!

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
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
.

Hi Duane,

Oh don't worry, I'll be looking through the Code Stuffer
pretty thoroughly!! Thanks for pointing out the specific
tables to look for.

Right now I'm just having fun going through the wizard
code and playing with things. I feel like a kid looking at
the teacher's answer sheet before a big quiz!
g

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
Having the viewable wizards doesn't mean all code in the
wizards is visible. There are still snippets that are not
available for viewing.

In the BR Code Stuffer wizard, the tables with
information to build the form are in brObjDef and
brtblObjProperties. You might want to see how these are
used in the queries in Code Stuffer.

--
Duane Hookom
MS Access MVP


"Jeff Conrad" wrote in message
...
Hi Duane,

Just as a follow-up, I found these Viewable Access 97
Wizard code download files on Microsoft's site:

ACC97: Viewable Wzlib80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151194

ACC97: Viewable Wzmain80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151196

ACC97: Viewable Wztool80.mde Code Available in Download
Center:

http://support.microsoft.com/?id=151218

ACC97: Viewable Utility.mda Code Available in Download
Center:

http://support.microsoft.com/?id=151219

Excellent!
I know what I'll be looking at for a while!

--
Jeff Conrad
Access Junkie
Bend, Oregon