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: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robert Peterson
Sent: Tuesday, January 31, 2012 9:23 AM
To: MS_Access_Professionals@yahoogroups.com
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: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Monday, January 30, 2012 5:28 PM
To: MS_Access_Professionals@yahoogroups.com
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 <strive4peace2008@...>
>
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar