If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 . |
#12
|
|||
|
|||
customizing "documentor" output
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 . |
#13
|
|||
|
|||
customizing "documentor" output
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 |
|
Thread Tools | |
Display Modes | |
|
|