Brad Marks
BradM at blackforestltd.com
Wed May 5 14:20:00 CDT 2010
Drew, I have only looked at the system tables a few times, so I am no expert. In MSySObjects I see Report002 (Proper Case). Is there another place to look? I can't remember for sure, but it is possible that we had this report named REPORT002 earlier and then renamed it to Report002. Thanks for your help, I appreciate it. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Wednesday, May 05, 2010 1:40 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Puzzler for this week -DoCmd.OutputTochangingReportName to Upper Case,but not all of the time Unhide the system tables, and see how they are named within those tables. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Wednesday, May 05, 2010 1:39 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Puzzler for this week - DoCmd.OutputTochangingReportName to Upper Case, but not all of the time Drew, Good question - at first I thought that this might be the answer. However, when I looked at the Access 2007 Navigation Pane to view the report names, I see Report001 Report002 Report003 Report004 Report005 Etc. (all Proper Case) Thanks, Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Wednesday, May 05, 2010 1:27 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Puzzler for this week - DoCmd.OutputTo changingReportName to Upper Case, but not all of the time How is the report named in the database? Are they all proper case? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Wednesday, May 05, 2010 1:25 PM To: Access Developers discussion and problem solving Subject: [AccessD] Puzzler for this week - DoCmd.OutputTo changing ReportName to Upper Case, but not all of the time All, After seeing the incredible energy, time, and expertise invested in a recent Puzzler, I thought that it would be fun to share this one. I recently discovered this bug (feature?). I have implemented a little work-around (duct taped it). Now this has turned into more of a curiosity question. Has anyone else ever seen something like this with VBA code? I copied the code directly from the program into this e-mail. Brad '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' ' VBA Puzzler ' DoCmd.OutputTo changing Report Name to Upper Case, but not all of the time ' ' This is the strangest thing I have seen for awhile. ' ' Report002 (lower case) is plugged into str_Report_Name ' ' The first Msgbox displays Report002 (Lower Case) ' The second Msgbox displays REPORT002 (Upper Case) ' ' It appears that the DoCmd.OutputTo command is changing Report002 to REPORT002 ' ' Now the really fun part... If I plug in Report001 or Report003 they are ' NOT changed to Upper Case ' ' Here is how str_Report_Name is defined at the beginning of the program ' Global str_Report_Name As String str_Report_Name = "Report002" MsgBox "Before OutputTo str_Report_Name = " & str_Report_Name DoCmd.OutputTo acOutputReport, _ str_Report_Name, _ "HTML(*.html)", _ str_Generated_Report_File_Name, _ False, _ "", _ 0, _ acExportQualityPrint MsgBox "After OutputTo str_Report_Name = " & str_Report_Name '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.