Hi Bob,
> "This is a nice piece of work!"
thank you, Glad you like my Code Documenter ;) I have a list of about 20 bugs/comments from Tom van Stiphout, so lots to fix and make better :) I already fixed the progress meter (in my copy) -- now it is counting just the objects than can have code for the total number instead of all of them like tables and queries too ... so it goes to 100% instead of stopping about 29% or so ...
I am using my Code Documenter for two of my projects and am making changes as I need them myself. I will probably post an update in a couple days.
for latest version of my Code documenter, check here:
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/
then click on:
CrystalsCodeDocumenter_120130_311p_BETA__ACCDE_TXT.zip
or whatever is the file with CodeDocumenter in the name. Each time I upload a new version, I delete the old one and change the filename
The forms are nice, but the real gold is in the data and the fact that all the code for a project can be easily manipulated with update queries and VBA. My documenter just got 33,800 lines of code in an Access 97 database that I am converting to 2010. To give you some idea
how much that is, imagine 50 lines per page. That is about 675 pages if
it were printed. A ream of paper is 500 pages. If it takes an hour
per page to correct, that would be a lot of time! Perhaps 5 pages an hour
could be corrected. That is unrealistically fast, but at that rate, it
would take 135 hours to correct for the compiler. this is just one of about 5 databases, which probably contain many of the same procedures. Once I correct it in one of the databases, I will want a way to easily replace the code in the other ones
~~~~~~~~~~
the compiler cannot check this
to ensure that CotDtlDtlDisCrn is in the RecordSource or the name of a control:
Me![CotDtlDtlDisCrn]
the compiler CAN check the
reference if it is written this way:
Me.CotDtlDtlDisCrn
'don'tcha just love these variable names ?!?
I found out from my documenter that 716
lines in the 97 application I am converting contain this phrase: Me![
Many of the lines have multiple occurrences of what is being changed. I estimate 1000 to 2000 changes
due to this one thing (Me![). Using 1500 and planning 1 minute to make
and test each change, that is 25 hours. There are other types of changes – I am
just using this one as an example.
I plan to write a another tool
that uses a table of values and will search/replace the code. The
reference could use any one of several hundred fields (which, conveniently, My Analyzer gets for me :). Replacing "Me![" with "."
is not enough – the close bracket must be removed too, so it will require code to automate the changes.
The other project I am using my Code Documenter on is a database redesign. I added the ability to flag procedures and modules so I can keep track of what code I have moved. Also, I did not write the original database so features are all over the place. It will be easy to find them in the code -- and I can have the actual database open in another window :)
When I am done putting fires out and I have a few days, I am going to run the Code Documenter on all my major databases and mark my latest and best code :)
> "Syntax error (missing operator)in query expression '(ObjName = 'rptNCMRs') AND (ObjTypID=-32764) AND (FileID=3);'
thanks, I will look -- perhaps ObjTypID or FileID needs to be qualified with the table name ... I'll add this to my bug list :)
Warm Regards,
Crystal
Microsoft MVP
remote programming and training
Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: Robert Peterson
Hi Crystal,
I figured out what the ObjTypeID and FileID are.
May the error be because the query behind the report depends on a form to supply a date range?
Strange that it only appears on this one though because there are other reports that use the same technique to limit the data returned...
Bob Peterson
-----Original Message-----
From: Robert Peterson
Subject: RE: [MS_AccessPros] Re: New file uploaded -- Crystal's Code Documenter
Hi Crystal,
This is a nice piece of work!
I ran it against a database that we use every day and it came up with an error.
"Syntax error (missing operator)in query expression '(ObjName = 'rptNCMRs') AND (ObjTypID=-32764) AND (FileID=3);'
It hangs at that error then when I press OK it finishes up fine.
I looked at the report and the query it is based on and don't see any errors. Perhaps you can shed some light as to what ObjTypID=-32764 and FileID=3 mean.
I hope this helps you.
Thanks
Bob Peterson
-----Original Message-----
From: Crystal
Subject: Re: [MS_AccessPros] Re: New file uploaded -- Crystal's Code Documenter
thanks, Andrew!
I made some "enhancements" to it when I was tired ... it works again ;)
I just uploaded another version. I very much appreciate your comments
Warm Regards,
Crystal
Microsoft MVP
remote programming and training
Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: acravenrohm
I'm getting an:
ERROR 35 WriteProcTotals
Sub oder Function nicht definiert
Running a German Access 2010
It came more than 100 times before I gave up and killed it :-(
Six References seem to be Ok.
--- Crystal wrote:
>
>
> Hello,
>
> This email message is a notification to let you know that a file has
> been uploaded to the Files area of the MS_Access_Professionals group.
>
> File :
>/Crystal/CrystalsCodeDocumenter_120129_7p__ACCDE_TXT.zip
> Uploaded by : strive4peace2008 <strive4peace2008@...>
> Description : Document Modules, Procedures, and Lines of Code in
>your Access databases! Download my free utility (Access 2007 and 2010).
>I am happy to be finally done (enough) with my code documenter to share
>it with you. There is still so much I want to do but I have to start
>using it to do my work! This is a beta. Please send me your comments
>and ideas! Watch the video on my YouTube channel:
>http://YouTube.com/LearnAccessByCrystal ~Thanks, Crystal
>
> You can access this file at the URL:
> http://groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/Cr
> ystalsCodeDocumenter_120129_7p__ACCDE_TXT.zip
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.htm
> l
> Regards,
>
> strive4peace2008 <strive4peace
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar